Power Platform Community Forum Thread Details

I am basically new with Power Automate and I am trying to create a workflow where staff members can submit a Microsoft Form requesting items and these items will be reduced automatically from our inventory list.

1- My Microsoft Form includes:

Staff Name
Location Name (Site for where supplies are being requested.
Supplies List
Quantity needed
Now, if more supplies are needed within the request, I was able to branch a question that say: Need more supplies? If yes, then they will be taken to a next page where they will basically complete all same questions, they can do this up to 20 times. If not, then, they will just submit the form.

2- Once the form is submitted, I want for them to receive an email with the confirmation that the request was received and is waiting for approval/rejection. With Power Automate, I was able to complete this step.

3- I want that these requests are reduced directly from our Inventory Spreadsheet, which I made sure that items do not have the same name. But every time I get to this step, the spreadsheet does not update.

What are some suggestions? Is there an easier way to get this to work?

Categories:

Building flows

You will need to do a couple of things in order to provide assistance:

Show a flow run that shows the run went down the True side of the condition.
1. If you cannot find any, then there is an issue with your condition.
2. You will need to show the configuration of the condition in that case,
Show the configuration of the Update a row action.

It's funny, you are setting up something which I recently just automated. However, I don't like working with Excel spreadsheets because of some issues you can have with this. I converted the Excel spreadsheet to a SharePoint list to avoid some of the issues you can have, and the process owner now actually prefer working with the SharePoint list since every row gets treated as its own record in SharePoint and you don't need to worry about Excel file locks when multiple people are editing the list at the same time.