Add & Update Excel Table Row from SharePoint List | Power Automate Tutorial

This video is about how you can Add and Update Excel Table Row from SharePoint List using Power Automate. Please watch the full video to learn.
Below is the content which i have used in the video you can copy this and paste in your flow.
1. body('Filter_array')
2. triggerOutputs()?['body/ID']

[@SanjeetShrestha-nj9xq]

I used thse same flow but I ma getting duplicated entries for every new item added on a SP list. i flow is an automated flow when an item is created only. Any suggestions

[@sophiadcosta-braganza5954]

Hi @Lernen Tech.. Thank you for this video.. I keep getting an error - "The input parameter(s) of operation 'Condition_1' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Condition_1'. I get the option to use output "@empty(outputs('Filter_array')['body/value'])", instead of what you suggested.. Would you be able to help please? Thanks.. "

[@aydanachannel4458]

hello, sir. I have tried to practice your tutorial. At first everything went smoothly. but when I do a test flow, the items that appear in the excel file become double input. which should be an updated item but instead creates a new item. is there a solution sir?

[@RohanKohli-t8n]

This was very helpful! I was successful in connecting the SharePoint list to the Excel online, but every time I modify/ add an entry to the Sharepoint list, it adds multiple rows (100+) rows of the same entry into Excel. Is there any way to limit that? I want it to add 1 entry in Excel.

[@botmarshall3221]

whenever my item is getting update with multiple coloumns it's creating an new entry rather just updating the same why so ?

[@ciannamaria]

Hey so thank you for a great video. I was wondering if you know how to manage data when a collum containd multiple date input in a sharepoint list without getting the loop for each one?

[@LernenTech]

will cover this one as well in upcoming videos

[@deepaksinghbhadoriya8077]

This is flow is not working properly

[@adrianhidayat592]

please help me for delete condition 🙏

[@danielmacias5880]

Hi, thanks for this video, but i did the same you explained but the filter array always validate that theres is no ID number so even when is already o the excel add new item on it so it duplicate the row. Do you know why this could happend?

[@LernenTech]

Let me check

[@arielenglis5589]

@@LernenTech Hi is this already being fixed it goes the same to me. Instead of updating it creates a new row

[@jyguti]

@@LernenTech Was there a solution regarding the duplicate rows? When I create this flow, it re-adds the items to my excel when I run the flow.

[@davem9181]

me too? it doesn't update the row but add a new one when i make a modify on my list.. any suggest or news?

[@luisvallejo2380]

thanks crack!!!

[@kellylieu9671]

Thank you for sharing, great tutorial. Question, when I delete an existing value in one column from my SharePoint list, the flow reads “null” as input for that column, but that same existing value in Excel does not get deleted. Would you suggest any solutions?

[@davem9181]

Thank you very much, but unfortunately i received this error "Saving the flow failed with error code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Filter_array' referenced by 'inputs' in the action 'Condition' are not defined in the template.'.' ."

[@kapilrajan-b4f]

Hi, I have question here. If I'm working in an org the share point site should be company one. So if I start the flow it will show Invalid connection adn update your connection to load complete details..What should I suppose to do?

[@kapilrajan-b4f]

Hello, Its working good but it create unnecessary duplicate entry. if I change anything it creates 4 times the same data. How can I rectify this?

[@arielenglis5589]

Hi, Is there a fix on the problem where it creates a new row instead of updating the existing row that was edited in sharpoint?

[@jdparden]

I'm having the same issue. Did you get this resolved? I'm starting to wonder if it is an issue with the sharepoint setup on my side...

[@arielenglis5589]

@@jdparden This solution is coming from Kristel Van Uffelen on the comment section below. In the "list rows present in a table step" of this automate. Click the Menu for this list or the three dots. Then select settings. Under the pagination section change the threshold to 5000. This helped with sort this out. Hope this will help you.

[@DuncanFairweather]

Why isn't there ANYTHING from Sharepoint to File System? I need to use SSIS to import data from a list so I need the export to be in the file system - not Sharepoint or OneDrive. Is this possible?

[@fura999]

For me it's not working, something is wrong in "if condition" or in filter array because every time i get the same value(regardless if row exist or not). I spotted in filtter array i have a body/value instead of value is it ok?

[@Gaurangg09]

Very crisp info.. Can it be possible to move data to excel in document library from SharePoint list when excel is password protected?

[@Gaurangg09]

If it is possible to update SharePoint data to password protected excel, what changes or additional steps need to be added in flow?

[@alfonsolans]

Great Job Thanks for sharing awesome material, quick question if we are using a sharepoint list that has picture columns, how it would be the process to export them as well, I used your instructions but I was not able to see the picture columns when adding the rows, Keep it up the great work sharing this awesome content to us, I really appreciate it Thanks a million

[@goldcarps]

Your excel table have 6 columns mapped from SharePoint list. If I includes extra columns in the same excel table for calculations will the flow worked. Please advise me Thanks.

[@LernenTech]

flow will work but will not include extra column, for that you will have to map it

[@T_h_e_Best]

Hi, greate video! I have an issue: how can l add,delete,modify data in Sharepoint List using my LOCAL EXCEL file WITH MACROs? I'm creating a program in local excel with a lot of usefull things, and one of this thing is need to create a task from local file into sharepoint list and via versa!! is it possible? Can you give me some way, direction, how can I do this, what i have to use additionally? thanks in advance

[@infy25]

How to update multiline field from SharePoint to excel. It shows HTML text in excel instead plain text?

[@uARamboGS]

Thank you very much. This video helped me alot. This runs smooth but i've got one small problem. Is there a possibility to delete the row in excel, when the sharepoint list element is deleted? The flow works only if an element is added or updated. It would help me alot.

[@babakrahi1306]

Can this work the other way around? when we make a change in the excel sheet for the SharePoint to be updated

[@RuSalas]

Great Video, Question: using larger sharepoint list with multiple columns, I'm getting Apply to each when I add some values to the final step - Yes or No areas.. The flow runs but nothing goes to excel.

[@tenisharamcharan5026]

Any ideas why at step 2 for listing the rows present in the table my sharepoint site won't show up

[@mat6997]

What if you delete a row on SharePoint list will it delete the row on excel?

[@adityapadmawar8754]

This video is very helpful. Thank you so much. Your narration is on point. Keep creating such content

[@gunasekaran4288]

hi Sir, How to do the same vice versa, From Excel to Share point automate update and send email to New added Item alone to End User. we are receiving.CSV every day, so we need to track those information n share point

[@sedman5179]

On the money for the topic choice. Like your approach, explanation and solution, thanks….

[@davidsnider6381]

I would like to do something like this but I only want to pull in List rows with Today's date. So in excel I would only see List items if they are from today. Any Idea how I would do that?

[@averyleerling6884]

the flow works but the data isn't coming in the excel table

[@eaindra6711]

Thanks you for your sharing. I solved the issue of automate of my project with your video help. It was really helpful ^^.

[@adamosovsky8672]

Thanks for the help! only issue is that when I create a new item, the flow adds that item into the excel sheet as well as adds existing rows again. How could I fix this?

[@shellyjean6439]

Awesome tutorial! It worked for my needs perfectly. Thank you for the details and excellent explanation.

[@JacobPruet]

Great video and perfect for what I need, however, I tried to modify the trigger to be a recurrence, but now it is not recognizing the filter array. It keeps returning all of the items. I made sure to change the trigger outputs to get_items. The flow works, but it doesnt process the filter array correctly. Any suggestions.

[@margaritanikonova1007]

The flow fails if the list has an empty column. Any way to work around it?

[@GMarshll]

If we delete the item in sharepoint will it delete the row in excel?

[@AdnanKashemOxe]

This is excellent work brother..helped me a lot. Thank you

[@MsSneha1996]

Is there a method to do this from excel to excel?

[@alineruiz8090]

This was really helpful!! Thanks a lot

[@oddysays4503]

Is it possible to do this from Excel to Excel? To effectively create a back up of an item if it gets deleted? I did it from Excel to List - Which works but takes a long time to complete. So thinking maybe this is quicker?

[@LernenTech]

yes you can

[@asam]

Thank you so much for sharing this. This video about sharing to Excel and the other video sharing from Excel is golden! I learned SO much.

[@anusiawathy]

How to do this if i have sub folders in my sharepoint ?

[@stroomlijnjebedrijf]

Thank you, this works great!

[@TheYetza88]

Thank you! Super useful!

[@SkyAviatorr]

Thanks Bro keep sharing❤

[@lobnaamer7440]

Great, great video and great, knowledge rich channel! Question; what happens if we add columns to the SharePoint List?

[@LernenTech]

good question, you will have to map that using flow

[@juancamilopalacioospina1281]

Thank you so much for the video. But Currently, I have a big problem, Filter Array's input doesn't contain all table data, I have a limit of 250 rows and I don't how to extend it. I'll appreciate a support

[@LernenTech]

you ca do that upto 5000

[@gamingescape5824]

I am new to SharePoint. I didn't quite understood the steps. Can you please explain how did you import the excel file in SharePoint and also do we need to manually create fields in excel ?

[@azamatbekzhanov]

Yes, you need to manually create fields in Excel. To be precise, you need to create a table. You do not have to import the Excel file to Sharepoint. You can use OneDrive as well, it depends on you.

[@scaryfactfiction]

Thank you so much! Great instructions and easy to follow.

[@LernenTech]

Glad it was helpful!

[@nathanface8225]

This is great but when a row in share point is modified it created another row in my excel table. How do I get it to modify?

[@rachelhutson535]

Hi Nathan! Did you ever find a way to resolve this? I have followed the tip to "increase pagination" but it did not solve the duplication issue. Thanks so much!

[@mnabutovsky]

Is there a method to do this but from Excel to Sharepoint?

[@LernenTech]

yes check out the video in channel

[@abhilashasharma5352]

Nice 👍🏻

[@myhearthurt490]

Hi. It work finally. But, it create like 5 row for new data entry. And my SharePoint List have drop down item, it don't show the choose option in excel file. What should I do? :(

[@LernenTech]

might be doing something wrong

[@asam]

You are using the wrong item. You need to use the item named with "VALUE" in the end. Then you only get the value that has been chosen.

[@jdduf]

Thank you so much for the video! Hoping you can advise on another step…let’s say that after your rows were added/updated in Excel, you wanted to only keep the rows that had a certain department ID (and delete the rest). Can you recommend a flow for that?

[@LernenTech]

will try to create a dedicated flow for that

[@ubm-yaco]

@@LernenTech any update on that flow? I had a condition to only add rows in column value had yes. It was working fine, however, about a week ago, it started create duplicate entries every time the record is updated.

[@kapilrajan-b4f]

@@ubm-yaco For me also the same issue

[@mnabutovsky]

Is there a template for this?

[@LernenTech]

no

[@stevecrawford1844]

Doesn't update entries for me, just adds them as new so I end up with a duplicated list. I may look how to delete all list entries and them update as that would solve my problem.

[@LernenTech]

check out other videos on channel.

[@jyguti]

@@LernenTech where is the video on the channel that fixes the duplicate entries when running the flow?

[@rachelhutson535]

@@jyguti Did you ever find a way to resolve this? I have followed the tip to "increase pagination" but it did not solve the duplication issue. Thanks so much!

[@HollyIsBest]

Hi there, I'm having the same issue with duplicating rows and the threshold tip in the comments doesn't work. Could it be to do with the conditional formatting step? The flow always goes to Yes 'create new row' even if an item has been updated (rather than created new), but I don't know how to fix this.

[@alyoshaferris1799]

Having the same issue did you find a resolution for this

[@HollyIsBest]

@@alyoshaferris1799 I did! Can’t remember exactly how now but maybe follow what mine looks like now: make sure the Filter array is like this: From: outputs(‘List_rows_present_in_table’)?[‘body/value’] item()?[‘ID’] is equal to string(triggerOutputs()?[‘body/Title’]) Then under Condition: empty(body(‘Filter_array’)) is equal to false

[@alyoshaferris1799]

@@HollyIsBest Thank you

[@alyoshaferris1799]

​@@HollyIsBestI am dummy I was using title column not id column it works great now

[@flammebeauregard8358]

After a few hundred lines, it creates duplicate in my Excel. As if it doesn't search the IDs in the Excel anymore, and just create a new case ! My coworkers modify entries all the time. We have 3000 lines in my Sharepoint List. What can I do ?

[@flammebeauregard8358]

@Lernen Tech : you love the fact is not working?

[@kristelvanuffelen6103]

Maybe you can change the settings in the 'List rows present in a table' step ? You can access via the 3 dots on the right and set 'pagination' on and 'Treshold' to a value higher than the number of rows your Excel will have. Only a newbie, found this tip somewhere online and It worked for me.

[@tbushnell1128]

The same thig is happening to mine. @Lernen Tech any update?

[@sharpzeeuk2737]

@@kristelvanuffelen6103 You... ARE....GENIUS! Thank you :D

[@dwesb221]

@@kristelvanuffelen6103 Thanks you. Works for me, as a note - Threshold seems to be limited to 5000.

[@gerfer6261]

👍 😎 To reduce the flow runs how to modify this to run once a day ( scheduled) for items older than 2 days [ for larger list]

[@LernenTech]

apply filter to check

[@gerfer6261]

@@LernenTech Eg,.?

[@gerfer6261]

@@LernenTech Eg,.?

[@LernenTech]

@@gerfer6261 For further queries do WhatsApp message on --> [phone]

[@gerfer6261]

@@LernenTech It be be good if you send me an email address please

[@blazehawkins2759]

Super helpful. Thank you very much for sharing this information! Please keep up the great work!

[@goldcarps]

Hi, if both the id in excel and SharePoint List is Number, then do we still need to convert the id column in SharePoint List to String during the Filter array step? Thanks goldcarps