cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karl_oliverio
Level: Powered On

Lookup function help

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.

 

 

 

5 REPLIES 5
h-nagao
Level 10

Re: Lookup function help

Hello,
How do you set Data source property and item property of form control?
karl_oliverio
Level: Powered On

Re: Lookup function help

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
Level 10

Re: Lookup function help

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
Level: Powered On

Re: Lookup function help

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.

Highlighted
Surya_PH
Level: Powered On

Re: Lookup function help

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.

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 242 members 4,468 guests
Please welcome our newest community members: