cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CWileyRRT
Helper IV
Helper IV

Get first email address from list of items

I am running a scheduled flow to get items from a SPlist which includes a people picker column. How can I pull the first email address from all the items it collects that match my query to use as a send to for an email?

1 ACCEPTED SOLUTION

Accepted Solutions

@CWileyRRT 

 

Oh wow, that is weird.

Copy that value from your variable.

Now use a parse JSON action below your variable. Pass in the variable, and click generate schema from example,

 

this is where you paste the copied value from your variable.

Now you should be able to use dynamic content from parse JSON that has just the email address


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

5 REPLIES 5
Jcook
Super User
Super User

Hello @CWileyRRT 

 

I might need more information.

 

Try using the first() expression.

 

The syntax will be:

first(<DynamicContent)?[‘columnname’]


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





@Jcook 

 

I'm confused about your bracketing? The column is "Reserved By", what would I put for the dynamic content? The value of the get items?

@CWileyRRT 

 

Yes that is correct. Use the value from your get items. Then you want to add ?[‘Reserved By’] to the end

 

? = looking for a value that is present or null

[ ] = the column name you want to find


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





@Jcook 

 

So I think I got it except the email address comes along with extra information as shown. My output of the email ends up being blank because of this?

 

2020-08-03_19-55-09.jpg

@CWileyRRT 

 

Oh wow, that is weird.

Copy that value from your variable.

Now use a parse JSON action below your variable. Pass in the variable, and click generate schema from example,

 

this is where you paste the copied value from your variable.

Now you should be able to use dynamic content from parse JSON that has just the email address


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,256)