SharePoint list vs Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All Have Resolved. Thank you!

---------------------------------------

Hi I would like to confirm if the following requirement can be realized and how to do that.

There is a share point list which has a lot of columns.

There is an existing Excel file which includes several same column as SharePoint but the order is different.

Requirement

When the item share point list is updated or newly created, we want to add the new one to the last row of Excel file and update the contents of Excel columns based on updated columns of sharepoint.

Sharepoint:

Excel:

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Yes this is possible but why are you holding data in two places. Surly one would be best that being the SP List.

I hope that helps.

Regards

Andrew

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Andrew_J Thank you for your reply.
Could you please kindly tell the actions I need to use? Thanks a lot!

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

According to your needs, I have a test for your reference.

Best Regards,
Dezhi

Was this reply helpful? Yes No