Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

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

(0) ShareShare
ReportReport
Posted on by 36

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.

  • AndreyC Profile Picture
    36 on at
    Re: Problem setting a "Choices" Dataverse column using Power Automate Flow

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

  • Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Problem setting a "Choices" Dataverse column using Power Automate Flow

    @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

     

  • AndreyC Profile Picture
    36 on at
    Re: Problem setting a "Choices" Dataverse column using Power Automate Flow

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

    AndreyC_0-1639438435010.png

    And this didn't worked niether. 

  • Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Problem setting a "Choices" Dataverse column using Power Automate Flow

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

     

  • AndreyC Profile Picture
    36 on at
    Re: Problem setting a "Choices" Dataverse column using Power Automate Flow

    @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 Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Problem setting a "Choices" Dataverse column using Power Automate Flow

    @AndreyC 

    Is the optionset values are the same?

     

  • AndreyC Profile Picture
    36 on at
    Re: Problem setting a "Choices" Dataverse column using Power Automate Flow

    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.



  • Verified answer
    Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Problem setting a "Choices" Dataverse column using Power Automate Flow

    @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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics