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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,703)