Skip to main content

Notifications

Power Automate - General Discussion
Answered

Converting Number to Text within flow

(0) ShareShare
ReportReport
Posted on by 76

Simple issue that I am stuck on.  I have a flow that populates a field in a SharePoint doc library with the next revision [New Rev] of a SharePoint file based on the current rev number [Eff Rev].

JT1964_0-1687465031603.png

This works great when New Rev is a number. If the flow initiator intends for the file to be cancelled they can provide this as an input when the flow is initiated by assigning Yes to 'Cancel1'.

JT1964_1-1687465478930.png

 

I want the rev to now change from a number to text and equal "Cancel" and as expected, I get an error when I make this change.

 

Is there a way to re-establish 'New Rev' as text within the flow at a step just before updating properties

JT1964_2-1687465551514.png

Thanks!

 

  • Verified answer
    wskinnermctc Profile Picture
    wskinnermctc 6,512 on at
    Re: Converting Number to Text within flow

    Is the "New Rev" and "Eff Rev" properties from the document? Or is it from a column in the Document Library? 

     

    Either way, you need to go check if it is a Text or Number type. If it is a Number, then you will not be able to put any text in the field.

     

    Here is an example of the properties in a document, and you can see there are different types like Text and Number.

    wskinnermctc_0-1687472244945.png

     

    Or you can go to the Document Library settings and look at the column types there.

    wskinnermctc_1-1687472475618.png

     

    If those columns are Number type then you will not be able to put "Cancel" into the field.

     

    Maybe you could try putting in 99999 or something if that helps signal the file is cancelled. Or you can move the file into a different folder that is for cancelled documents.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard