Unanswered

How to retrieve Choices (option set) value in power app canvas from data verse for custom field

(0) Share

Report

Posted on by KRYPTON

How to retrieve Choices (option set) value in Power Apps Canvas from data verse for custom Field

Basically, I am creating custom updation. where I want to show user its selected option set value in from field which he/she had selected while creating from (creating new record).

In my case Field name (Column) is 'Reviewer Profile' which is the choices (option set). and I have created Lookup for that as you can see in screenshot and also global variable to store value.

As you see I'm using lookup for filtering column to get signed User 'Reviewer Profile' Value.

but I'm getting error you can see bottom of screenshot This Data type is unsupported for evaluation.

Try to help me on this issue. Thank You - @Krypton

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Krypton Can you share the Table schema and a screen shot of the error message.
KRYPTON 23 on at

Like
a
(0)

Report
Copy link

Link copied!

I have updated image
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Krypton You'll see the record with a statement like this,

But because you are reducing it to a single column, you can't see the record. Use a statement like the one above and then do reviewProfileValue.yourColumn to get the value.
KRYPTON 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for that @CNT I tried this but still it is not working I guess . Any idea?
Note : Reviewer Profile is Choices (Option set)
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Krypton 'Reviewer Profile' is not a standard column. I believe it's a custom column that you have added. So I'm not sure what its DataType is. You will have to figure it out based on the DataType.
paulbeck1 244 on at

Like
a
(0)

Report
Copy link

Link copied!

This is a Choice column, then you are using an options set to hold the values. The refer to the options set use the syntax: [@'ChoiceField'].Option3
In the example below, I have a table "Tax Returns", Each Return belongs to a business, and there is a column "AType" that is an optionset, the possible values are "Annual, Company, Registrar", in the example below, there are 3 records for each Business, so if I filter on BusinessId, I'll get 3 results. I only want the result that has the option of "Annual", below is the code.

Tip: This works if you know the static Option set value you want. If the OptionSet value is dynamic, you may need to use a global variable to help define the Option item you want to query with.