cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jlrichardson
Level: Powered On

Use Split function with dynamic SharePoint content

I am working on a flow to notify identified responsible parties in a SharePoint list if the Estimated Completion Date for their record has passed. I've got the flow working, but am trying to get the Email just how I want it.

 

Below is what I have now, but I want to make the salutation more appropriate by splitting the dynamic GTT in Charge Display Name (full name from our AD) and only adding the first name.

Annotation 2019-10-30 144510.png

 

Is there a way to use the split() function with dynamic text so I can create a salutation for the email to be:

"Hi <Display Name>," but use split to split the DisplayName on " " so it only displays their first name vs their full name?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Use Split function with dynamic SharePoint content

Pass GGT in Charge Email into Get user profile action. This will return a lot of values about the user including Given name

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Use Split function with dynamic SharePoint content

@jlrichardson 

You can use the split expression as you have suggested.  The Split expression populates an array that you specify.  You can then use the "first" expression to get the first element in the array.  See my example below.  My expressions can be seen in the comments area.  That said, I don't think it is a good idea as many "first names" have spaces in them.

Split1.jpgSplit2.jpgSplit3.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Super User
Super User

Re: Use Split function with dynamic SharePoint content

Pass GGT in Charge Email into Get user profile action. This will return a lot of values about the user including Given name

View solution in original post

Super User
Super User

Re: Use Split function with dynamic SharePoint content

@jlrichardson 

I agree with @Gristy - you should be using Get User Profile.  The specific property you'll want to use is Given Name.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,622)