web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Choice column i...

Power Apps

Unanswered

Filter Choice column in SharePoint

(0) Share

Report

Report

Posted on by echodapogi

516

Team,

I tried some resolution on this forum regarding this issue and i cannot find any solution on my case.

The issue i had is how to filter a SharePoint choice column in PowerApps

So i have this SharePoint list table (tblProgram). the Program column is a choice type.

I need to do is when region is selected the program field will only show /filter the data based on the SharePoint data value above.

the Program field below is a combo box in Power Apps. In the example below. i dont need to see the 5G on the displayed value in the Programs because Augusta GA has no 5G program. only DES and MA

Code for Select Region field

ForAll(Distinct(tblFSLClosure, Region), {Result: ThisRecord.Value})

any idea on how i can do this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

DavidZoon 738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

I think you can just replace the source of your combobox by a lookup to your tblProgram list :

Lookup(tblProgram , Region = DataCardValueSelRegion.Selected.Value,Program)

where DataCardValueSelRegion is the combobox where you select the region in your form, it should give you a table of matching programs for this region

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.

Was this reply helpful? Yes No
echodapogi 516 on at

Like
a
(0)

Report
Copy link

Link copied!

it has an error. when i type drpProvider_1.Selected.(there is no other choice except "Result")
so its drpProvider_1.Selected.Result

Was this reply helpful? Yes No

Join the conversation