Automated flow to update duplicate SharePoint Online 'Version' column

(0) Share

Report

Posted on by AnnaliseB

Hi All,

I'm very new to Power Automate and am struggling to achieve what I had hoped would be a simple task. 😅

I need a custom field in a SharePoint Online (SPO) library that contains a dynamic copy of the file Version number (duplicate Version field called 'SPVersion' - to feed Excel Macros).

SPO Calculated fields seem useless in this context as they don't automatically recalculate when the version number changes (Major + Minor), so I'm hoping a Flow might help?

I've started looking at a flow of the following design, but am struggling to get the connection to the library in the HTTP Request working correctly... (Error: "Input string was not in a correct format.").

I'm also not yet sure how to complete the loop and update the value in the 'SPVersion' field (still investigating expressions).

Allowing for my flimsy understanding of this platform, is anyone able to guide me to get this right, and completed please?

Thanks, AB

Categories:

General topics

All responses (6)

Answers (0)

Sort by

jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@AnnaliseB has this been resolved ?
AnnaliseB 6 on at

Like
a
(0)

Report
Copy link

Link copied!

not yet, no.
jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!
@AnnaliseB This is what I have done to get the version history of the item
_api/web/Lists/getbytitle('Employee')/items('ID')/versions /*endpoint*/ outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']['results'][0]['VersionLabel'] /*extract from http output*/
Hope this helps.

And I think you have also done everything correctly, you just need to pass the ID in single quotes 'ID', you have just passed the ID which is number, hence you are getting the error that input needs to be a string. Just pass the ID in your http action like this 'ID' it should work.
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
AnnaliseB 6 on at

Like
a
(1)

Report
Copy link

Link copied!

Since my last post I've found a solution that works though I've discovered my design is a little flawed in logic (the "SPVersion" field is always one minor version behind as a consequence, or there would be an infinite loop 😅)

Uri:
_api/web/lists/GetByTitle('Training Internal Reference')/items(@{outputs('Get_file_properties')?['body/ID']})/validateUpdateListItem

Body:
{
"formValues":[
{
"FieldName": "SPVersion",
"FieldValue": "@{outputs('Get_file_properties')?['body/{VersionNumber}']}"
}
]
}

Thanks,
AnnaliseB
mabster168 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @jinivthakkar,
I am really struggling with the power automate as i am wanting to add the Sharepoint Version in a excel document, all I know is that it can be done but I keep hitting walls. On the Uri above what should I be pointing it towards? as I am unsure where Employee comes from. I have spent weeks trying to sort it out and just come across your post. Many thanks in advance.
mabster168 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @AnnaliseB did you get this working in the end please i want to do exactly what you are doing. was your sharepoint a list or a group of documents.

Thanks
Mark