Answered

Issue with a choice column to collection

(0) Share

Report

Posted on by sbroud

Hi Everyone,

I have a little problem pulling data from Dataverse table to collection: this Dataverse table includes a choice column but at the moment of ClearCollect the new collection it gives me all columns ' values except the choice field [This data type is unsupported for evaluation].

Could you please help.

Thank you.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (1)

All responses (8)

Answers (1)

MichaelFP 1,886 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you share the code that are you doing?

Did you created the choices direct on the field or create the choice and linked with the field?

Was this reply helpful? Yes No
sbroud 69 on at

Like (0)

Report
Copy link

Link copied!

Yes, Here is the code: The status is the choice column that has 5 statuses.

ClearCollect(Collection1,Filter(EventTable, City="New York"));
ClearCollect(colData, ShowColumns(Collection1, IDNumber, 'Event Date', 'Event Result', SpaceID, Status));

Was this reply helpful? Yes No
MichaelFP 1,886 Moderator on at

Like (0)

Report
Copy link

Link copied!

You mean that information?
if is that case you can use the name logical name of the field and you will be able to use in the gallery.

I made this example with the case, but it works for any choice.

I hope that this information has resolved your doubt. If it is marks as resolved 😎

Was this reply helpful? Yes No
sbroud 69 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the help. I have issue collecting data into a collection. I understand that gallery or any other control will handle this type of data. But, if I want to create the collection , that gives the same result as your screen : This data type is unsupported .....

My idea is to pass this data to collection then to JSON ==> Power automate for reporting.

Thank you.

Was this reply helpful? Yes No
MichaelFP 1,886 Moderator on at

Like (0)

Report
Copy link

Link copied!

Did you try to convert to a JSON? I guess will convert with no problems don't?

Was this reply helpful? Yes No
sbroud 69 on at

Like (0)

Report
Copy link

Link copied!

Thank you Michaelfp,

I've tried to create the JSON , but the data I got is not the same choices I already have [A, B, C]. I received the following result : (e.g. 62730001)

Is there anyway to convert these numbers to choices : Thank you for your help

Was this reply helpful? Yes No
Verified answer

MichaelFP 1,886 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try the following:

1- first create a collection with you choices
ClearCollect(MyOptions,Choices('Status Reason (Cases)'));

2- Create another collection to add your records but using AddColumns to include new column with the text value
ClearCollect(MyCollection, AddColumns(Cases,'ChoiceColumn', Text(LookUp(MyOptions,'Status Reason' = Value).Value) ) );

Check if this works for you.

If this information help please give me a kudo. If solve you problem please mark as solution. This is help the community.

Kind Regards.

Was this reply helpful? Yes No
sbroud 69 on at

Like (1)

Report
Copy link

Link copied!

Thank you @Michaelfp 😁

Amazing Results. It gives me what expected.

Was this reply helpful? Yes No