How to check if an email exists in a variable?

(0) Share

Report

Posted on by ramzez

312

Hello,

I'm trying the get the latest record from each user made in the past 12 hours.

The List rows works because I get all the records made in the past 12 hours.

How do save into the variable only the latest ones from each user based on email address? My condition at the moment does not work, because all the List rows records end up in the variable regardless there being duplicate email addresses.

What am I doing wrong?

Categories:

Building flows

Screenshot 2023-1...

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Below is likely how I would build the flow.

See full flow below. I'll go into each of the actions.

List rows is what you currently have.

Select extracts out your email addresses. For this example, I've just use the Created By (Value) field.

Initiate variable is the same as what you have.

Apply to each uses the following expression to iterate over each of the unique users.

union(body('Select'), body('Select'))

Filter array filters out the records where the user is equal to the current user we are iterating over.

Append to array variable appends the first record returned to our array. It uses the following expression.

first(body('Filter_array'))

Was this reply helpful? Yes No
ramzez 312 on at

Like (0)

Report

It worked, thank you!

Was this reply helpful? Yes No
CU22101546-0 4 on at

Like (0)

Report

If you want to check if an email exists in a variable, you can take a pretty simple approach. First, you can validate the email format using a regular expression (regex) to ensure it looks like a valid email address. But if you're trying to find out if the email exists (like if it’s real and not fake), that’s a bit trickier.

Was this reply helpful? Yes No