Filtering Gallery Based on OptionSet Values

(0) Share

Report

Posted on by rprahalad

377

Hello All,

I have a Gallery pointing to a CDS Entity called 'Declarations'. It has a custom field called 'Status' which is an OptionSet. I am struggling to set a Filter property on the Gallery to display ONLY statuses of 'New' Declarations.

I have tried all combinations of single quotes and double quotes, field names etc. There are no other complications other then just displaying ONLY 'New' declarations in the Gallery when the form loads. But I keep getting errors at the '=' sign, as well as on the right side of the =sign.

Items= Filter(Declarations, 'Status (cr70c_status)'=[@'Status (cr70c_status)'].New)

Please let me know what the correct syntax is. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Vijay Tailor 2,961 on at

Like (1)

Report
Hi @rprahalad ,

Below is the ways to filter the record based on Optionset.
Filter(TestAkshay,Complexity.Value="New/Pending")

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
rprahalad 377 on at

Like (0)

Report

Ah! I finally got it right. It is
Filter(Declarations, 'Status (cr70c_status)' = [@'Status'].New)

Was this reply helpful? Yes No
rprahalad 377 on at

Like (0)

Report

Thanks Vijay! In my case the column name of 'Status', which I think is also the name of a key column, was giving me an issue. But appreciate your help.

Was this reply helpful? Yes No
rprahalad 377 on at

Like (0)

Report

I tried your syntax but it is giving me a red squiggly at the .Value. The error is: 'Name isn't valid. This Identifier isn't recognized.'.

Filter(Declarations, 'Status (cr70c_status)'.Value = "New")

Was this reply helpful? Yes No
Verified answer

Vijay Tailor 2,961 on at

Like (2)

Report
Hi @rprahalad ,

Please try like below, As previously i mentioned that will according to Sharepoint.

But below is the CDS ways to Filter Gallery based on Optionset
Filter( VOJOBS, If( Dropdown1.Selected.Value = "Completed", 'Field Status' = [@'Field Status'].Completed, Dropdown1.Selected.Value = "InCompleted", 'Field Status' = [@'Field Status'].InCompleted ) )
.
Hope that will help you.
Thanks

Was this reply helpful? Yes No
rprahalad 377 on at

Like (1)

Report

Vijai, I will mark this as an Answer as this syntax from your reply above, also worked for me! Thanks!

Filter(Declarations, 'Status (cr70c_status)'=Status.New)

Was this reply helpful? Yes No