Skip to main content

Notifications

Power Automate - General Discussion
Answered

US States MS Forms

(0) ShareShare
ReportReport
Posted on by 280

I have a Form with a question to select US States. It's a drop-Down list. Upon selecting a "US State" and submitting the form.

A flow is triggered for the submission. It's all good until the "Update Row action".

 

But the selected state is not passed to Update Row. When the flow is comopleted we can see that the "Null" is passed to this field. On the actual Ecel file, we can see the "First State" in the drop down list is published.

 

Can any one here tell whats going on ? 

 

cadone_0-1600751408826.png

 

  • cadone Profile Picture
    cadone 280 on at
    Re: US States MS Forms

    @rsaikrishna 

     

    Thanks, Test 1 worked. I did not try Test 2.

     

    Would you recommend to use Test 2 over Test 1?

  • Verified answer
    rsaikrishna Profile Picture
    rsaikrishna 3,703 on at
    Re: US States MS Forms

    @cadone 

     

    Here is my recommendation:

     

    Can you see State name in the Outputs section of the Trigger? Then, its good.

     

    Test #1: Remove the assignment of State value in the Update Row action. Save the flow. Close the flow and reopen it. Now, assign the State value to "Location State" field. Now, save the flow and test the flow. This should work.

     

    Test #2: If Test #1 does not work, check the below option.

    Place a compose action before Update Row action and try to print the value of the US State. Run the flow and check if you are getting the value or not. If this works, use the output of Compose action in the Update Row action.

     

    Regards

    Krishna Rachakonda

    If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

     

     

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard