Skip to main content

Notifications

Power Automate - General Discussion
Answered

small help needed in power automate collect data from microsoft form to sharepoint list

(0) ShareShare
ReportReport
Posted on by 57

hello expert, i have created a flow to collect the responses submitted from microsoft form and update in sharepoint list. in Form i have one choice type question, user to select Yes/No. based on their selection the flow should work.

 

If user select "Yes", then Yes branch should work. if user select "No" then No branch flow should work. below is my flow.

 

Prabhu_Rajaram_1-1675439159336.png

 

But in my case, even if user select Yes or No, the No branch flow only executing. Expression Result in the condition is always update as false. where is the disconnect. anyone please help me with solution.

 

Prabhu_Rajaram_0-1675439063280.png

 

  • Prabhu_Rajaram Profile Picture
    Prabhu_Rajaram 57 on at
    Re: small help needed in power automate collect data from microsoft form to sharepoint list

    yes i removed the second one. it is working perfectly now. thank you so much.

  • Verified answer
    srduval Profile Picture
    srduval 1,663 on at
    Re: small help needed in power automate collect data from microsoft form to sharepoint list

    If it is only one question with only a Yes/No Answer, meaning it can only be a Yes or a No, then you should remove the second clause of the filter. The way you have it now, it will always evaluate under the "Yes" branch now

  • srduval Profile Picture
    srduval 1,663 on at
    Re: small help needed in power automate collect data from microsoft form to sharepoint list

    double check the fields you have in your condition filter, just in case you maybe put the wrong filed/value combination. If those are good, try converting the fields to string type via the expression 

    string({enter your field dynamic value here})
  • Prabhu_Rajaram Profile Picture
    Prabhu_Rajaram 57 on at
    Re: small help needed in power automate collect data from microsoft form to sharepoint list

     

    oh ohh, i made silly mistake, i change condtion from AND to OR, and updated as below. now it is working fine.

    Prabhu_Rajaram_3-1675440598946.png

     

  • Prabhu_Rajaram Profile Picture
    Prabhu_Rajaram 57 on at
    Re: small help needed in power automate collect data from microsoft form to sharepoint list

    it looks, compose give Yes/No as output

    Prabhu_Rajaram_0-1675440260534.png

     

    Prabhu_Rajaram_1-1675440304640.png

    @srduval 

  • srduval Profile Picture
    srduval 1,663 on at
    Re: small help needed in power automate collect data from microsoft form to sharepoint list

    Put a compose action between the "when new response" and the condition. Put the Yes/No field into the compose action. then run again and see what value is populated in the compose action. I suspect it's not passing a "yes" or a "no" but instead a True or False or 1 or 0

  • Prabhu_Rajaram Profile Picture
    Prabhu_Rajaram 57 on at
    Re: small help needed in power automate collect data from microsoft form to sharepoint list

    @srduval 

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,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard