cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SomeoneAwesome
New Member

Is it possible to update a excel file (table) everytime a sharepoint item is added to a sharepoint list

Hi,

 

I have been struggling with this problem for awhile and im not sure if it is even possible to update a excel file (table) everytime a sharepoint item is added to a sharepoint list.

 

If it is could someone point to me where im going wrong with the following flow>?

 

111.png

222.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @SomeoneAwesome 

I set up a simple flow, you can take a try with the screenshots below.

This is my test list and excel.

vLilyWmsft_5-1634611273779.pngvLilyWmsft_4-1634611260192.png

vLilyWmsft_0-1634610851414.png

vLilyWmsft_1-1634610908402.png

Expression:

empty(outputs('List_rows_present_in_a_table')?['body/value'])

vLilyWmsft_6-1634611915578.png

 

vLilyWmsft_3-1634611009941.png

Save and test the Flow.

When an item is modified in the list, the row in the table with the same ID will be automatically modified.

When an item is create in the list, a new row will be automatically created in the table.

 

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
PrasadAthalye
Super User
Super User

You dont need apply to each. Just use Filter array which will filter a particular excel row. Then you can continue with your logic of If condition and add\update.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

I tried that and it wouldnt add a new item, it would only update if its already there? ie if ID is say 20424 it would find it and update but if the id is say 30002 and is a new item it wouldnt add it.?

 

could you pretty please do a mock flow? maybe im doing the filter array wrong but it would give me zero output? on the new items its supposed to add to the row

v-LilyW-msft
Community Support
Community Support

Hi @SomeoneAwesome 

I set up a simple flow, you can take a try with the screenshots below.

This is my test list and excel.

vLilyWmsft_5-1634611273779.pngvLilyWmsft_4-1634611260192.png

vLilyWmsft_0-1634610851414.png

vLilyWmsft_1-1634610908402.png

Expression:

empty(outputs('List_rows_present_in_a_table')?['body/value'])

vLilyWmsft_6-1634611915578.png

 

vLilyWmsft_3-1634611009941.png

Save and test the Flow.

When an item is modified in the list, the row in the table with the same ID will be automatically modified.

When an item is create in the list, a new row will be automatically created in the table.

 

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Thankyou, you have made myself and my client extremely happy 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,413)