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 an Item in a Sh...
Power Automate
Unanswered

Update an Item in a SharePoint List from an Excel File Once a Day

(0) ShareShare
ReportReport
Posted on by
Hello everybody.
 
I'm having a lot of trouble to build this flow and I want to see if someone can help me.
I have a Sharepoint List that i need to update on a specific time according to the responses of a Forms that are being recorded on an Excel Table.  The problem is that when the flow updates the List it changes all the records on the list and I only want for It to Change those records were the "ID de la Idea" on the List is the same as the Excel.
 
Or if anyone has a flow that might work so I can connect directly the Microsoft Form to the List and update the information directly that would also be helpful.
 
AgustinRangel_0-1695061770650.png

My table

 

AgustinRangel_1-1695061859582.png

 

AgustinRangel_2-1695061886252.pngAgustinRangel_3-1695061909164.png

 

AgustinRangel_4-1695061943563.png

 

And this is my List

 

AgustinRangel_0-1695062244584.png

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @AgustinRangel Please reference this section of a YT Tutorial I recently uploaded on how to use the Filter Array action. You have to adjust the set up of your Filter Array action. You are missing a few actions in your flow. 

     

    Currently you are using the Filter Array action to Filter at all the values returned from the Get Items action. The issue is with your conditional argument. You need a string of ID's to run a comparison against. It's all covered in that video.

     

    Hope this helps!


    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard