Answered

Send a copy of form response to the user who completed it

(0) Share

Report

Posted on by ANTHR1CH

Hey PA community!

I have a simple Canvas app, which contains a form that when submitted - I'd like it to send a copy of the responses to the user who completed the form.

Currently, the form pulls the user's name, and email address from our Azure AD. The submitted form is then loaded into a MS Lists list.

The "submit" button trigger submits the form, so I'm hoping there is a command which can run on this trigger to get the response data and send an email to the user who completed the form. Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

SBax 1,348 on at

Like (0)

Report
Copy link

Link copied!

@ANTHR1CH

Please refer to this thread

You will find an explanation of how to convert the completed form to a PDF and email it to the user

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ANTHR1CH ,

The article referred to by @SBax is mine, but unfortunately, I do not think it is what you want. If I am reading this correctly, the user is completing a MS Form and you want a copy of this emailed to them from the MS Lists responses ? You have also mentioned the email from AD - how and where is this used ?

Was this reply helpful? Yes No
ANTHR1CH 20 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz thanks for your response.
So the form in my Canvas app, submits an MS Form, the form is then loaded into my MS Lists to be processed in an easier way (it's a feedback form). We use the AD info to automatically pull through the users name and email and load that into the form to save them having to fill this information out each time they submit a form.
I have power automate doing some work in the background so I don't know if maybe the email could come from that part? Currently the PA gets the form responses, creates a new item and then sends a notification to a teams channel to let us know there is a new feedback item to be looked at.

thanks again,
Anth.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @ANTHR1CH ,

I am still not totally clear - I assume your App opens an MS Form that is then submitted. One of the deficiencies of MS Forms is that it does not accept incoming parameters in the URL to pre-populate fields (so the Flow then knows where to send it back to). The only path I can think of is making the user's email compulsory in the MS Form and use that to link it back to the record. I use another Third Party Form that is able to be pre-populated, so is easily sent back to its required destinaiton.

Was this reply helpful? Yes No
ANTHR1CH 20 on at

Like (0)

Report
Copy link

Link copied!

Sorry @WarrenBelz , I've confused myself with this - Too many balls in the air!
What actually happens, is when the user submits the form - A new entry is written directly to the MS Lists. The form is a standalone one that isn't used in the app at all.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ANTHR1CH ,

I need to understand the terms you are using - MS Lists is SharePoint - MS Forms is (from what you have described) a standalone Form from this site. What standalone form are you talking about here ?

Was this reply helpful? Yes No
ANTHR1CH 20 on at

Like (0)

Report
Copy link

Link copied!

I've worked out that the MS Form isn't relevant to this query as it's only used outside of the App, the feedback process itself is available via multiple channels. - Please disregard that element.

The canvas app has a DataSource which is the MS List (SharePoint). Upon submission, the canvas app I've created writes a new entry to the SharePoint (MS) list.

Hope that's a little clearer? sorry for all the confusion!

Was this reply helpful? Yes No
Verified answer

ANTHR1CH 20 on at

Like (1)

Report
Copy link

Link copied!

I've resolved this myself by using powerautomate to send a notification via email to the user who created the new line item in the MS SharePoint list. Have taken the action away from the canvas app. Much easier.

Was this reply helpful? Yes No