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?
I was able to solve it! Thank you!
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
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.
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
No information is included in the email after the word: ‘Notes:’ - it’s blank.
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