Answered

Option Set Specification error

(0) Share

Report

Posted on by AnjaliAnil

Hi,

I want my text field to display just the job cards with 'job status' as 'problem solved'. However when I try doing this using the value and name of the option, it shows an error.

Please help with this error.

Thank you

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AnjaliAnil

To resolve this, you can update your expression in two ways, please replace the written expression with the Job Status part in your expression.

1) Convert the Option Set column value to Text value

Text('Job Status') = "problem solved"

2) Compare with the Option Type field value:

'Job Status' = 'Job Status (Job Cards)'.'problem solved'

The highlighted part is the convention for 'Column Name (Entity Name)'.Option

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @AnjaliAnil ,

Do you want to filter your 'Job Cards' records based on the "Job Status" column value?

Is the 'Job Status' a Option Set type column/Two Options column in your 'Job Cards' Entity?

Based on the formula you provided, I think there is something wrong with it. I have made a test on my side, please consider modify your formula as below:

CountIf( 'Job Cards', 'Customer Asset'.crbb4_customerassetid = AssetListGallery.Selected.crbb4_customerassetid && 'Job Status' = [@'Job Status'].'problem solved' )

Note: The 'Job Status' represents the Option Set name which binds to the 'Job Status' column in your 'Job Cards' Entity.

Please consider take a try with above solution, then check if the issue is solved.

Best regards,
AnjaliAnil 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255

Thank you for you help but unfortunately both these formulae still gave error.
AnjaliAnil 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft

Thank you so much! It solved my error 🙂