cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Making a unique ID

Hi,

 

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... :

first(split(triggerBody()?['Client Name'],'\s+'))

 

Screenshot 2020-02-29 at 10.55.05.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Making a unique ID

Hello @KA 

Please, have a look at the following flow with the expressions used on each of the steps:

2020-02-29 13_11_26-Window.png

Hope it helps!

Ferran

View solution in original post

3 REPLIES 3
Highlighted
Solution Sage
Solution Sage

Re: Making a unique ID

Hello @KA 

Please, have a look at the following flow with the expressions used on each of the steps:

2020-02-29 13_11_26-Window.png

Hope it helps!

Ferran

View solution in original post

Highlighted
New Member

Re: Making a unique ID

Yes! That works! thank you so much!!!

Highlighted
New Member

Re: Making a unique ID

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 [1] 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!

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,057)