Duplicate response filtration and email alerts

[Anonymous]

I Have created a flow where it collects the response from MS forms and collate in a excel file in my one drive and also filters the date and send me an email alert on a conditions hence I also wants to build the same for duplicate responses filled, I need to get an alert for every duplicate response filled and unique identifier is customer number in the forms filed, can anyone help with the same, I am attaching the current flow as explained above   

[Nived_Nambiar]

Hi @Anonymous 

do you want to send email after entering the details to excel or before entering that details to excel ?

[Anonymous]

@Nived_Nambiar 

before or After adding to the excel, both works for me

[Nived_Nambiar]

Hi @Anonymous 

Assume the two things 

1. I am having column name CustomerNo in the excel which stores Customer Number

2.  the MS form look like this 

Now use the flow design like this 

we will filter the rows in excel based on column customer number 

the output of the list rows action would be having filtered rows which would be having rows with column with customer number.

Now use condition to check whether there is any output from list rows like below

length(outputs('List_rows_present_in_a_table')?['body/value']) 

Now if it is true, in yes branch > send an email 

Hope it helps !

[Anonymous]

Hi @Nived_Nambiar thanks for your help, I am trying to add this to my existing flow somehow its not working, do I need to add the it as a parallel action or after the add row into table action ?, because I have already added a flow where its collates the response and if a response filled the by selected other dates except different date then it send an email alert, in which step I need to add this, sorry I am completely new and will take some time to understand and wanna build it in one flow  

[Anonymous]

@Nived_Nambiar 

While creating a new flow also getting the error as shown in the snap.

[Nived_Nambiar]

Hi @Anonymous 

In that case, you can start from get response details part 

Also for your second question when you are creating a new flow, 

could you show what you are placing in filter query of list rows in table ?

[Anonymous]

Hi @Nived_Nambiar 

Below is the snap,

[Anonymous]

Hi @Nived_Nambiar  

Below is the error I am getting.

[Anonymous]

Can someone help on the above issue please 

[Nived_Nambiar]

Hi @Anonymous 

The filter query you have provided is of wrong syntax, 

kindly see below for correct format

You have to put single quotes while specifying the value by which you need to filter

Hope it helps !