Check new entry via Forms for duplicate value within an Excel table

(0) Share

Report

Posted on by OMcP

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!

All responses (2)

Answers (0)

CU10081315-1 on at

Like (0)

Report

Re: Check new entry via Forms for duplicate value within an Excel table

I'm having this same issue - any way you could do a screenshot of what the filter query would look like? I'm not sure I'm doing it right.
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: Check new entry via Forms for duplicate value within an Excel table

@OMcP you can use "List rows present in a table" action with one Filter Query based on one of your columns. Then you can use Filter Array action to further filter on other columns, the output of Filter Array will give you data whether the row with all matching data is returned or not