Checking if value exists in another gallery

(0) Share

Report

Posted on by EpicTriffid

364

Morning all,

So I'm scratching my head a little on this. This is the problem:

I have two galleries. I want the background of the Staff Name box on the left to turn red if the name of the person appears in the gallery on the right. The gallery on the right is from a collection called staffListForGR, so i'm running the condition against that. It doesn't matter that the ID's are wrong, only that the same name appears. But whatever permutation of the above code i try, it doesn't work, even if it doesn't throw up any errors.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

EpicTriffid 364 on at

Like (0)

Report
Copy link

Link copied!
I have also tried this to no avail. Once again, no errors, it just doesn't work:

If( CountRows( Filter( staffListForGR, 'Staff Name' = Self.Text))>0, Color.Red, ColorValue(textboxColour))

Was this reply helpful? Yes No
Verified answer

EpicTriffid 364 on at

Like (1)

Report
Copy link

Link copied!

Ignore this. It was set to disabled.

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

Like (0)

Report
Copy link

Link copied!

Hello @EpicTriffid ,
I think what you suppose to do is collecting all the items in the first gallery in a collection. Then, do the same for the second one and have a condition to check if it exists or not.
Find the screenshot below:

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report
Copy link

Link copied!

Hi @EpicTriffid! What did you mean by it was set to disabled? I am trying to compare parseJSON text value in a gallery vs a SharePoint list and get a delegation warning...Maybe I can count rows in SharePoint list instead if >0 then change color to red.

Was this reply helpful? Yes No
EpicTriffid 364 on at

Like (1)

Report
Copy link

Link copied!

Hi @jaanihsm

This is an old post, so I had to wrack my brains for what I was talking about back then. I meant that the control's displaymode was set to disabled, so even though i was correctly altering the fill, it was only showing me the disabledfill.

As for you, it might be worth pulling the sharepoint list into a collection and running your check against that. I believe ISBLANK is not delegable to the datasource. This page contains a solution for that in case you want to stay directly connected to the datasource: https://www.matthewdevaney.com/sharepoint-delegation-cheat-sheet-for-power-apps/

Was this reply helpful? Yes No