cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mgreen91
Helper I
Helper I

Power Automate cloud flow - send an email

Hi

 

I'm struggling to retrieve the foster claimer email to then send the email to.

 

I connect to the Animals Information table, when a row is modified (i.e. status changed to Claimed for Foster)

 

Then get row by ID to retrieve the foster claimer email

 

Then send an email

 

17 REPLIES 17
mgreen91
Helper I
Helper I

mgreen91_6-1716468356591.png

 

Are you sure that your Foster Claimer column (in the Animals table) is a lookup column to the Foster table?

 

From your photos of the available dynamic content, it seems like the data type is text. This might be why your input on the flow status was "FH-035", because it just got the text value from the record - it didn't get the data from the Foster table. 

 

The lookup columns should have several options in the dynamic content, like in my photo where there is Value and Type. When you choose Foster Claimer (Value) it will get the GUID.

 

StineN_0-1716468597646.png

 

mgreen91
Helper I
Helper I

mgreen91_0-1716470165056.pngmgreen91_1-1716470197156.png

 

mgreen91
Helper I
Helper I

I'm getting really frustrated as I completely understand what needs to happen but it just isn't working 😞

mgreen91
Helper I
Helper I

OMG DONE!!!

 

I had the non lookup field in my form - Thank you all SO MUCH!!

Yay, that's great to hear! Happy to help 🙂 

Cant we just send all the animal details as parameters,  when we call the power automate flow to send an email to foster claimer ?

BCBuizer
Multi Super User
Multi Super User

Hi @PratikJ ,

 

Indeed that is an option as well. There are many different ways of doing this, all with their own pros and cons, so you can do what you think is the best way.

 

For the Power Up Challenge the main goal is that you have a functionality to fulfil the requirement. How this is technically implemented is less relevant.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Helpful resources

Announcements

Learn what to expect in the Power Up Program

Since its inception in 2022, the Power Up Program has evolved based on feedback from learners and Microsoft Partners and customers. Today's Power Up learners can expect to learn the fundamentals of Microsoft Power Platform in the accelerated seven-week, video-based Power Up Maker course.   Hear from Principal Program Manager, Dimpi Gandhi to discover the latest enhancements and meet the Microsoft MVPs, Rory Neary and Charlie Phipps, who partnered with the Microsoft Power Up Program to create the Power Up Maker course to guide learners to use the Microsoft Power Platform to develop custom applications, build dazzling report dashboards, or create efficiencies through automation.  

Welcome to the Power Up Program Community

The Power Up Program is a free upskilling program where nontechnical people can learn the fundamentals of Microsoft Power Platform. The Power Up Maker course is a seven-week self-paced virtual learning plan that include video-based objectives featuring Power Apps, Power BI and Power Automate.  As a member of the Power Up Community, you can grow your skills and build connections. You can post questions to get help with the curriculum and hands-on exercises from experts and peers in the product boards.  Check out the Community Information & Feedback board to find help or provide feedback with the community experience, and please take time to post in the Social board to tell us more about yourself. If you're new to the Power Up Program and looking for information to register. You can sign up at PowerUp.Microsoft.com.

Top Solution Authors
Top Kudoed Authors
Users online (4,542)