Hi, so I have Form that takes user input (some text entry, some dropdowns, some choices), as values to be appended to an excel sheet (called 'Mapping'). The flow then checks if a text entry exists within a separate excel sheet of valid ID's. If yes, an approval process is started which decides if the users submission is appended to the table in 'Mapping'.
I would like to insert a step before the approval process which checks if the users entry already exists, and if so cancels the flow. For an example:
The user submits the following (Blue, John Mayer, 7777, 9876, NY) The query finds that this exact combination of values already exists within 'Mapping', so the flow is cancelled.
But if the user submits (Blue, John Mayer, 7777, 1234, NY) then it goes ahead to the approval process, as the 4th value (9876 vs 1234) is different.
Any ideas? I used the Get a Row feature to validate my ID's, but cannot figure out how a way to do the same for multiple columns.
Thanks!
