cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

When updating an excel table I get 'too many versions' error - can there a way to set or reset this?

My flow writes an excel table row when an event occurs. The file is in OneDrive. The event occurs about 100 times a day.

 

After a few days it starts to fail - error message is 'too many minor versions' (so Flow can't update the file).

My workaround now is to manually publish that file - and then it's ok for a few more days.

 

My question: is there a flow function to either prevent the version updating? Or to reset it somehow? or to automate the publishing action (maybe I could run that on a schedule for example)?

 

Or any other solutions pleaseee.

 

Sam

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

There is nothing I know of built in to Power Automate to allow controlling of major and minor versions.  There is however a way to publish a file as a major version using an HTTP REST call.  I would suggest either adding logic to your flow that checks the version number and publishes it if its getting large or creating a second recurrence flow that would run once a day to publish a new major version.  You can read about the REST call to Publish a major version here.

Publish files in SharePoint using Microsoft Flow and Column formatting - About365



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

5 REPLIES 5
Pstork1
Dual Super User III
Dual Super User III

There is nothing I know of built in to Power Automate to allow controlling of major and minor versions.  There is however a way to publish a file as a major version using an HTTP REST call.  I would suggest either adding logic to your flow that checks the version number and publishes it if its getting large or creating a second recurrence flow that would run once a day to publish a new major version.  You can read about the REST call to Publish a major version here.

Publish files in SharePoint using Microsoft Flow and Column formatting - About365



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

tom_riha
Super User
Super User

Hello @Anonymous ,

you should be able to disable minor versioning directly in OneDrive. You can 'Return to classic OneDrive' on the left side. Then go to Settings -> Site contents -> Settings on your library -> Versioning settings, and disable creation of minor versions.

Or try to change the url to get to the Site contents directly, instead of /onedrive.aspx use /viewlsts.aspx

image.png

 



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
Anonymous
Not applicable

@tom_rihaThat's brilliant - I knew OD was Sharepoint (of course) but have never seen the settings available like that.

Not quite what I need, but many thanks for the tip.

Sam

Anonymous
Not applicable

Thank you @Pstork1 I expect this is the solution (and I'll mark it as such when I've had a go) - in the meantime I've been exploring the Onedrive connector a bit more.

 

I'm not finding any way to get the version number of a Onedrive file. (and to get for a SP file isn't easy it seems)

Or to check-in (or publish) a Onedrive file.

 

Will that HTTP REST call work on OneDrive files? What would be the server and path please?

 

Thanks

Sam

 

 

Pstork1
Dual Super User III
Dual Super User III

Yes, you can disable minor versions for OneDrive.  Just be aware that the Files Restore functionality is dependent on versioning in OneDrive.  So if you make changes to automatically clean up versions, by switching to Major version only, you will be limiting your ability to recover files in the case of a disaster.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,581)