Popup to Confirm Sharepoint List Form Content Upon Clicking Save

[akondoctmx]

Hello,

I have a Sharepoint List Form setup with Power Automate to trigger emails upon saving the form.  What I would like to include is a confirmatory step between the time the user clicks 'Save' on the Sharepoint List Form (this creates a new item in the list) and the Power Automate initiating its flow to send out the emails.  This confirmatory step can be a pop-up including the entries for each field of the form with option for the user to decide to cancel the save (i.e. clears the SP list form) or proceed with the save (i.e. proceeds with initiating the power automate flow). 

Current Workflow Setup: the workflow is currently setup around 3 Sharepoint List and I have Power Automate setup to distribute emails and record these in a list for the users (i.e. they need this for auditing purpose)

1. Sharepoint List 1 is a Distribution Contact List which is managed by a group of users. 
2. Sharepoint List 2 is "email package" list which essentially asks the user (i.e. email sender) to provide the subject line and attachments to include in the email. 
3. As soon as a new entry is created by completing the List 2's form, this triggers the power automate flow is triggered to look at all the contacts in List 1 and send the email package from List 2 to each one on that list
4. Each of the emails sent by the Power Automate flow in step 3 is recorded in Sharepoint List 3 as Distribution Tracking

Everything is working with the exception that it's missing that confirmatory step.  That is, if the user Saves the email package form on Step 2 by mistake, then it shoots the email to everyone in the contact list on List 1.  I'm not married to the idea of a pop-up so if there's another easier way to accomplish this confirmatory step, I would be grateful for your suggestion.  I must admit that I'm not very versed with Power Apps aside from customizing the SP List form, but willing to explore moving the workflow and rebuilding it in Power Apps if that's the better/easier route to go. 

Thank you so much for taking the time to read and propose.

Al

[KrishnaV]

Hi @akondoctmx ,

I don't see a need to use the Power Automate to save the list item, you can save the list item from Power App directly, and also you can send the email without any difficulty.

Since we can do both the steps from here we can show the popup as requested by the user and get the user confirmation before you save the date. This way you can avoid saving the data option before user confirmation.

[WarrenBelz]

Hi @akondoctmx ,

A pop-up or simply a confirmation button becoming visible on the screen is the best way to put a "break" in the process. On either, you simply set a Variable to true and set the Visible of the item to this. If a simple button, the details of the entry would be visible (or a pop-up that does not cover them).

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.

[akondoctmx]

Thank you @KrishnaV for taking the time.  I realized that I should have provided a better description of the current scenario/setup.  I updated my post above.  Any additional advise (or guidance/references on how to do it in Power Apps if that's the route to go) would be much appreciated.

[akondoctmx]

Thank you @WarrenBelz  for taking the time.  I realized that I should have provided a better description of the current scenario/setup.  I updated my post above.  Any additional advise (or guidance/references on how to do it in Power Apps if that's the route to go) would be much appreciated.

[WarrenBelz]

Hi @akondoctmx ,

This is more a workflow issue rather than a coding exercise - the key is this statement

As soon as a new entry is created by completing the List 2's form, this triggers the power automate flow 

Is this on the OnSuccess of the form or on another trigger/action?

[akondoctmx]

I'm not sure.  I'm using the default form that comes with the Sharepoint List, and the 'Save' button on it.

[WarrenBelz]

Thanks @akondoctmx ,

But the Flow has to be triggered by something - have you used the OnSave in SharePointIntegration? We have to know as this is the place you would need to intervene and supply the confirmation action.

[akondoctmx]

I'm not sure where I could get that info.  Would I need to turn the default form into Power App version first?  Below is the the Power Automate flow, it starts as a new item is created in the List (i.e. the one where the default form is linked to)

Power Automate Flow

When I peek into the code, I see the following:

{
    "inputs": {
        "host": {
            "connectionName": "shared_sharepointonline",
            "operationId": "GetOnNewItems",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
        },
        "parameters": {
            "dataset": "https://highlinesciencescom.sharepoint.com/sites/EmailPackageList",
            "table": "0aaa0a00-a0aa-00aa-00aa-0a0000a00a00"
        },
        "authentication": "@parameters('$authentication')"
    },
    "recurrence": {
        "interval": 5,
        "frequency": "Minute"
    },
    "splitOn": "@triggerOutputs()?['body/value']"
}

[WarrenBelz]

Hi @akondoctmx ,

This is nothing to do with the Flow content, but rather how it is triggered. How is this done?