How to Use a Group Form in Power Automate

Do you want to use a group form in your Power Automate flow?

Unfortunately, any group forms you create will not show up in the Form connector in Power Automate.

But you can still use a group form in your flows with the form ID.

This post is going to show you how to use find and use the group form ID to create flows based on group forms.

What is a Group Form?

creating a Group Form allows all the members of the group to view and edit the form.

This can be a better way to manage an important form rather than creating a personal form and sharing it with others.

How to Create a Group Form

Here’s how you can easily create a group form.

  1. Go to the forms.microsoft.com homepage while logged in to your Microsoft account.
  2. Scroll to the bottom where all the groups you have access to will be listed in the My groups section.
  3. Click on any group to make a form for that group.

Notice that each group shows the total count of forms for that group.

This will take you to a list of all the forms for that group.

At the top, you will see a button that allows you to create a new form.

  1. Click the New Group Form button to create a form for the group.

You can then build out your form and the next time you visit the Group forms page from the My groups section, it will be listed.

  • Click on your form from the Group form page.

Group Form Doesn’t Show in Power Automate

Creating a group form is easy enough, but using it in your Power Automate Forms connector is much more difficult.

When you try to select the group form in the Forms connector, you will not be able to find it.

Unfortunately, this is a long standing bug in the connector.

Get a Group Form ID

You will be able to use a group form in your flow if you know the group form ID.

When you click on the group form from the Group form page, the URL will contain the form ID.

Everything after the &id= in the URL will be the group form id! Copy this into your clipboard so you can use in the flow.

Use a Group Form in Power Automate

Now that you have the group form ID, you can use it in the flow.

  1. Add either the When a new response is submitted trigger or the Get response details action from the Forms connector. Either of these allows you to enter the group form ID.
  2. Click on the dropdown of the Form Id field.
  3. Click on the Enter custom value option at the bottom of the dropdown list. This will allow you to enter a custom text value.
  4. Paste in the group form ID.

The flow will now work for your group form!

Conclusions

Group forms are essential when you want your team to have full access to a form.

Unfortunately, group forms don’t appear to work with Power Automate due to a bug in the Forms connector.

Thankfully, you can bypass this bug if you use the group form ID as a custom value in the Forms actions.

Have you come across this problem with group forms? Let me know in the comments!

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Related Articles

Comments

11 Comments

  1. Anna Zheleznyak

    Hello John,
    I read your suggestion on how to use group form in power automate. This is exactly what I need to do. I used the form id in the flow, starting with @id=.
    The problem is I cannot get dynamic content , which are responses from the form fields.

    Could you perhaps help in this area?

    • John MacDougall

      Did you include @id=? Don’t include it.

  2. Riëtte Fourie

    Same problem as Anna Zheleznyak above. I have a form assigned to a public Teams Group, but cannot get dynamic content (responses from the form fields). I pasted the correct ID – everything after the @id= Ending with ….Wcu.

    • John MacDougall

      To use dynamic content, you will first need to use the Parse JSON action with the response body.

    • Jay B

      It’s actually easy, the example above is missing some steps.
      1. Create the “When a new response is submitted” and paste in the Form ID
      2. Add a Forms step of “Get response Details” and also paste in the Form ID
      3. Add a “Send an email notification (V3)” and then select each of the fields you want to include under Dynamic content, and there is a list of each of the response details.

  3. Georgia Triffitt-Harwood

    I have a form created that is owned by a group, trying to link this and have done the id but can’t link through the actual questions as others mentioned above. You have advised to use the Parse JSON action but I can’t figure out how to use that to get the answers to link to the questions, can you help?

    • John MacDougall

      Follow these steps.

      1. Run the flow once to get an example body from the trigger. Copy this to your clipboard.
      2. Add the Parse JSON action to your flow.
      3. Click on the generate from sample button.
      4. Paste in your example from step 1.
      5. Click the Done button.

      Check out this post about allowing null values in JSON schema for more details.

  4. naufal

    thanks for the tips. i’ve been struggling with adding row from every section of the form.
    how can we create connection new row in excel for every section of the form.

    • John MacDougall

      You would need to use an use an add row action for each section.

  5. KTay

    Is it possible to turn responses from group forms into individual PDF files that are stored in a sharepoint teams site?

    • John MacDougall

      Yes, you could use the Word connector for this or another 3rd party PDF action.

      You can also try the OneDrive connector, but it requires creating an HTML file and is much harder to get it looking nice.

Get the Latest Tech Tips

Write For Us

Are you a tech enthusiast with a talent for writing great content? Come write for us!

Follow Us

Follow us on social media to stay up to date with the latest in tech!