Answered

Compare records of sharepoint to items in a gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I'm trying to check if in the column 'Departamento' in the sharepoint list 'Equipa' is there any records with the same Departamento as in the gallery items. If there is the variable will be set to true, if not it will remove the gallery's item. Can you guys help me? I have this code but it doesn't work.

/*ForAll(Equipa,
 If(Departamento = ThisItem.Departamento,
 Set(gblShowPP, true),
 Remove(Departamento, ThisItem)
)*/

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi!

There's a couple things going on here, but to start - If this is being used in a control that's inside the gallery, something like the following code could work:

If( ThisItem.Departamento in Equipa.Departmento, Set(gblShowPP, true), Remove(*GalleryDataSource*, ThisItem) )

This uses in to check if ThisItem.Departmento is in Equipa.Departmento. Please note you'll have to swap in your galleries datasource into the remove function.

Hope this helps!

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

Like (0)

Report
Copy link

Link copied!

Hi!

With this code it gives me the following error: Can't convert this data type. Power apps can't convert this Text to a Record.

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!

Where is the error highlighted?
It looks like we're trying to compare text to a record value somewhere, which is no good.
As a side note, what's your datasource for this, and what's the column type of Equipa.Departmento?

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

Like (0)

Report
Copy link

Link copied!
The error is highlighted in
ThisItem.Departamento
My datasource is a sharepoint list and Equipa.Departamento is a choice.

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
I see. Perhaps we can throw in a forall to get the choice column values.
Try replacing the "in" function with:

ThisItem.Departamento in ForAll(Equipa.Departmento, Departmento.Value)

Let me know how it goes!

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

Like (0)

Report
Copy link

Link copied!

The ForAll function is all highlighted right now and it gives me this errors: The Function ForAll has some invalid arguments. and Departamento isn't recognized. 😅

Was this reply helpful? Yes No
Verified answer

madlad 2,637 Moderator on at

Like (1)

Report
Copy link

Link copied!
That error indicates that the column "Departamento" isn't in the table returned by Equipa.Departamento.

Two things I see:
I realized, we actually can just use "Equipa" in the forall.
Also just realized I've been spelling "Departamento" wrong this whole time lol

Try the following code as a forall, and if it still doesn't work, double check the column names are correct - those should solve it hopefully.
ForAll(Equipa, Departamento.Value)

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

Like (1)

Report
Copy link

Link copied!

You are a legend!! Thank you so much!!
I was also spelling Departamento wrong!
Thank you so much!

Was this reply helpful? Yes No