I'd like help for making a unique ID where it is in this format "AB/20" where the name is "Alice Bob" from Name in a form and 20 is the year from the submission time of a form. this will then go in the excel sheet where there are two tabs, one has the personal details so the ID should link this and the second tab with the rest of the form data from this person.
I know it has something to do with splitting the name variable, concat the first letter of the first part of the string with the first letter of the second part of the string then concat with the forward slash and then getting the year in the submission time however I am struggling with making this expression...
Could anyone help me do this?
I've used this expression and put a compose as I am looking at other solutions but I do not know if I am doing this correctly I am trying to split the name using the space as a delimeter... :
Solved! Go to Solution.
Hi @fchopo ,
When I run the flow it returns an error now of Array out of bounds for getting the second letter, is the expression correct? It makes sense to me but I'm not sure if the syntax is..
I would think when a name of A B is inside the  would be able to retrieve B from the split word but it doesn't seem to work on my side...
update] it was not copying properly from my text editor!
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!