Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 1puxrEsE+xm6GlWh1mmwDm
Power Automate - Building Flows
Unanswered

Creating an approval workflow for a refund request form

Like (0) ShareShare
ReportReport
Posted on 16 Jun 2024 12:25:10 by 8

Hi all,

 

I am new to using Power Automate and first time creating a Microsoft forms approval workflow. I have watched multiple youtube videos but can't seem to get the flow to work correctly!

If anyone can help guide me step by step to create the below - PLEASE DO!!

 

I have already created a refund request form via Microsoft forms - need this form to be sent to a single person for approval when submitted, I need the email that is being sent to the approver to include the same information that was submitted in the form so that the approver can review the information and determine whether it is approved or rejected.

Once she has approved or rejected and commented, i want the approvers response to be sent back to the requester advising of the decision.

I then want this information to be collated in an excel spreadsheet with the information that was submitted in the form and stating whether it was approved or rejected. Every time a new submission is sent I want a new line to be added in the same excel spreadsheet.

 

PLEASE HELP AND ADVISE STEP BY STEP ON HOW TO DO THIS!! I AM LOST!

  • Nived_Nambiar Profile Picture
    17,534 Super User 2025 Season 1 on 17 Jun 2024 at 04:44:54
    Re: Creating an approval workflow for a refund request form

    Hi @FR01 

     

    As @Anil_g  said- refer this once again 

    https://techcommunity.microsoft.com/t5/excel/getting-this-message-quot-this-won-t-work-because-it-would-move/m-p/309739

    if still not resolving the issue - just delete the excel file - recreate the file again and the table with headers as well and update the flow to include the new file details in add row to table and see whether that helps !

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • FR01 Profile Picture
    8 on 17 Jun 2024 at 04:38:07
    Re: Creating an approval workflow for a refund request form

    I have created another table to ensure there is no data filled below the table, i have also removed all filters and i have ensured the table is formatted to contain the answers from the form - it is still no working and giving me the same error

  • Nived_Nambiar Profile Picture
    17,534 Super User 2025 Season 1 on 17 Jun 2024 at 04:33:54
    Re: Creating an approval workflow for a refund request form

    Hi @Anil_g 

     

    Thanks for providing the answer- i got mislead by the message shown in right side of flow designer

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • Anil_g Profile Picture
    668 Super User 2025 Season 1 on 17 Jun 2024 at 04:05:23
    Re: Creating an approval workflow for a refund request form

    @FR01 

     

    Few causes ofthe issue

     

    1. is there any table below it or any data filled below the table? If yes please move to a different sheet

    2. are there any filters applied on the table..if so remove them

    3. Or is the table formatted to to contain more columns than you are providing?

     

    correcting the above should fix the issue

     

    cheers

  • FR01 Profile Picture
    8 on 17 Jun 2024 at 03:51:48
    Re: Creating an approval workflow for a refund request form

    Ok - that worked, now i am getting the below error!

    FR01_0-1718596281604.png

     

    FR01_1-1718596289927.png

    FR01_2-1718596297072.png

     

  • Nived_Nambiar Profile Picture
    17,534 Super User 2025 Season 1 on 17 Jun 2024 at 03:24:34
    Re: Creating an approval workflow for a refund request form

    Hi @FR01 

     

    This happens because the email address you have provided is Anonymous- which is invalid email address. I assume that form is used outside organization as well - like anyone can submit correct ?

     

    if yes, then it would show responder email address as anonymous all time even a signed in user has also submitted. If you want only users in your organization submit the form response, then under form settings set the highlighted option

    Nived_Nambiar_0-1718594572087.png

     

    In your form it may be different environment name than MFST which is default environment for my case. So selecting that option makes the form available to users in your organization.

     

    Else if you want to make the form available to external users as well- add a field in form to make user enter their email address so that we can use that value to send email after approval.

     

    Hope it helps !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

     

  • FR01 Profile Picture
    8 on 17 Jun 2024 at 03:10:20
    Re: Creating an approval workflow for a refund request form

    Thank you so much for this! so I have completed all your steps and got the below error?

     

    I am not sure what i have done wrong?

     

    FR01_0-1718593809460.png

     

  • Nived_Nambiar Profile Picture
    17,534 Super User 2025 Season 1 on 16 Jun 2024 at 13:15:55
    Re: Creating an approval workflow for a refund request form

    Hi @FR01 

     

    Let me provide a demo flow design which can help designing in actual flow. Note that certain fields may be different from what you need in actual, so you have to adjust in your flow accordingly.

     

    For the demo flow design- following resources has been used

    1. A form for this was created.

    Nived_Nambiar_0-1718542809908.png

     

    Note that- based on your requirement- it may change accordingly.

     

    2. Excel file - to store response details

    Nived_Nambiar_1-1718542854146.png

     

    Here i have included information from forms - description & refund amount and finally approval status. The excel data should be wrapped in a table.

     

    Flow Design

     

    1. Use trigger when new response is submitted to trigger the process when form is submitted.
      Nived_Nambiar_2-1718542973572.png

       

    2. Use get response details to get details of responses submitted by user
      Nived_Nambiar_3-1718543013914.png

       

    3. Use Start and wait for approval action to create an approval action by assigning to a user and waiting for their response
      Nived_Nambiar_4-1718543143425.png

      Here we need to provide which approval - here i have selected anyone- approve- it means anyone should approve out of given approvers. Also provide a Title for the approval. In Assigned To field, provide the email id of person to which you need to assign the task to get approved.

    4. Now once the approval action is submitted by user- check whether the approval action is either approve or reject, so to send mail to respective user regarding the approval status of the request.
      Nived_Nambiar_5-1718543454233.png

      If condition is true (if outcome is approve), then send mail stating approved 

      Nived_Nambiar_6-1718543507260.png


      if not approved, send a email like this

      Nived_Nambiar_7-1718543549295.png

       

    5. After the condition - use add row to table to add the form details along with approval outcome to table in excel.
      Nived_Nambiar_8-1718543632137.png

       

      Nived_Nambiar_9-1718543656850.png


      Here in this action, you have to select the excel file path and the table where data needs to be add to.

    Overall flow design looks like this

    Nived_Nambiar_10-1718543750190.png

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • Anil_g Profile Picture
    668 Super User 2025 Season 1 on 16 Jun 2024 at 13:14:28
    Re: Creating an approval workflow for a refund request form

    @FR01 

    This is how the flow looks

     

    Anil_g_0-1718543576068.png

     

    1. When a form is submitted

    2. Start and wait for approval - in this you can fill what all you want and who to send etc ..the data from step 1 can be used usign dynamic content options

    3. Send email - So after approved or rejected the information can be mailed

    4. Add row to table - this will add data to excel as you need

     

    Hope this helps

     

    cheers

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard