2
Hello,
I'm trying to create an automation that goes as follow.
User answers a microsoft forms that have two parameters:
These answers are stored in One drive and can be opened in excel online.
What i want is to update another Excel (Notification excel) that is stored in my desktop with the Status of the answers made in forms.
How can i get this done?
Thank you,
I wouldn't link the two together. I would create a separate spreadsheet for what you want to do, but that is up to you. If you keep them separate, then the different structures make no difference.
Hi David,
Thanks for your time and help.
The thing is that the excel from forms has a different structure than the excel that i have to update. Is like the excel that i have to update have 14 columns and one ot this columns is the status. So i need to get the status from the forms excel put it in the excel that needs to be updated (the ID is the unic value that has to be used to do the matching).
The main problem that i have been facing so far is that i'm unable to update the forms excel that is stored in onedrive without opening it. So when a new answer is created in order to see all the answers i need to open the file in the cloud, wait a few seconds and then new answers appear. Once this is done, if i open the excel from desktop, all answears appear and updating the second excel is as easy as doing a VLOOKUP. Hope that i'm explaining myself in here.
Thanks a lot David.
What you want to do is quite simple. However, I would save the Excel file to your OneDrive as that will be much easier and you can add a shortcut to it on your desktop instead. Just use these three actions:
Before you begin, create your spreadsheet for storing the response details and format the spreadsheet with a table. After that, the rest is quite easy.
Share
Report
All responses (
Answers (
