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']

[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.

[shellyjean]

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

[eaindra]

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

[adityapadmawar]

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

[scaryfactfiction]

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

[AdnanKashemOxe]

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

[sedman]

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

[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.

[kellylieu]

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?

[alineruiz]

This was really helpful!! Thanks a lot

[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.

[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.

[adamosovsky]

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?

[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

[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?

[sseomsz]

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.

[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?

[blazehawkins]

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

[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

[lobnaamer]

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