Checking if value exists in another gallery

(0) Share

Report

Posted on by EpicTriffid

345

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:

General Questions

All responses (5)

Answers (1)

EpicTriffid 345 on at

Like (1)

Report

Re: Checking if value exists in another gallery

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/
jaanihsm 300 on at

Like (0)

Report

Re: Checking if value exists in another gallery

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.
Community Power Pla... on at

Like (0)

Report

Re: Checking if value exists in another gallery

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!
Verified answer

EpicTriffid 345 on at

Like (1)

Report

Re: Checking if value exists in another gallery

Ignore this. It was set to disabled.
EpicTriffid 345 on at

Like (0)

Report
Re: Checking if value exists in another gallery

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))