Filter gallery based on choice column Value

(0) Share

Report

Posted on by BianceBee

102

Hi there

I have 2 galleries pulling data from a sharepoint library data source. One gallery I want to only display Policy which is one of the choices from the sharepoint library column 'Thetypeofdoc' column. and the other gallery i want to show SOP, Forms and Guidance Documents which are the other options within the 'thetypeofdoc' choice column.

Anyone know how i can filter a gallery to only show specific choice options?

I thought using below will work but does not work as

Filter('Published Policies',Thetypeofdoc.Value="Policy")

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @BianceBee ,

What type of field is Thetypeofdoc ? If it is Text you do not need .Value after it.

Was this reply helpful? Yes No
BianceBee 102 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz it is a choice column

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @BianceBee ,

Assuming it is a single choice column, what result do you get as your code should work.

Was this reply helpful? Yes No
BianceBee 102 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the prompt reply @WarrenBelz . Getting name not recognized error. Below are the columns and the type. The one i am wanting to filter is the choice column with the value Policy.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@BianceBee ,

Missing the Capitals

Filter( 'Published Policies', TheTypeofDoc.Value = "Policy" )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
BianceBee 102 on at

Like (0)

Report
Copy link

Link copied!

OMG thanks didnt realise it wasn't capitals. Sorry to have wasted your time 😞

Was this reply helpful? Yes No
BianceBee 102 on at

Like (0)

Report
Copy link

Link copied!

OMG didnt even realise it wasn't in capitals. Sorry to have wasted your time 😞

Was this reply helpful? Yes No