Hi All -
I am having an issue where my Lookup into a collection is not working.
In a gallery, I have one field which is looking up into a Collection and trying to pull in a field from the collection, using the code below:
LookUp(PlannerCollection, ThisItem.StaplePlannerID = Label22_25.Text, 'Planner Name')
My issue is that the record of 'Planner Name' continues to be duplicated in the gallery and does not appear to be working.
Any help? 🙂
In the attached image, I am trying to look up the # in the far right column of the gallery and return the name of the user associated with that number from my collection which consists of Name and #.
Solved! Go to Solution.
Label22_25.Text is the label in your gallery?
If so that is called the same thing in every line of your gallery so you will need to change that to ThisItem.FieldName and the other side actually doesn't need ThisItem...it can just be the field name from your collection. Basically the ThisItem portion need to be referring to the data source of the gallery you are in.
Thanks for the quick reply!
I changed my formula to this: LookUp(PlannerCollection, 'Planner ID' = ThisItem.StaplePlannerID, 'Planner Name')
but now there are no results in the gallery. Thoughts?
Yes, I am looking up the value from a label in the gallery to find a value from a collection and bring that back to another label in my gallery. Sorry if that was confusing but did that help explain?
Featuring samples like Return to the Workplace and Emergency Response Applications
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
Features releasing from October 2020 through March 2021