Unanswered

Click Button to Send Email Button Trigger in Power Automate (PowerApps / Sharepoint Integration)

(0) Share

Report

Posted on by Gina-PowerApps

Hi there,

Wondering if anyone can help please. We have build a Sharepoint customised form and have included a button to trigger sending an email. I have tried to scour the web but they all seem to have older versions of PowerApps so I can't get my head around it.

What is the best way to build this please?

- We have a SP list form where people will enter an interview appointment date, time, location, and person conducting the interview and we want them to be able to click the button to send an email (HTML template preferably) confirming the details of the interview.

- Within the PowerApp, I've built a flow (called SendSecurityInterviewEmail) that picks up that information from the SP list, I'm not sure if maybe that should be picking it up from the PowerApp directly instead.

- I cannot figure out what to put on the OnSelect trigger for the button. I tried SendSecurityInterviewEmail.Run() but it needs parameters and I'm not sure which ones to use.

These are the form fields and the button.

FormFields - Button in PowerApp.png

The Power Automate in app

PowerAutomate in App.png

The flow -

SendSecurityInterview Email Flow Part 1.png

SendSecurityInterview Email Flow Part 2.png

Sorry this is either really simple and I'm missing every basic instruction so I've done it completely wrong, or I've over complicated it!

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

AndrewR1 1,572 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Gina-PowerApps , you could when the item is created get the ID of the Item and then pass this as a parameter to your flow which you can then use to get the record form SharePoint. Or you could alternatively change up the way the flow is triggered, and have it when a new item is created to the SharePoint list it will then trigger the flow to send out the email.

Option One Screenshots:

You would firstly in your power app you’re your last submitted form value to get the ID of the SP Item and then pass this in you FlowName.Run(SharePointIDValue):

Option 2 screenshots:

You would then after both of these populated your send email action.

Hope this helps

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

Was this reply helpful? Yes No
Gina-PowerApps 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Andrew, thanks for getting back to me. It's likely that this tracker will get regularly updated before it gets to the stage of booking an interview, so I think the second option will work for just triggering when a change has been made to the ID.

I was really hoping that I could use the button to be a trigger but is that not really possible in this case?

Thanks
Gina

Was this reply helpful? Yes No