Power Apps Form HELP - Lookup ComboBox Selection and Return Value to another Form Control

[DeborahJoy]

Hello,

I have been trying to figure this out for 3 days, to no avail, although I have done searches, watched videos, including from Reza Dorrani, to no avail. I have a strong Excel background, but Lists, Power Flow, Power Apps are all new to me.

Situation:

I have two SharePoint Lists:  Main Data List and Weekly Update List. 

• The Weekly Update List has one row for each employee, identified by their Employee Number. This is the first column within the Weekly Update List with the default name of Title. The other columns within this List are Division, Manager, Hire Date.
• The Main Data List has an Employee No column. This is a drop-down that is populated by the Employee Number column of the Weekly Update List. I then look up the related columns in the Weekly Update List (Division, etc.)
• When I use the built-in form that display when I select New in the Main Data List, and select an Employee Number, the Division, Manager and Hire Date all populate automatically from the Weekly Update List. That all works fine.
• I then used Reza Dorrani's excellent video to create a Power Apps Form for a much better user experience. Everything works perfectly, except for when I select an Employee Number, the Division, Manager, and Hire Date fields all remain blank.
• I have tried every manner of Lookups but they result in errors.
• To experiment, I added a TextBox and for Text, input the following, hard-coding the Employee Number. This worked, but when I try to replicate this using a lookup that looks at the selected Employee Number from the ComboBox, I can't get it to work. This is to return the Division, and I am trying to put the Division in the DataCardValue17: 

LookUp('Weekly Update List',Title ="00088").Division (This works but is hardcoded)

LookUp('Weekly Update List',DataCardValue3).Division (This does not work)

LookUp('Weekly Update List',DataCardValue3).Division (This does not work)

And many, many more that I have tried do not work.

Any and all help will be GREATLY appreciated. I'm at the end of my rope with this! 😥

Thank you!

 

[anandm08]

have you tried LookUp('Weekly Update List', Title = DataCardValue3.Text).Division

[DeborahJoy]

Thank you for your response. I did try that in both Default Selected Items and Items. Unfortunately, it still doesn't display anything in the Division field.

[anandm08 · Accepted solution]

As per my understanding, you have a main table containing a list of data and a weekly table containing another list of data. In the weekly table, you are storing employee numbers in a column named 'title,' along with other columns such as 'division,' etc. In the main table, there is a column named 'employee number,' which is a lookup column retrieving data from the 'employee number' column in the weekly table.

Now, you want to display selected data from a dropdown, which is a Combobox.

I am attaching some screenshot try this and let me know if you face any issue

this screenshot is for showing the data in comboboxand this is for showing the data related to selected dropdown data

[DeborahJoy · Accepted solution]

Hello and thank you for your response!

I tried this and it DOES work! But only when I insert a label into the form and test it with the label.

How do I relate it to the Division form field? Even though this field is NOT a combobox in the List where it resides, it seems to have made it into a combobox. 

Here is a screen shot of its properties:

[DeborahJoy]

For those seeing this later, the solution was great! And to move the control, delete the original control in the Card, then cut and paste the new control to place it in the relevant card (drag and drop does not work). Hope this helps!