cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amralomari
Helper III
Helper III

How to display data from lookup column in powerApps

I'm building a system to follow up with material quantities in my store, so I have a list with all the materials with a unique number for each material and another list with a lookup column where the user enters the unique number and immediately info. related to this unique number are shown.

applying this to powerApps, I created an edit form, when choosing a number the other data related to this number doesn't show in the fields!

 

 

how it's displayed after chosing a numberhow it's displayed after chosing a number

Here is how it appears in the app!

highlited are the lookup columnshighlited are the lookup columns

here is the list, the highlighted columns are the lookup columns (the first one is the lookup and the 2 next it are related to it)

 

5 REPLIES 5
Mr-Dang-MSFT
Power Apps
Power Apps

Hi @amralomari ,

If I'm understanding correctly:

  • You have a combo box you use for searching and selecting a unique number for each material.
  • You have a form where you want to show the lookup information for the number selected in the combo box.

Some questions:

  • Select the form control and go to its Item property. What is that set to?
  • Select the individual data cards in the form. What is the Default property of each set to?

Thanks a lot, Mr @Mr-Dang-MSFT for your reply

 

when I've inserted the edit form it created this box (which I can't search in it until now ":D) and assumed the info will appear in the form.

 

The box item property is:

 

Choices([@'Formulation store log'].Search_x0020_for_x0020_Q_x002e_C)

 

 and one of the card's property is :

 

Choices([@'Formulation store log'].Search_x0020_for_x0020_Q_x002e_C1)

 

 

 

Hi @amralomari ,

To clarify, the form control can show the information for a row in a table. It has an Item property that you set to a record that you look up (row). In your case, you want to set it to the record selected in the combo box at the top, assuming it is tied to the entire row of the table.

 

Select the form control (the entire thing, e.g. EditForm1, not just one field). Set its Item property to:

Combobox_name.Selected

 

The form will be in the context of the row that is picked from the combo box/drop down menu. Change combobox_name to the name of the control at the top that you use for searching and picking.

 

Select the form. Select a data card in the form for one of the lookup columns; a data card is the box that holds the controls for each field. Go to its Default property; this determines the value it shows. What is appearing?

Dear Mr. @Mr-Dang-MSFT 

 

when trying to edit the item property of the whole form it gives me an error

Untitled.jpg

 

 

 for the cards they are 

 

Choices([@'Formulation store log'].Search_x0020_for_x0020_Q_x002e_C)

 

and 

 

 

Filter(Choices([@'Formulation store log'].Search_x0020_for_x0020_Q_x002e_C1), Id = DataCardValue29.Selected.Id)

 

 

 

eftichia
Helper I
Helper I

Hi,

I have a similar issue. Did you find a solution?

Thanks

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,058)