web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Trying to auto generat...

Power Automate

Answered

Trying to auto generate a request number to SharePoint List field

(0) Share

Report

Report

Posted on by F_Quint

257

I'm trying to add a Request number that starts with SR800000000000000 and the SharePoint ID number (4 integers) is appended to this.

In other words, if my SharePoint item ID number is 3489 it would return SR8000000000000003489

I tried the following expression to no avail

add(triggerBody()?['ID'],800000000000000)

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @F_Quint ，

You should take a try with the concat() expression instead of the add(), the add() would require the parameters to be a mumber type however the SR800000000000000 is a string.

Please make sure the Request number column should be with the Single line of text type and take a try with the below expression:

concat('SR800000000000000',triggerBody()?['ID'])

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No

Join the conversation