thiscodeWorks - Organizing the best of code online

Snippets Collections

Recent | Popular

List view

#powerapps #powerautomate #null #empty #flow

Pass a null or empty value from Power Apps to a flow

YouTubeDropperButton.Run(varSplitText, (If(IsBlank(Notes.HtmlText), "", Notes.HtmlText)))

#powerapps #split #text #trim

Sets a variable with spilt text from a link - YouTube in this case

Set(varSplitText, (Concat(LastN(Split(TextBoxNew.Text, "=").Result, CountRows(Split("https://www.youtube.com/watch?v=", "=").Result) -1),Result
)));

#powerapps #firstn #sortyby #date #top #results

returns tops 10 results and sorts by most recent created date

FirstN(Sort('Data Source', Created,Descending),10)

#powerapps #lookup #button #text #change

Change text value based on lookup results

If(IsBlank(LookUp('YouTube Resources', Title = TextBoxNew.Text)), "ADD", "UPDATE")

#powerapps #choices #combobox #dropdown

Sets items to choices drop down or combo box

Choices([@YouTubeIDs].AddToWatchList)

#powerapps #text #lookup

Lookup items from a textbox

LookUp('YouTube Resources', Title = TextBoxNew.Text, Notes)

#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)

#powerapps #validation #combobox

Text input validation - turns border red

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

#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 #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 #html

Launch URL by clicking on an image

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

#powerapps #json

Convert collection to JSON

JSON(colTags.Value,",")

Combo box values to collection

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

Extract value from combo box

Concat(AddToWatchList.SelectedItems.Value,Value)

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

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))

Extract values from a collection

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

#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))

Get user photo from office365 connector from gallery

Office365Users.UserPhotoV2(ThisItem.PeopleColumn.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
    )
)

Retrive a user photo from SharePoint

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

Save snippets that work with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension