Unanswered

PowerApps - Emailing Specific Patched Data from Gallery Grid

(0) Share

Report

Posted on by tko0215

I'm hoping someone can help me. So here is what I'm trying to do. Basically I created an app so field users can report a store closing. Anything that gets submitted would have a status "Closed". The information gets patched to a SharePoint list.

I then created an editable gallery grid in PowerApps (screenshot below). This screen will show all the field users store locations that are currently marked closed (from their previous submissions). The intent of this screen is for the user to go and find their stores that they submitted and mark them "Open" (Select Open from the drop down box) once they confirm the location has reopened. Once the user press submit, this will patch the updated store status on the SharePoint list.

So what I'm struggling with is how to notify select end-users that the user had indicated that a store "Opened". Currently, when the user press submit changes, an email would be sent to select end-users. It's just a generic email that tells that XXXX has updated the close store list. It also provides a link to the direct sharepoint list.

Since the SharePoint list can be rather big, is there a way where the user press submits and an email would be sent (to select users) containing the exact records (i.e store ID's) that were submitted as "Opened" and patched from the gallery grid? I'm sure there is a way. I just don't know how. Any help would be appreciated! thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Silvester. Akakpo 783 on at

Like (0)

Report
Copy link

Link copied!
Hi @tko0215 ,
On the submit button, you need to create a variable that can be used to reference all the attributes needed later in the mail (ie: Select user, ID, etc)
Set(VarStore, ThisItem);SendEmailV2( VarStore.SelectUser, "YourSubject", "Body", { VarStore.ID: } )
You can decide to do a deep linking to the record detail page if you want to using the VarRecord as Item(property) in an Edit form.

For deep linking, check this post Create a canvas app with deep link to a specific screen - Power Apps | Microsoft Docs

Kindly like this post if you find it interesting or better still accept it as a solution to help others find it

Was this reply helpful? Yes No
tko0215 35 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response. I think I get what you are saying but to be honest, I'm still very new with PowerApps. Is there perhaps an easier way to create an HTML table of any thing that the user selected and submitted "Opened"?
This is what I want to send once the user press submit changes. It should only show a list of locations that the user submitted as "Opened".

Was this reply helpful? Yes No