This is driving me insane! Any help is appreciated!
I have a SharePoint List I use for tracking Customer Service Incidents. I am trying to utilize Flow to create the following Unique IDs based on the ID field that is autogenerated.
Example:
yyyy-(10000000+ID), so essentially as tickets are generated sequentially I would have 2020-10000001, 2020-10000002, etc by utilizing the ID number
My current flow is:
Each Time New Item is Created -->
Get Items (Values) -->
Compose (Get Year using utcnow('yyyy')
Apply to Each-->
Create Variable (adding ID and the value 10000000 together to form a new integer)
Compose 2 (Convert Variable Integer into String)
Compose 3 (Convert Year Integer into String) -->
Compose 4 (Concat output Compose 3, '-' and output Compose 2)-->
Update Items (Update Unique ID Field in SharePoint list with Compose 4)
When I run flow checker it tells me I cannot reference Compose 2 and Compose 3 in Compose 4 concat operation, this is the only error I get. I don't understand why if I converted everything to Strings why I cannot Concat them?
Any help is appreciated!
Solved! Go to Solution.
Hi @DarrylJP ,
I think your expression should look like :
add(items('Apply_to_each')['ID'],variables('Adder'))
——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Hello @DarrylJP
Could you share your flow and the expressions used, so we can help you?
Thank you.
Ferran
Hello, My flow is as follows. Flow Check shows no errors, but when I run it it fails. The field is a single text field with a limit of 100 characters
Flow 1
Flow 2
Flow 3
Flow 4
Flow 5
Flow6
Hi @DarrylJP ,
After looking at your Power Automate could you please confirm if in your "Apply To each" action your expression looks like:
add(items('Apply_to_each')['ID'],variables('VarID'))
Also, all your action part of "Apply To each" action - EndofID, Convert to string, string compilation, and update items.
If your answer is Yes, logically, your Power Automate should work.
If you still find an issue, send the screen capture of error action and error message.
DeepakS,
I have the following expression now in my Apply to Each which I re-labelled UpdateItem
Hi @DarrylJP ,
your UpdateItem loop input parameter seems incorrect , it should still point to "value" (output of GetItems) as you were using before.
——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
I ran a test and opened up the Test Log, for "EndofID - Status" it says Failed (all the predecessors of this action say succeeded, everything after says Skipped), this looks like the current cause of my problem.
Current code/Expression is:
Hi @DarrylJP ,
I think your expression should look like :
add(items('Apply_to_each')['ID'],variables('Adder'))
——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Thanks DeepakS for your patience and help, that lest step did the trick! Everything runs perfectly now!
What is your complete expression on String Compilation
Hi, What is your complete expression on String Compilation?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
72 | |
27 | |
22 | |
15 | |
13 |
User | Count |
---|---|
138 | |
43 | |
42 | |
35 | |
31 |