Skip to main content

Notifications

Power Automate - General Discussion
Answered

HELP - Logic help needed for solution using MS Flow, MS Forms and SharePoint Online

(0) ShareShare
ReportReport
Posted on by 17

I am trying to create a soluiton using MS Forms to gather responses from users, then using MS Flow, populate the results of that survey to a SharePoint list, where I can do some caluclated columns and display a ranking based on the wieghts of the questions.  

 

I have been banging my head against the desk.  I can get the MS Forms data imported into a SharePoint list. (Easy Peasy).

 

BUT....when I try to add additional logic to allow end users to update the MS Form, which would then update the question answers that were orignally submitted - and not create a new list entry....well, that is where I am hitting the wall. 

 

I can get it to create a new item, but if I do get the updates working, it creates a new entry and then updates the existing as well..  very frustrating.  

 

Below is the last iteration I have tried, with no succcess.  Any guidance oir advice is GREATLY appreciated.  

Image 4Image 4Image 3Image 3Image 2Image 2Image 1Image 1

 

  • DuaneAlleman Profile Picture
    DuaneAlleman 17 on at
    Re: HELP - Logic help needed for solution using MS Flow, MS Forms and SharePoint Online

    Barry,

     

    I stepped away and grabbed another cup of coffee and did another review of the Flow and found my issue.  I had an apply to each in the yes action.  You did not show that in your suggestion example, so I removed it and retest.

     

    SUCCESS!!     Thank you Very much!   

     

    Duane

  • DuaneAlleman Profile Picture
    DuaneAlleman 17 on at
    Re: HELP - Logic help needed for solution using MS Flow, MS Forms and SharePoint Online

    Hi Barry,

     

    Thank you for the suggestion.  I am trying this, and it is sucessfully running and completing the Flow run, but it dos not update my list with any data now.

     

    Not sure what I may be missing.  it would update the list prior, but not now.

     

    FlowScreenshot.png

     

    Thanks,

    Duane

     
  • Verified answer
    v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: HELP - Logic help needed for solution using MS Flow, MS Forms and SharePoint Online

    Hi @DuaneAlleman,

     

    You could configure Get items-Filter Query to get exist item which store the submission submitted by the responder.

    First of all, you need to create a new column to store responder's email address.
    This email address will be used to judge if the responder has submitted the form.
    Configure Condition to check if items have obtained from Get items action, use length() function to achieve this.
    if yes, configure Update item action; if no configure Create item action.
    Image reference:
    Capture.PNGCapture1.PNGCapture2.PNG
     
    Please take a try.
     
    Best Regards,
    Barry

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard