Answered

Update Excel Cell Based Off Answer From Microsoft Forms Question

(2) Share

Report

Posted on by VG-30071533-0

I am building a time off request tool. Every aspect of it works great except for one part.

I use an excel table that keeps track of all the requests sent, how many hours the requestor is asking for and what kind of request. All of this ties into another excel sheet that keeps track of how many hours the requestor has left for the year. The problem I am running into is the excel cell is not updating with the requested hours or will update all columns with the same value. The bottom row shows that 8 hours were put in for all 3 time off types.

This is my current flow to update the row. It adds the row successfully every time but it doesn't update the correct cell. I know I have "Hours" in all 3 categories but it's the only way I can get it to update the columns at all. Otherwise it won't put any hours in.

Categories:

Business Process Flows

All responses (4)

Answers (0)

VG-30071533-0 10 on at

Like (2)

Report

Update Excel Cell Based Off Answer From Microsoft Forms Question

The switch was the fix! It's now fully functional. Thank you for the assistance!
Suggested answer

AnthonyAmador 2,553 Super User 2025 Season 1 on at

Like (2)

Report

Update Excel Cell Based Off Answer From Microsoft Forms Question

Thanks for the clarification.

You need to create the logic, the automation will not know how to automatically which value enter or not in the excel row, for that you can use a Switch action in the flow.

With the Switch action you can create three different cases based on the option selected from the form. If they select Vacation, only keep the action ‘Update a Row’ with the ‘Hours’ in the Vacation column. Do the same for Personal and Comp.

Let me know if that helps.

Anthony.
VG-30071533-0 10 on at

Like (1)

Report

Update Excel Cell Based Off Answer From Microsoft Forms Question

I did change the key value to be the requestors name. But its still dumping the requested hours into all 3 columns. For example, someone submits a vacation request for 8 hours. I want the "vacation" column to update in the row of the employee's entry into the table. If that makes sense. The information comes from a microsoft form that the employees submit. The form has 3 options to select from - vacation, personal and comp. Then they enter how many hours they are requesting. I need those hours to be input into the corresponding cell.
Suggested answer

AnthonyAmador 2,553 Super User 2025 Season 1 on at

Like (1)

Report

Update Excel Cell Based Off Answer From Microsoft Forms Question

Hi,

I believe your problem might be using “Hours” as the Key Value. If you want to update a row in the Excel table, you should enter the Key Column and Key Value to identify the specific row.

You need to find another way to update the correct row using a different Key Value, such as the name of the user.

Hope this helps.

Anthony.

If my reply answers your question, please like and mark it as verified. This helps me stay motivated to assist others and makes it easier for users with similar questions to find the answer. Thanks!

Connect with me on LinkedIn