Using Microsoft Forms to update weekly excel table via power automate flow.

[hpope]

Hello, I have created an excel worksheet that requires weekly updating. The flow is created to gather responses from a msft form and fill the responses in to the appropriate cell in the table. The issue is that the I'm thinking I need a formula that will recognize what data needs to be placed in the weekly cell. So ideally, a user will submit a form, selecting what week they are updating, their dept, and then filling in the needed info under their dept in the form. Once the form is submitted, I would need the power flow to recognize that what dept the user is updating for and the week and fill in the info that was submitted for that week, in the listed cells. I hope, I'm explaining this correctly. I will include screenshots for reference. Any help is greatly appreciated!

[SudeepGhatakNZ]

@hpope ,

Is there a reason you are using an Excel sheet and not a SharePoint list?

This would be easier to achieve via a SP list.

[hpope]

@SudeepGhatakNZ 

It was requested for the data to be inputted in an excel spreadsheet. Would it be easier to have the data go through SharePoint, then to Excel?

[SudeepGhatakNZ]

Give me a couple of days. I will send you a sample.

[hpope]

Hello,

So, I changed the table around to see if that would make the flow easier. Based on asking the new design power automate how to update an excel table weekly with form submissions, this is the flow that was provided, however it still doesnt work.

Thank You for checking into this!

 

[creativeopinion]

@hpope The For each action isn't required in your case. I'm assuming you started editing your flow in the New Designer and switched over to the Classic Designer. The New Designer still has a few bugs and it does have known issues when working with the MS Form trigger and action—at least from my experience.

You should pull the Get response details action outside of the For Each action. In the Response Id field, you need to insert the Response ID dynamic content from the flow trigger.

You might find these YT Tutorials helpful: 

How to Get Microsoft Form File Uploads Attached to an Email 📧

In this Microsoft Power Automate tutorial, I’ll show you how to get your Microsoft Form responses into SharePoint. I’ll cover how to build a Microsoft form with conditional fields by using branching. You’ll learn how to format your multiple choice responses for a SharePoint multi-choice column as well as converting it to text. I’ll also show you how to take a text response and convert it to a number with a switch action and with an expression. After adding the response to SharePoint, we’ll send the user an email confirmation with all the details of their form submission.

I also cover the following in the tutorial above:

✅ Two types of MS Forms

✅ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

✅ Where Microsoft Group Form File Uploads are Saved

✅ How to Add a File Upload Question to an MS Form

✅ How to get a Microsoft Form ID

✅ How to get a Microsoft Form Response

✅ How to Get the Dynamic Content Microsoft Form File Upload Content

✅ How to handle Single and Multiple Microsoft Form File Uploads

✅ How to use a Scope action to Organize and Group Your Flow Actions

✅ How to Get the File Content from an MS Form File Upload

✅ How to Collect All Files Uploaded to a MS Form and Attach to an Email

✅ How to Handle MS Form Response When a File Isn’t Uploaded

✅ How to Create an Email Key

✅ How to Send an Email to a Specific Recipient Based on Form Selection

✅ How to Create a Dynamic Output Based on Form Selection

--

How to Get Microsoft Form File Uploads Attached to an Email 📧

In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.

IN THIS VIDEO:

‌✅‌ Two types of MS Forms

‌✅‌ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

‌✅‌ Where Microsoft Group Form File Uploads are Saved

‌✅‌ How to Add a File Upload Question to an MS Form

‌✅‌ How to get a Microsoft Form ID

‌✅‌ How to get a Microsoft Form Response

‌✅‌ How to Get the Dynamic Content Microsoft Form File Upload Content

‌✅‌ How to handle Single and Multiple Microsoft Form File Uploads

‌✅‌ How to use a Scope action to Organize and Group Your Flow Actions

‌✅‌ How to Get the File Content from an MS Form File Upload

‌✅‌ How to Collect All Files Uploaded to a MS Form and Attach to an Email

‌✅‌ How to Handle MS Form Response When a File Isn’t Uploaded

‌✅‌ How to Create an Email Key

‌✅‌ How to Send an Email to a Specific Recipient Based on Form Selection

‌✅‌ How to Create a Dynamic Output Based on Form Selection

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[SudeepGhatakNZ]

Here is the screenshot

The flow is attached as well.

[hpope]

Hello,

Thank You for the update and flow. I am having an issue with importing the flow to be able to see the details. I keep on getting the error below.

[SudeepGhatakNZ]

Can you follow the screenshots instead?