cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kzellenr
Level: Power Up

Using Flow to connect a form that updates an Excel spreadsheet?

This is probably a stupid question, but I'm struggling.

Basically I've created an inventory spreadsheet in Excel. Is there a way for me to connect several microsoft Forms to the spreadsheet, so that employees can simply access a form on our team site and add new items, which then adds a new line to the Excel inventory, and a different form to remove/add quantities of items?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Using Flow to connect a form that updates an Excel spreadsheet?

Hi @kzellenr .

The simple answer is yes, that is achievable. You may require multiple Flows or some logic to get the form submission to branch off to either create new or delete but I expect you would be able to create this.

 

Below is the trigger you would use and some of the actions too. This isn't a built Flow, just merely highlighting some of the key parts you would use to achieve this.Capture-557.png

I feel this process would be better suited to a SharePoint list, but if it is an excel spreadsheet you have then this is where I would start.

 

Please give it a try and if you get stuck, post back.

 

If you have found my post helpful, please mark thumbs up.

 

Any other questions, just ask.

 

Thanks, Alan

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

1 REPLY 1
Super User
Super User

Re: Using Flow to connect a form that updates an Excel spreadsheet?

Hi @kzellenr .

The simple answer is yes, that is achievable. You may require multiple Flows or some logic to get the form submission to branch off to either create new or delete but I expect you would be able to create this.

 

Below is the trigger you would use and some of the actions too. This isn't a built Flow, just merely highlighting some of the key parts you would use to achieve this.Capture-557.png

I feel this process would be better suited to a SharePoint list, but if it is an excel spreadsheet you have then this is where I would start.

 

Please give it a try and if you get stuck, post back.

 

If you have found my post helpful, please mark thumbs up.

 

Any other questions, just ask.

 

Thanks, Alan

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,218)