web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / LookUp not working for...
Power Apps
Unanswered

LookUp not working for Item property in Form (GCC High Bug?)

(0) ShareShare
ReportReport
Posted on by 8

 

This appears to be a bug.  I am in gcchigh cloud (.us) so we have a different configuration from the commercial cloud (.com).  I have an app that is loaded with edit forms.  I typically use a gallery to display data from a SharePoint list and I use an edit form in a container that appears when the user selects an icon in the gallery.  I have done this in many ways, but for this particular case I am setting a variable to the ID of the item in the gallery.  This works fine.  I then set the Edit Form item to LookUp(ListName, IDcolumn = varID) Where the ID column is not ID but a unique ID I create for the item to use as a key.  This works almost OK in the editor.  I sometimes need to open /close the form a few times but then I see the data I want.  This behavior is not normal but I mention it because when I publish the app and open the form there, the form is blank and says Getting Data (or something like that).  There is nothing wrong with the formula, I can use it in a gallery and it shows the data I want. It just does not work in the Item property of an edit form.  The ID was in the title field and I even tried creating a duplicate field and populating that with the ID just in case that was causing this.  Same behavior, works sometimes in the editor with the play button, does nothing but show a loading message in the form when published.  

 

My terrible work around here is to create a gallery that uses lookup for the Items property and then use Gallery.Selected for the item property of the form.  This is utter nonsense and anyone coming to the app and trying to understand it would question my competency, but it works.  

 

I have other screens in the app that use the same lookup strategy and they still work.  It worked fine in 2023.  

 

Is this a known issue? Are there any risks to leaving a gallery as a pass through to a form apart from the difficulty in unraveling the design of the app?  This bug basically ate the first 2 days of my week.  

 

Note: I have not messed around with this on a new screen.  I did change this screen to use a form instead of editing in the gallery and patching because users wanted to see more data than I could fit in a gallery.  Also there were a lot of changes over the holiday.  The People Pickers now show Claims as the default search and the Power automate default editor changed dramatically and in a way that might make me have to redesign flows.  Default values cannot be left blank in Update Item actions which used to allow you to keep the current data without having to get the current value and rewrite it.  

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 793 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 333 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard