Extract values from a collection

PHOTO

Wed Jul 20 2022 10:22:16 GMT+0000 (UTC)

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

COPY

selectedDesks = collection, " " is the name you want to give to the value, Title is the item, and Char(44) is an ","

https://www.youtube.com/watch?v=DF4KX1oSrVI

Save snippets that work from anywhere online with our extensions

Comments

Power Apps

@gofunk1

Initiate MS Team Group Chat via PowerApps Save the current users email as a variable Creates variable with a theme colour palette Send an email from the current user Filters a data source based on the current logged in user Patch data fields, including a choice column to a data source Changes the colour of a selected item in a Gallery Filter and search a data source via a search box and dropdown Changes visibility based on the selection of another Gallery - used for "Tabs" Display current users first name Fix: Combobox/Search is empty check not working - Power Platform Community Retrive a user photo from SharePoint Get user photo from office365 connector from gallery Set a variable with the current users first name, from the currentUser variable Extract values from a collection Extract value from combo box Extract vale from combo box and convert to string/text Convert collection to JSON Combo box values to collection Show newly created items first / sort by most recent entry, will only show items created today Validate/Validation text box length and/or combo boxes contain data Text input validation - turns border red Lookup value against a text input and disable or enable displaymode Lookup items from a textbox Sets items to choices drop down or combo box Change text value based on lookup results returns tops 10 results and sorts by most recent created date Sets a variable with spilt text from a link - YouTube in this case Pass a null or empty value from Power Apps to a flow

#powerapps

Retrive a user photo from SharePoint

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

#powerapps

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

#powerapps

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

#powerapps

Extract values from a collection

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

#powerapps

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

#powerapps

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

#powerapps

Extract value from combo box

Concat(AddToWatchList.SelectedItems.Value,Value)

#powerapps

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)

Extract values from a collection

Save snippets that work from anywhere online with our extensions

Comments

More like this

Power Apps

Browse more snippets >>

Extract values from a collection

Save snippets that work from anywhere online with our extensions

Comments

More like this

Power Apps

Browse more snippets >>

Embed code snippet