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?
Hmmm.....Isn't this just a label in your Gallery? That shouldn't change what shows in your Gallery at all.
Is this LookUp on a label or did I miss something?
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?
Hi - my gallery is set to the full range of items in my SQL table (I have not set a filter to it yet since I am just in test mode now with very few records).
I tried this: First(Filter(PlannerCollection, 'Planner ID'= ThisItem.StaplePlannerID)).'Planner Name' but I still do not get any results.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.