Forum Discussion
Create version number and add +1
- I created a column called “Versionsnummer” as text, in which the version of the document from the SharePoint "Version" (see picture, 67.0) is created via PowerAutomate; displayed as a number (but is text according to the above setting)- works, see picture, 66.0; as this is text, in need to converte to number
- So i created a column called “Umwandeln” as a number and entered above "Versionsnummer" via calculate (formula: =[Versionsnummer]) and stored the data type returned by the formula as a number- works, see picture 66.0; now i want to add +1 to that
- I created a new column called “Umwandeln+1” as a number from the “Umwandeln” column to add +1 to the version number (from 2.) using a calculated formula (formula: =[Umwandeln]+1)- does not work #Value!
Does anyone have any idea why this isn't working? However, i havent´s found any similar conversations. Thx in advance!
10 Replies
Formats:
Hi VZKRB4,
You can use a number field for Versionsnummer and while populating the field using Power Automate, convert the string to float.
Steps:
Add Action Compose in Power Automate.
In the Inputs on compose action, use the syntax below. Please replace "variables('StringVariable')" with your own variable or dynamic content.
float(variables('StringVariable'))When updating the values in a list, use the output value from the Compose action.
--------------------------------------------------------------------------------------------
If this solution works for you, please consider marking it as the accepted answer.
Dear PankajBadoni, thanks!
I updated power automate flow as suggested and had to change the column Versionsnummer from text to number- now its working and i can use column Versionsnummer+1 in word as real document Version based on Sharepoint!:
I will play with Power Automate to may get Versionsnummer automatically added +1 😀
Hi Dave, thx for support.
In case i am creating manually column Versionsnummer as number and fill it manually with data it is working fine but not using PowerAutomate to fill column Versionsnummer (which must be text allowing PowerAutomate to run).
Meanwhile i have got this types of failure:
I need to use in word the SharePoint Version, Quick-build blocks and document properties), and to do that i need to read the SharePoint Version into Versionsnummer (text), transform into Umwandeln (number) and add +1 in Umwandeln+1 (number).
Hi Dave, thx for suppport.
In case i am doing that manually its also working on my side but not with column Versionsnummer filled by PowerAutomate:
Column Version is the "standard" by SharePoint i want to use as Versionsnummer in word.
To do so, i am using PowerAutomate to read the SharePoint Version and write that into column Versionsnummer (must be text to run the PowerAutomate) see picture
Column Umwandeln is the idea to convert text into number see picture
Hi Dave, thx and working in case of doing that manually but still not with PowerAutomate filled column Versionsnummer:
Version is "standard" by SharePoint and i want to use the version in word as Versionsnummer.
To do so, i am using PowerAutomate to read the SharePoint version number and write into column Versionsnummer (must be text to run the PowerAutomate):
Column Umwandeln is the idea to convert text into number:
Hi VZKRB4
have you set number as data type in your column Umwandeln+1?
In my case it works fine:
Best, Dave
Hi Dave, thx for support.
In case i create manually the column Versionsnummer as number with manually entered number (fe. 70) and create manually the columns Umwandeln and Berechnet+1, it also works on my side but still not working with PowerAutomate.
Is there maybe a seeting/definition issue with PowerAutomate filled column Versionsnummer (as described, i am reading the SharePoint Version with PowerAutomate and write it into column Versionsnummer to use it as versionnumber (quick-build blocks, document properties) in word). Meanwhile, i have got to versions of failure, see screen shot (both word files):
Format Versionsnummer text (and text, to run PowerAutomate; if i change that to number PowerAutomate gives a failure):
Format Umwandeln number (and number, idea is to move text from Versionsnummer into number):
Format Umwandeln +1:
Any idea? Rgrds Ro
Hi Dave, thx and in case i create all that columns manually it works fine (Version or Versionsnummer as number and entered manually value f.e. 70- Version/Versionsnummer is 70, Umwandeln is 70 and Berechnet 71). But in my case, as Versionsnummer is created by PowerAutomate on Version (SharePoint), it still doesnt work. I have now the effect that one word document shows same behaviour as reported (umwandeln+1 is now #Name instead #Wert) and another is 36.771! Any idea? Is the format from Versionsnummer created by PowerAutomate on SharePont, Version, "wrong" even it shows as a number? Rgrds Ron
