Hi Brilliant Minds,
I was hoping some-one can advise or point me to a relevant post.
I am using a Custom connector to query data from a REST API. I managed to get all my data into an Excel table hosted on OneDrive.
I now need to use all the data in Column A as variables in a different query to get more data for each column.
Does anyone know how I can use all the rows in "column A" on my table as variable to pass into a query?