web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps To display data in gal...

Power Apps

Unanswered

To display data in gallery based on selected values in combobox

(0) Share

Report

Report

Posted on by Hemasai1999

95

HI,

I have one gallery and one combobox3.

Items for combobox3 - Office365Users.SearchUserV2({searchTerm:ComboBox3.SearchText}).value

In gallery I want to fetch details of selected email details with respect to combobox3,

If I select two mails in combobox3 then data that matches two emails should get display in gallery

In combobox3 If i search abc@gmail.com, def@gmail.com

in sharepoint I have data like this

Emp ID Email Company

4747 abc@gmail.com xyz

2134 def@gmail.com hja

5258 jdj@gmail.com jaj

since I have searched abc@gmail.com, def@gmail.com these two emails then these two persons details should display in gallery

I have written this formula - Concat(ComboBox3.SelectedItems,'Email ID' & " , ") , but it is not displaying data

Any suggestion would be helpful

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

if you filtering gallery based on comboox items then your formula in gallery's item property should be:

Filter(ListName,EmailColumn in Combobox3.SelectedItems)

Was this reply helpful? Yes No
WarrenBelz 155,632 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Hemasai1999 ,

Put this on the OnChange of the Combo Box

Clear(colEmails); ForAll( ComboBox3.SelectedItems, Collect( colEmails, Office365Users.SearchUserV2({searchTerm: xxxx}).value ) )

Where xxxx is the valid output of ComboBox3.Selected.xxxx Your gallery Items is then colEmails

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation