cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndreyC
Frequent Visitor

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

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.

AndreyC_0-1639364950270.png

 

AndreyC_1-1639364950271.png

**This are the 2 tables on Dataverse.


AndreyC_2-1639364950272.png

**This is the Trigger on the Actual Flow

 

 

AndreyC_3-1639364950272.png
AndreyC_4-1639364950273.png

**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.

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@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

Mira_Ghaly_0-1639373457747.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

8 REPLIES 8
Mira_Ghaly
Dual Super User II
Dual Super User II

@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

Mira_Ghaly_0-1639373457747.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
AndreyC
Frequent Visitor

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:

AndreyC_0-1639429891230.png

**This is getting the Project Request using "Get Row by ID"

AndreyC_1-1639429945754.png

**And here is where I set the value.



Mira_Ghaly
Dual Super User II
Dual Super User II

@AndreyC 

Is the optionset values are the same?

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
AndreyC
Frequent Visitor

@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.


Mira_Ghaly
Dual Super User II
Dual Super User II

@AndreyC 

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

Mira_Ghaly_0-1639438228855.png

Please try and let me know!

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@Mira_Ghaly 
Yes, I tested with "Get Row by ID".

AndreyC_0-1639438435010.png

And this didn't worked niether. 

Mira_Ghaly
Dual Super User II
Dual Super User II

@AndreyC 

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

This is how in looks on my test 

Mira_Ghaly_0-1639441130178.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
AndreyC
Frequent Visitor

@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!

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,058)