Answered

Use Split function with dynamic SharePoint content

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

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.

Was this reply helpful? Yes No
Verified answer

Gristy 2,429 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

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

Was this reply helpful? Yes No