New Version Available issue in Sharepoint

Question

Hello,

I am having an issue with Powerautomate and the extracting files from a paginated report. My current flow is scheduled for a certain day of the week. It then deletes the current excel file in SharePoint Folder and creates a new one with the information of the paginated report.

**I've also tried it where I update the file content rather than deleting and creating a new file.

 

The flow runs correctly, and the files are correct. However, the issue I am having is when another person opens the extracted file, they receive this error at the top of the file. (screenshot 2). I do not receive this error only other individuals do. the side affect of this issue is  I have another file doing a VLOOKUP to this extracted paginated report and the VLOOKUP's wont point to the new file unless the person clicks discard changes.

Answer 1

The "New Version Available" issue occurs because SharePoint is detecting the file as changed. Here are steps to resolve:

1. Use Update Instead of Replace: Avoid deleting and recreating the file. Instead, use PowerAutomate's "Update file" action to modify the file content, which reduces version conflicts.
2. Disable Autosave in Excel: This may prevent users from seeing the "New Version Available" message when opening the file.
3. VLOOKUP Adjustment: Ensure the VLOOKUP references the correct file path after updates. You might need to update the data connection to reflect the new version properly.

These steps should help minimize the issue. Let me know how it works!

---

This version focuses on practical steps to resolve the issue while keeping it brief.