Unanswered

Problem setting a "Choices" Dataverse column using Power Automate Flow

(0) Share

Report

Posted on by AndreyC

I have a table called "Project Registration" where the user set the Choices field using the UI (Model Driven App), now from the Flow I have a trigger that will get activated when a New Project Registration is created. Inside that Flow, below the trigger, I'm creating a New Row on the Project Table, where this Choices field is created on the same way, and they share the Choices List.

**This are the 2 tables on Dataverse.

**This is the Trigger on the Actual Flow

**And this the step that it is creating a new Row on the Project table

I tried different formulas to set this Choices column, but nothing seems to be working.
Does someone know how to set A Choices Field on Dataverse using Power Automate flow?

Thanks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@AndreyC

I made a test on my side and you can't directly set it from the action trigger but what you can do is that you do another call Get Row By Id and set it from the Get Row by ID by choosing add Custom value and select the choices from the Get Row By ID

Was this reply helpful? Yes No
AndreyC 36 on at

Like (0)

Report

Hi @Mira_Ghaly ,

Thank you so much for your response.
But sadly I tried the same thing and did not worked.

Here what I did:
**This is getting the Project Request using "Get Row by ID"
**And here is where I set the value.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@AndreyC

Is the optionset values are the same?

Was this reply helpful? Yes No
AndreyC 36 on at

Like (0)

Report

@Mira_Ghaly

Yes they are.
You can noticed that the first 2 screens of my question, I did showed both Tables and Columns that I'm dealing with.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@AndreyC

I think you are using the incorrect one please use the one as below:

Please try and let me know!

Was this reply helpful? Yes No
AndreyC 36 on at

Like (0)

Report

@Mira_Ghaly
Yes, I tested with "Get Row by ID".
And this didn't worked niether.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@AndreyC

Can you share your flow run history steps outputs for Get Row By ID?

This is how in looks on my test

Was this reply helpful? Yes No
AndreyC 36 on at

Like (1)

Report

@Mira_Ghaly
I just accepted your response as the solution. I was having problems with the test. But now it worked.

Thank you so much for the help!

Was this reply helpful? Yes No