Combo box values to collection

PHOTO

Fri Jul 22 2022 20:05:50 GMT+0000 (Coordinated Universal Time)

Saved by @gofunk1 #powerapps

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

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

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

Power Automate

@gofunk1

Get SharePoint Item ID from Apply to Each Filter Get Items based on date Column Add image to variable Power Automate Format date from JSON or an Array (item) Checks is the length of Get items is greater than 0 Change one value to another Combo box values to collection Pass a null or empty value from Power Apps to a flow

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