cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lucas_Goncalves
Advocate II
Advocate II

Update only newly added row on excel into an sharepoint list

Hi there! I have a flow that, daily, he checks an excel file stored on SP, copy the excel´s rows, go to a list (Lets Call this list Vendor), delete all the list itens and updates the list with this excel rows:

 
 
 

1.png2.png

 

It works and daily i have the sharepoint list updated.

 

The problem is that this updated SP list supply with information another column (Fornecedor) on another list (Lets call RC). Thys "supply" is of choice to user. This RC List have a form thar is mandatory to select a vendor(Column Fornecedor). 

3.png

 

When the flow deletes the Vendor itens list to update them, the colum information disapears. I mean, as you can see on the image, everytime the flow runs, the field is blank, despite it being mandatory.

 

Can you please show me how can I ensure that only the new Excel's row to be updated on the SP List Vendor?

0 REPLIES 0

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,562)