cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EdouardSalesse
Regular Visitor

HELP ; Export of a sharepoint list to an excel table

Hello, I am writing to you because I need help and I hope I can benefit from yours. I would like to create a sharepoint list export to an excel table. My program works but when modifying an item in my list, the automaton creates a new line on excel when I would like it to modify it. Do you have any idea how to get there? Thanks in advance.

 

2.png

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @EdouardSalesse ,

 

To achieve it, we need to create an ID column in excel and it should be enforced unique values.

Sample:

vxiaochenmsft_0-1666161356608.png

vxiaochenmsft_1-1666161363220.png

vxiaochenmsft_2-1666161369212.png

 

Best Regards,

Wearsky

Hello, Thank you for your answer. I applied what you showed me except that the condition on the left is always chosen, the condition is 'true' each time. As you can see, on sharepoint I added a comment 'test222' except that the automaton therefore recreates a line each time. How to make the condition pass to the left?

 

7.png

6.png

  

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,308)