Hi all,
I am trying to return a value from my excel spreadsheet based on whether an entry in a seperate column contains certain text (text entered by the user so dynamic content)
My excel columns are set out as below:
I have a flow running to list rows in the table using a filter query to confirm whether the users entry exists. This element is working well. However when I come to get the information I cannot seem to find any way of getting a row out of the spreadsheet containing text in the key column.
My flow is below:
Can anybody help me to understand how to do this? Can provide more info if required.
