Unanswered

Update a SharePoint file by multiple people?

(0) Share

Report

Posted on by zesamsam

Hello,

I'm trying to set up a Flow that would be used by multiple people in my team, where they would each update an Excel file with events they would create on their own Outlook, and then the information would be transfered to a consolidated Excel file on a team SharePoint Online site.

My question is the following: does the Flow action "SharePoint: Update File" simply add the new information from each person's file on the consolidated file, or does it overwrite the file with each person's file content? (I fear the second... )

I'm asking because as I want to have a consolidated file, I'll obviously have to create a write-back flow if I want to avoid every team member overwriting the common file

Thanks for any information that can help!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

v-micsh-msft on at

Like (0)

Report

Hi @zesamsam,

Yes, the SharePoint Update file would overwrite the file.

As the Excel connector doesn't support to connect to SharePoint Online library, so to update within the WorkSheet is not available.

You may consider move the Excel into OneDrive for Business shared folders, which is possible to take use of the Excel connector to update rows.

Connector reference:

Excel

Regards,

Michael

Was this reply helpful? Yes No
zesamsam 8 on at

Like (0)

Report

Hello @v-micsh-msft

I'm not entirely sure this solves my current issue: as different team members are to update the same Excel file with their information, I need the file to be accessible by all. I cannot do that on someone's own OneDrive for Business, or I didn't understand how to reach a public shared folder. The only solution I have found, again, would be to first copy the shared Excel file from the team SharePoint Online site back to each team member's OneDrive, then update the file, and copy the newly updated file back to the team SharePoint site. But that's a hassle, and on top of that I'm still sensitive to simultaneous updates (where two or more people would trigger the flow at the same time, resulting in each overwriting the other's version).

Was this reply helpful? Yes No