web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update SharePoint List...
Power Automate
Unanswered

Update SharePoint List based on MS Forms using unique value

(0) ShareShare
ReportReport
Posted on by 10

I have tried to follow this post for my flow Update sharepoint list item with data from Microso... - Power Platform Community (microsoft.com) but it doesnt work. Hoping someone knows how to do this.


I have an MS Form set-up with three questions:

Q1 - Vendor ID

Q2 - SME Type which is a selection field with options "Micro" "Small" "Medium" "n/a"

Q3 - Date field

 

I have a SharePoint List called vendor list which has multiple fields but the ones relevant to this flow are:

Vendor ID

SME Type

Date of Last Check

 

When a response is submitted in MS Forms I need my flow to filter on Vendor ID field in my Vendor List in SharePoint using the Vendor ID submitted in Q1 of the form - I then need it to update the SME Type field using the answer provided in Q2 of my form and update the Date of Last Check field using the date provided in Q3 of the form.

Categories:
I have the same question (0)
  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hey @SJB 

     

    I've created you a quick demo here where I use forms to trigger my flow and lookup one of my answers in my list.  I then use the returned column value and the results from the form to update a second list. I hope this is of use to you.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

  • SJB Profile Picture
    10 on at

    Thanks for the response unfortunately this doesnt fix my issue.

     

    I have provided links to my flow images to show what I have done but each time it runs it fails cant work out why.

     

    https://drive.google.com/file/d/1DFwXr5gABs6VObiHU4Q0BYQeLcMOTmFi/view?usp=drivesdk 

     

    https://drive.google.com/file/d/10GSSH0IqgTITqiZMfbGFhWmiKbnslIfb/view?usp=drivesdk

     

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @SJB 

     

    Sorry to hear that wasn't useful.  Those images you have shared are private and not shared with all users.  Can you please either include them in the conversation below or sort out the sharing permissions.

     

    DamoBird365_0-1616739696452.png

     

     

    Cheers,

     

    Damien

  • SJB Profile Picture
    10 on at

    1.png2.png

  • Verified answer
    DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    Hi @SJB 

     

    Can you share with me your error message too?  Or what happens that isn't as expected?  Is a value empty?  If so which one?  Have you watched my video as I believe it achieves what you are looking for.

     

    My first observation is that you have created an unecessary apply to each.  The trigger get response is based on a single response.  The flow will run each time someone submits that form.  The get response details action will therefore only ever return 1 response.  It should appear straight under the trigger.  This is demonstrated in my video.

     

    Your apply to each 2, which should in fact be the only apply to each (albeit it can be avoided if you are only ever returning 1 result - shown in my video), looks OK.  The values array should be the results from the get items and if your filter is working on the get items you should return 1 item (albeit flow will assume it will be more than one and hence puts it into an apply to each). 

     

    You need to look at the history of a previous run to ensure get items is in fact returning a match on your filter - expand the output on get items history.

     

    If that is OK, then look at the update item, is it failing?  Is the Item ID, the List item ID i.e. 1,2,3,4,5 which is sequentially assigned when an item is created?  

     

    Explore the above and let me know what you are actually experiencing or not seeing and I can better advise.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

     

     

  • SJB Profile Picture
    10 on at

    Thanks for the pointers my flow now works below is the new flow and it now updates my share point list correctly which is great! huge time saver - much appreciated.

     

    3.png4.png

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at

    @SJB fantastic!  Well done.  I am pleased to have helped you with the solution.

     

    Damien 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard