Answered

Power Apps button sending emails to the people in sharepoint list

(0) Share

Report

Posted on by ST-19121058-0

Hi All,

I have a SharePoint list to record a Power Apps Form, which includes a Power Automate flow to send an email to the user name that has created the form and their manager, when clicking on a button on that form. When the user clicks on the button it triggers an email to all the users that have created forms in that list and not only to him and his manager. How can I fix this?

Thank you 🙂

here are some screenshots:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@SoniaTorres that because the flow Action you are using "Get Items" gets All items.

I would suggest you build a flow with the trigger "When an item is created". This Kind of flow will run automatically when a new item is created in your sharepoint list.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ST-19121058-0 9 on at

Like (0)

Report

Thanks for your reply Powerange.

I have added a button at the bottom of the form for the user to click and send an email when the form is completed, don't want to get the email issued when the form is created but when is completed and the user click on that button. Any other way to get the flow trigger when they click that button and only for their forms and not for all the forms saved in the SP list? Thank you, Sonia.

Was this reply helpful? Yes No
Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (1)

Report

@SoniaTorres I still would recommend to only use PowerAutomate. Use a Trigger of type "When an item is created or modified"

When do you consider its complete? Because this will be required to be placed in the Trigger Condition Section.

Ofcourse you could use a Button and Call a flow. In that Case you need to pass a Parameter (The Item ID) to your flow.

Therefore you need to use the "Get Item" Action instead "Get Items". In "Get Item" you will be asked to provide a ID. Click in that field and in your dynamic content pane Look for "Ask in powerapps.

In Powerapps you need to slightly change the your flow.Run() function. It should Look similiar to

Yourflowname.Run(SharePointIntegration.SelectedId)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ST-19121058-0 9 on at

Like (0)

Report

Thank you very much PowerRanger, your suggestions showed me the way to get it fixed.

I used the "Get Item" instead of "Get Items", as ID I called to "Ask Powerapps", for this to work you need to have the Form ID field into the Powerapps form as a card.

On the button, I used a kind of the formula you suggested Yourflowname.Run(ThisItem.ID)

Now it only sends the email related to that ID form, and not to all the forms in the SharePoint list 🙂

Was this reply helpful? Yes No