Dynamics Community Forum Thread Details

Including variables (like project number and address) in Power Automate notification mail

Hello everyone,

Back again with another Dynamics question. For this client of mine I managed to set up a PA flow. Whenever the user requests certain documents, a case gets created for this request. A department of my client then receives an email notifying him/her about the newly created case. This notification is an email that gets sent out through Power Automate. In this mail I want to include certain information about the request (for example the project number for which a request was submitted)

I'm new to Power Automate so this is how my email looks right now.

I included beneficiary's name and date of request but whenever I test this email, I receive all the info except for those two. The rest of that mail was created by a more experienced colleague. I'm pretty sure I'm doing something wrong. I'm not letting PA know where to get that information probably but I don't know how to change it.

Thank you

Hi,

Could you please post the whole flow as a screenshot in order for me to get more context on the previous steps and what they are doing.

Firstly, I would go to the flow history and check the details of the succeeded/failed flow. You can then see if the values you are requesting are objects or just not populated. If its not populated then you need to check the if the values on the form or entity are filled in.

To check the flow data, go to Flows > select your flow and then click on one of the records in the 28-day run history

Once in the record, click on the step where the data is passed into or the previous step and view the data and try to find the field you have passed to see if it has any values in it

You might find that you need to do casts like for example. On this record the sender value is an email or guid and it exists in the contacts table, power automate doesnt know that so we need to direct PA to the table and pass the value in