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:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

AnthonyAmador 2,553 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
VG-30071533-0 10 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

AnthonyAmador 2,553 Moderator on at

Like (2)

Report

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.

Was this reply helpful? Yes No
VG-30071533-0 10 on at

Like (2)

Report

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

Was this reply helpful? Yes No