check if an email exists in a collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

This is complicated since I only need the emails of a respective ID

I will give you the example

I make a filter that returns several emails (I need it)

Filter (
"Training of participants",
IdTraining = Value (lblIdTraining.Text)
).Mail

this returns me

exaplemail1@mail.com
exaplemail2@mail.com
exaplemail3@mail.com

so I have a screen in powerapps where I manually register people in a collection

Collect (
List,
{
QR Name: DataManual.name,
EmailQR: DataManual.mail,
PositionQR: DataManual.position,
DepartmentQR: DataManual.department,
AreaQR: DataManual.area
}
)

the name, email, position, department and area are stored in the collection

Now I want to know if there is an email from those I brought in the previous filter in collection

i'm dealing with

Filter (
"Training of participants",
IdTraining = Value (lblIdTraining.Text)
).Mail in List.EmailQR

it gives me the error

cannot use table values in this context

I guess it's because they are a set of elements.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Try this:
IsBlank(Filter("Training of participants", IdTraining = Value(lblIdTraining.Text), Mail in List.EmailQR ))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous thanks for answering

This does not work if I put it in an If condition

If ( IsBlank ( Filter ( 'Training participants', IdTraining= Value (lblIdTraining.Text), Mail in List.EmailQR ) ), Patch ( 'Training participants', First ( Filter ( 'Training participants', IdTraining = Value (lblIdTraining.Text) ) ), {Status: "Didn't Present"} ) )

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

If needs boolean. Patch doesn't return a Boolean

Instead,

Set a boolean variable
in If statement, say Set(YourVar,true)
Make Timer Control, set visible to false, set auto start to false, set repeat to false, and set Start to YourVar
Set duration of timer to 1 (1 millisecond) to be quick as possible - or you can set it a bit higher if you want like 100 or so.
In Timer Onstart, move your Patch there
In Timer Onend, set the variable to false again Set(YourVar,false) so timer can be reused.
This should help in these kinds of cases.

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Or, try a simpler alternative to Timer (maybe it works):

Wrap the whole Patch in a Boolean returning function such as IsBlank, etc.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
@Anonymous
Okay, let me take a step back. Let's build a new collection based off of these two data sets. We'll do that by using AddColumns() to loop through one to build on to the other.

ClearCollect(PresentedResultSet, AddColumns( List, "Presented", !IsBlank(LookUp(Filter('Training of participants',IdTraining = Value(lblIdTraining.Text)),EmailQR=Mail,EmailQR)) ))

Then, we can test against this new collection called PresentedResultSet.

Filter(PresentedResultSet,Presented=true)

Meaning your last Patch() example should look like this,

ForAll(PresentedResultSet,If(Presented=false, Patch ( 'Training participants', First ( Filter ( 'Training participants', IdTraining = Value (lblIdTraining.Text) ) ), {Status: "Didn't Present"} )))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello @Anonymous ,
I'm sorry to bother you, the formula only updates me to the first filter element and that person attended

example
Person who did not appear:
ExampleEmail2@email.com

Person who appeared:
ExampleEmail1@email.com

The filter is updated to: ExampleEmail1@email.com

I think the problem is in the First (Filter ())

😞

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Sorry, yeah the Patch() is throwing me off. Do you just need a collection of users that didn't present? That would just be my solution above, only after the ClearCollect() you can just use this:
Filter(PresentedResultSet,Presented=false)

Was this reply helpful? Yes No