cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akondoctmx
Regular Visitor

Popup to Confirm Sharepoint List Form Content Upon Clicking Save

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

9 REPLIES 9
KrishnaV
Super User III
Super User III

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.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.
WarrenBelz
Super User III
Super User III

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.

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.

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
Super User III
Super User III

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?

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

akondoctmx_0-1618183928093.png

 

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.

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 FlowPower 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']"
}

 

 

Hi @akondoctmx ,

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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (35,806)