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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lookup function help
Power Apps
Unanswered

Lookup function help

(0) ShareShare
ReportReport
Posted on by 228

I have a gallery for all the pending approvals, i want to display all the information from another table that is related to that item. ApprovalFor column on my list1 is equal to Document_Number in my list2. I am using LookUp('Released Document Library', 'Document Number' = Gallery1.Selected.ApprovalFor) on a form display but it doesnt seem to work.

 

 

 

Categories:
I have the same question (0)
  • h-nagao Profile Picture
    392 on at
    Hello,
    How do you set Data source property and item property of form control?
  • karl_oliverio Profile Picture
    228 on at

    Hello @h-nagao , I selected the data source thru dropdown on the form properties and I also use "LookUp('Released Document Library', 'Document Number' = Gallery1.Selected.ApprovalFor)" on the item property. 

     

    My expectation is that, whenever I selected an item on my Approval gallery and click on view details, it will navigate to the DisplayForm and fetch the data result based on the lookup function that i have. However, it returns 0 result.

     

     

  • h-nagao Profile Picture
    392 on at
    Thank you for explaining your setup.
    I suppose datasource of form is ‘Released Document Library', and each IDs are string/number type field, is that correct?

    To make sure, could you tell me a type of datasource, SPO, SQL, excel table etc...
  • karl_oliverio Profile Picture
    228 on at

    Hi @h-nagao - the datasource is SPO. Approval is a list and the other is a document library. The document IDs used for both sources are string type.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hello @karl_oliverio ,

    Try to set a variable and assign the ApprovalFor value to that variable during On Select function in Gallery1.

    Use that variable in your future references anywhere.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 610

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard