Prevent decimal input

PHOTO

Wed Jul 20 2022 16:50:38 GMT+0000 (UTC)

Saved by @gofunk1 #powerapps

If(Value(DataCardValue14_1.Text)/Value(RoundDown(Value(DataCardValue14_1.Text),0))<>1, Notify("No decimal,please try again!",NotificationType.Error);Reset(DataCardValue14_1))

https://powerusers.microsoft.com/t5/Building-Power-Apps/Prevent-User-From-Inputting-a-Decimal/m-p/258674#M75671

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Retrive a user photo from SharePoint

"https://[tenantName].sharepoint.com/_layouts/15/UserPhoto.aspx?Size=L&AccountName=" & ThisItem.Employee.Email

Fix: Combobox/Search is empty check not working - Power Platform Community

If(
    (IsEmpty(ComboBox42.SelectedItems) || IsBlank(ComboBox42.Selected.Value)) && IsBlank(ComboBox42.SearchText),
    SubmitForm(EditForm1),
    Notify(
        "Please fill in the Combo Box!",
        Error
    )
)

Get user photo from office365 connector from gallery

Office365Users.UserPhotoV2(ThisItem.PeopleColumn.Email)

#sharepoint #filter #powerapps

Set a variable with the current users first name, from the currentUser variable

Set(currentUser, User()); //require for the on start property

Set(varFirstName, Trim(Last(FirstN(Split(currentUser.FullName," "), 1)).Result))

Extract values from a collection

Concat(selectedDesks, " " & Title & Char(44))

Prevent decimal input

If(Value(DataCardValue14_1.Text)/Value(RoundDown(Value(DataCardValue14_1.Text),0))<>1, Notify("No decimal,please try again!",NotificationType.Error);Reset(DataCardValue14_1))

Add image to variable Power Automate

<img src="data:image/jpeg;base64,@{outputs('Get_file_content_using_path')?['body'].$content}" alt="My Image" />
  
  <"data:image/jpeg;base64," alt="My Image" />
    
   outputs('Get_file_content_using_path')?['body'].$content

Extract value from combo box

Concat(AddToWatchList.SelectedItems.Value,Value)

Combo box values to collection

ForAll(Tags.SelectedItems, Collect(colTags, {Value: ThisRecord.Value}))

#powerapps #json

Convert collection to JSON

JSON(colTags.Value,",")

#powerapps #html

Launch URL by clicking on an image

Launch("https://www.bing.com")

#powerapps #filter #sortby

Show newly created items first / sort by most recent entry, will only show items created today

Sort(Filter('YouTube Resources', Text(Created,"mm/dd/yyyy") = Text(Today(),"mm/dd/yyyy")), Created,Descending)

#powerapps #validation #combobox

Validate/Validation text box length and/or combo boxes contain data

DisplayMode= If(
    IsBlank(varName) Or IsBlank(varName) Or Len(TextInputBox.Text) < 11,
    DisplayMode.Disabled,
    DisplayMode.Edit
)


OnChange= Set(varName, Combobox.Selected) //Sets the variable to the combo box values or record

#powerapps #validation #combobox

Text input validation - turns border red

If(
    Len(TextInput.Text) = 11,
    RGBA(
        0,
        18,
        107,
        1
    ),
    Color.Red
)

#powerapps #displaymode #lookup

Lookup value against a text input and disable or enable displaymode

If(IsBlank(LookUp('OSS Comments' , Comments = TextInput3.Text)), DisplayMode.Edit, DisplayMode.Disabled)

or

If(IsBlank(LookUp('OSS Comments' , Comments = "ABCD")), DisplayMode.Edit, DisplayMode.Disabled)

Browse more snippets >>