Skip to main content

Notifications

Power Automate - General Discussion
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

  • tinalamkey Profile Picture
    tinalamkey 70 on at
    Re: Power Automate - How to include Column Text data in automated email

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

  • Verified answer
    FLMike Profile Picture
    FLMike 30,517 on at
    Re: Power Automate - How to include Column Text data in automated email

    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
    tinalamkey 70 on at
    Re: Power Automate - How to include Column Text data in automated email

    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

  • FLMike Profile Picture
    FLMike 30,517 on at
    Re: Power Automate - How to include Column Text data in automated email

    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
    tinalamkey 70 on at
    Re: Power Automate - How to include Column Text data in automated email

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

  • FLMike Profile Picture
    FLMike 30,517 on at
    Re: Power Automate - How to include Column Text data in automated email

    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

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard