web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate - How t...
Power Automate
Answered

Power Automate - How to include Column Text data in automated email

(0) ShareShare
ReportReport
Posted on by 70

I have a power automation that triggers an email to be sent when you change a column to "Sent to Accounting".  In the email, I would like to add contents from a column that has text in it (Amount to Bill).  Can anyone assist?Capture1.PNGCapture.PNG

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,960 Moderator on at

    Hi @tinalamkey 

     

    Can you clarify what is wrong, is it not showing up? Your code looks pretty good. 

     

    Happy to help just dont see any glaring issues.


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

     

  • tinalamkey Profile Picture
    70 on at

    No information is included in the email after the word: ‘Notes:’ - it’s blank. 

  • Michael E. Gernaey Profile Picture
    53,960 Moderator on at

    Hi @tinalamkey 

     

    Since the Dynamic property (I am assuming) is coming from your Trigger, than that tells me that the value is blank and is why it doesn't show anything.

     

    Can you verify for me if this is incoming from your Trigger? If so at the top of your flow, after the trigger, add a compose. in the compose action, just put that Dynamic property.

     

    if it doesn't show any data, then there is no data. You could always, do a Get Item (using the trigger item Id) and see if somehow that populates it, but I would suggest validating its the correct field and then looking up that record to make sure something is there.

     

    I mess up all the time, my brain says to me it HAS TO BE THERE its there look and then finally I look and go whoops wrong field, wrong record, I didnt set that value yet or I did but I didn't do a Get Item to reload its data into another (populated) dynamic property.

     

    Since you didn't share the whole flow, I can only use educated guesses here as nothing else than what I wrote makes sense.


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • tinalamkey Profile Picture
    70 on at

    Mike:  Thank you for the reply.  Attached is the whole flow.  Let me know where you might suggest I add the compose part, if that is what you are suggesting.  For now, in the email body, I took out the "amount to bill" item since it was not working, for now.FireShot Capture 007 - Edit your flow - Power Automate - make.powerautomate.com.png

  • Verified answer
    Michael E. Gernaey Profile Picture
    53,960 Moderator on at

    Hi @tinalamkey 

     

    Your flow itself is a nice flow that makes sense to me, based on what I see.

     

    Since that one value wasnt working, yes I would put the Compose in between the Trigger and the Get Changed Properties.

     

    This way you can see if the Trigger is giving you a value or not and compare that to the back end. I would hate to make you put in a Get Item action also, as it should be overkill, but you may need to.

     

    But there should be a Trigger dynamic property for that value you wanted, so lets verify its value first using the compose.


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

     

  • tinalamkey Profile Picture
    70 on at

    I was able to solve it!  Thank you! FireShot Capture 008 - Edit your flow - Power Automate - make.powerautomate.com.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard