Hi all,
I am creating an Scheduled Cloud Flow that takes data from an Excel spreadsheet (which is populated by forms) and places the data in Lists. It should be a very simple flow but I cannot get my head around it.
Every time a form is completed the data gets put into Excel, each submission has a unique ID which is shown in the first column.
The flow is set to run every minute. The idea is to have the flow's 'Key Column' set to ID so that whenever that field is filled out the entire row is added to Lists. I am just not sure what to have 'Key Value' set to, I can set it to one single ID but it will only take that one entry, so how to I set it to all?
Any suggestions?