Marketing Form Submitted values and Power Automate Notification

(1) Share

Report

Posted on by Odetonoise1

Hi Team,

I was trying to extract the values of a form submission with power automate and place the submitted values into an email notification.

However, whenever I try to place the submitted values (shown below) attribute into an email, it just comes up as blank.

I selected "store form submission" on the form record so a copy would be kept in Dynamics, separate from the insight database.

It also appears that msdyncrm_submittedvalues is missing from the JSON that Power Automate is receiving, although the attribute is available as dynamic content in the email block.

Should I be using an HTTP request and hitting the insights database for this info? Not sure what the appropriate way of getting to the submitted values is.

Thanks in advance for any help/advice.

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Nya 29,060 on at

Like (1)

Report

Hi, Odetonoise1

I have tried to reproduce your issue. I found that in the Get a row step from run history, the corresponding value can be retrieved, but it is not displayed in the Email.

You need to add an action into the steps before sending the email.

Set the filter as that the id of the submission record equals the record which has been initialed. And select the Submitted values only.

Then put the list into the email.

Finally, the specific values can be placed into the email correctly.

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya

Was this reply helpful? Yes No
Suggested answer

Odetonoise1 20 on at

Like (0)

Report

Thanks Nya,

This solves the dilemma of getting the submitted values.

Any thoughts on parsing the submitted values out of the JSON body?

This gets me closer but I'm still not clear on how to present the submitted values in a readable format.

Thanks!

Was this reply helpful? Yes No
Gemma2020 61 on at

Like (0)

Report

Hi

I think we're trying to do something similar here. Did you use Dataverse as the trigger, or something else? We only seem to have access to Dataverse and can't access 'Marketing Form submissions' from there.

Any help appreciated.,

Thanks

Gemma

Was this reply helpful? Yes No
Suggested answer

Nishant Rana 11,325 Microsoft Employee on at

Like (0)

Report

Check out these posts as well - www.ameyholden.com/.../automate-dynamics-365-marketing-form-submissions-for-custom-tables-with-power-automate and nishantrana.me/.../

submitted value is a calculated column.

Was this reply helpful? Yes No
Suggested answer

Nishant Rana 11,325 Microsoft Employee on at

Like (0)

Report

Make sure you have selected the correct Marketing Environment.

Was this reply helpful? Yes No