web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Flow with Forms

(0) ShareShare
ReportReport
Posted on by 34

Hi All,

 

I'm trying to intergrate flow and forms within my organisation. Here's the process which I'm trying to create.

 

1. Once a form gets submitted it will be sent to a user for approval

2. Once approved it will be sent to another user to perform an action

3. Once the action has been done it will then be sent back to a user to say it's done.

 

Any suggestions on how to best create this using forms, flow and maybe sharepoint?

 

Thanks,

 

I have the same question (0)
  • ScottShearer Profile Picture
    25,242 Most Valuable Professional on at
    Re: Flow with Forms

    @DomMB001 

    Your requirements can likely be easily met using Forms and Flow.

    Can you be a little more specific when you say "Once approved it will be sent to another user to perform an action"?  What action needs to be taken?  I will provie an example once I have tthat information.

  • DomMB001 Profile Picture
    34 on at
    Re: Flow with Forms

    Hi @ScottShearer 

     

    The action is to update a SQL table, essentially adding a new row to a table based on the details on the approved form.

     

    Thanks

  • ScottShearer Profile Picture
    25,242 Most Valuable Professional on at
    Re: Flow with Forms

    @DomMB001 

    Do you have a premium Flow license or are you using the Flow license that comes with Office 365?  I ask because using the SQL connector requires a premium license.

     

  • Verified answer
    ScottShearer Profile Picture
    25,242 Most Valuable Professional on at
    Re: Flow with Forms

    @DomMB001 

    Your Flow should look something like what I have below.  My form is for a leave request but it could be a request for anything that needs to be approved.  The SQL action is for an Insert Row.  Please note that using the SQL connector requires a premium Flow license.

     

    FormSql1.jpgFormSql2.jpg

     

     

  • DomMB001 Profile Picture
    34 on at
    Re: Flow with Forms

    @ScottShearer 

     

    My flow licence is the one that comes with office 365. Thanks for sharing this. I will most likely replace the SQL server flow with an approval flow to check if the SQL has been updated then it will be approved esentially.

     

    I will give this a go and if I have any problems I will feedback here.

     

    Thanks, 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 655 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 371 Moderator

#3
chiaraalina Profile Picture

chiaraalina 276

Last 30 days Overall leaderboard