HI. I am trying to build my first Flow in order to automatically create a reference number for new records added to a Sharepoint list. I wanted to use the autonumbering ID field and prefix it with a fixed text value and preceding zeros. For the moment I'm just trying to build an expression to concatentate the text prefix and the ID field value as follows:
concat("ABC",string(triggerBody()?['ID']))
Solved! Go to Solution.
Hi @biterbit
Looking at your expression, you cannot use double quotes to wrap a string; you have to use single quotes. Second, you don't need to convert the ID column to a string; Flow will use the ID value in a Concat() expression. This is how the expression looks like on a test I just ran:
concat('ABC', triggerBody()?['ID'])
This is a screenshot of the outcome:
Please try this out when you have a chance and let me know.
Regards,
Fausto Capellan, Jr
Hi @biterbit
Looking at your expression, you cannot use double quotes to wrap a string; you have to use single quotes. Second, you don't need to convert the ID column to a string; Flow will use the ID value in a Concat() expression. This is how the expression looks like on a test I just ran:
concat('ABC', triggerBody()?['ID'])
This is a screenshot of the outcome:
Please try this out when you have a chance and let me know.
Regards,
Fausto Capellan, Jr
Thanks Fausto. I knew it would be something simple. It's always the punctuation that catches me out when working with new languages.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
39 | |
37 | |
37 | |
32 | |
27 |
User | Count |
---|---|
39 | |
37 | |
32 | |
28 | |
23 |