Unanswered

Send an email to different recipient based on list column selection (Microsoft folw & Powerapps)

(0) Share

Report

Posted on by Ugo_Zoli

Hello,

I am customizing a form on powerapps and I would like to send an email to a content validator once a form is submitted. This validator would change according to which department is selected from a dropdow list column (data card).

I tried to to populate the default field of a data card with the corresponding email address of the validator (to then trigger a flow) but it didn't work as the field will be completed after (not when) the form is submitted.

I also created a list in the Group with departments and corresponding validator email, and then used a Lookup function in Powerapps to fill the data card, but it didn't work.

Do you have any solution for this?

Thank you

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Would it be possible to configure the flow to run after the form submission?

For example, implement the Flow under the OnSuccess property of the Form control?

OnSuccess – How an app responds when a data operation has been successful.

This property applies only to the Edit form control.

Once configured, the flow would run after record creation, which should have the data available to use.

And you could take use of EditForm.LastSubmit property to get the data just submitted.

"

LastSubmit – The last successfully submitted record, including any server generated fields.

This property applies only to the Edit form control.

If the data source automatically generates or calculates any fields, such as an ID field with a unique number, the LastSubmitproperty will have this new value after SubmitForm successfully runs.

The value of this property is available in the OnSuccess formula.

"

Reference:

DisplayForm and EditForm in PowerApps

Please let me know if this works for you.

If not, then please share us with more details here and we will see if we could offer a better solution.

Regards,

Michael
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Ugo_Zoli can you review the above proposed solution and reply back if this was helpful?

Thank you.

@Anonymous