Unanswered

Filtering

(1) Share

Report

Posted on by EJ_271

Hello

I'd like to filter the 'Risk Register' table (SP list) to only include rows where the 'Risk Reporting Level' is "Level 1" and the 'Risk Status' is "Open", and then extract distinct values from the 'Title' column shown in my dropdown.

Note, the 'Risk Reporting Level' and 'Risk Status' columns are choice type columns.

Here is my formula:

Distinct(Filter('Risk Register', 'Risk Reporting Level'= "Level 1" && 'Risk Status'= "Open"),Title), {Result: ThisRecord.Value}),Result)

The errors in the expression are due to attempting to compare a record type ('Risk Reporting Level' and 'Risk Status') with a text type (StringLiteral("Level 1 - Corporate") and StringLiteral("Open")). This is causing the unexpected characters and incompatible types errors.

Any help on how to correct it is hugely appreciated.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Kalel_Lucas 165 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello EJ,

Because those columns of yours are Choice type columns, if you want to use them to compare with String/Text types, you need to add ".Value" at the end.

So in your situation, you need to utilize:

Distinct(Filter('Risk Register', 'Risk Reporting Level'.Value= "Level 1" && 'Risk Status'.Value= "Open"),Title), {Result: ThisRecord.Value}),Result)

Hope it helps,

Kalel

Was this reply helpful? Yes No
EJ_271 38 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you Kalel

I was adding the ".Value" in the wrong place.

Best regards
EJ

Was this reply helpful? Yes No