Answered

Detect if a user has submitted a form already

(0) Share

Report

Posted on by julienvdc

203

Hey I have this Form where users are submitting access requests. It often happens that users have already made such request in the past (but forgot about it).

I am thus looking for a way to detect whether a user have submitted a form in the past, and send them an email with more info if they did.

The form results are save in an online excel sheet, and one of the questions is collecting the user's email address. I was thus thinking that there could be a flow that would check the excel sheet for a user's email address to see if it was already shared in a previous form... but I can't find the proper way to set this up...

Any suggestions?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

v-yetonggu-msft on at

Like (1)

Report
Hi @julienvdc ,
I did a test for your reference.
In my scenario:
length(outputs('List_rows_present_in_a_table')?['body/value'])
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,690 Moderator on at

Like (1)

Report

Sure.

You'll need to take these steps:

1) When a new form response is received...

2) Get response details

3) List rows present in table -- but you'll use the Filter Query option to find where Submitted (whatever the name of the column is in your Excel sheet that holds the submitted's email address -- has to be a column name with no spaces) eq 'xxxx' (where xxxx is the email coming from the current response.)

4) Now you can use a condition. If the output from the previous (step 3) has a length() of 0 (use the expression field, type in length(), click between the {s and then click dynamic content and point it at the output from the List Rows Present in Table action), then it means there was no match. If it's more than one, then there was a match.

5) On the "Yes" side, it means it's a new submission by someone who hasnt submitted before. If it's on the "No" side, then there is a previous submission, and you can send the "info" email in that branch. You can also access the output from the List Rows Present in Table if you want to show them what they've submitted before.

Was this reply helpful? Yes No