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:

Using Apps Using Formulas

All responses (2)

Answers (0)

EJ_271 38 on at

Like (1)

Report

Filtering

Thank you Kalel

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

Best regards
EJ
Kalel_Lucas 165 on at

Like (1)

Report
Filtering

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