web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery based o...

Power Apps

Unanswered

Filter Gallery based on Combobox

(0) Share

Report

Report

Posted on by abdelrahmanHon

56

Hello Everyone,

i need your help please ,

I have Combobox1 Items= (Distinct(Task, 'Status').Result ) to get the status Items .

Now i need to apply the selection from Combobox1 on Gallery2 , to be filtered by the Status.

Note: Gallery2 is already filled from another Gallery1. Gallery2 Items = Filter(Task, Resource=Gallery1.Selected.Resource)

anyone can help me in this please

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @abdelrahmanHon ,

Could you please tell me what the Status column's datatype is ? I assume Status is a single line of text column , the formula should be:

Please try:

Filter( Task, Resource=Gallery1.Selected.Resource, Status=Combobox1.Selected.Result )

Best Regards,

Bof

Was this reply helpful? Yes No
abdelrahmanHon 56 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bofeng-msft
i tried this formula but no luck . it return blank result when i added this code to Gallery2 Items .
when i removed ComboBox filtering ( Status=Combobox1.Selected.Result) it gives me all types of Status ( Completed , Closed, New) . in Gallery 2
what i need , is to use ComboBox1 to just display the records which is match Combobox selection only
appreciate your help here

Note: data source is Online Excel and data type of Status is Text

Was this reply helpful? Yes No

Join the conversation