cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ClarkyPA365
Post Patron
Post Patron

Sending email in PowerApps. Multiple Emails Received

Hi,

I'm trying to send an e-mail form Powerapps when a form has been completed to let another team they have to carry out further actions.
When I've created the flow it seems to send an email for all the records that are in the Sharepoint list and not for that individual form?

ClarkyPA365_0-1643190527176.jpeg

 

ClarkyPA365_1-1643190556672.jpeg

 

ClarkyPA365_2-1643190589802.jpeg


Any ideas??

Regards

 

Chris

 

4 REPLIES 4
Mister_Shaik
Solution Sage
Solution Sage

Hi @ClarkyPA365 ,

 

You have used Get Items action - this will fetch all the SharePoint items in the list. You need to use Get Item action instead and pass the ID of item that you created in PowerApps.

 

Also what I'm assuming if that you're planning to send out an email after submission of form, correct?

 

Then why don't you use a Office 365 Outlook connector in PowerApps and send email in the Power App formula itself?

Mister_Shaik_0-1643310046878.png

And replace your formula for button submit to this, for sending email,

SubmitForm(NewReq_Frm); Reset(NewReq_Frm);
Office365Outlook.SendEmailV2("ChristopherClark@xyz.com","Subject Line","Staff Member: " & StaffMember.Text & " - ID: " & NewReq_Frm.LastSubmit.ID)

 

Doc on Send Email action:- https://docs.microsoft.com/en-us/connectors/office365/#send-an-email-(v2) 

Doc on Get Items action:- https://docs.microsoft.com/en-us/connectors/sharepointonline/#get-items 

 

Hope you find this helpful! 🙂

 

Kind Regards,

Shaik Sha
________________________________________________________________________

If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Hi Shaik,

Thank you for your reply.
I realised I had used the wrong 'Get' action and resolved that part. 😄
You are quiet correct that I will be requiring to send an email after the submission form but this needs to go back to the person who submitted the  form in the first place.  Also I don't want my email address to appear but a mailbox email where the original submission form is sent to..

An additional issues that I will come across is there is a need for a repeating form so a number of submissions can be sent with one selection of the submit button.  So a response email will need to provide details of those records that have been actioned.  Hope that makes sense??

Any ideas will be gratefully received

 

Regards

Chris  

Hi @ClarkyPA365 ,

 

If you're planning to have multiple submissions, assuming each submission is a List item, it would be best to go for a Gallery with input controls rather than a single form.

 

You can use a collection to store the inputs from the user and when he hits the submit button, you can use a Patch function with ForAll and create records in your list. In the same ForAll loop, you can collect the IDs of submitted records and save them as string, which you can use again after submissions to send out the email.

 

Regards,

Shaik Sha

ClarkyPA365
Post Patron
Post Patron

Hi Shaik,

Thanks for the advise.  
I'll try and create the submission 'Gallery' form with collection and patch. 
May need some more information a round the sending of emails as still unsure of this 

Regards

Chris

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,915)