Unanswered

Multiple SharePoint Lookup fields

(0) Share

Report

Posted on by techtudoor

249

Hello PowerApps community. I have ran into an issue with multiple SharePoint lookup fields and am stumped, I may be over thinking.

I have a SharePoint list called Things that has multiple lookup fields. These fields are looking up values from a SharePoint List called Buildings.

Field names are the same in both lists.

BuildingName

BuildingNumber

BuildingManager

BuildingAsstManager

I have added BuildingName and BuildingNumber fields from Things to my PowerApps (Things is the main List). My ultimate goal is to have Building Name be selected, then BuildingNumber will populate with the associated Number for the selected building.

I have tried

Lookup(Buildings, BuildingName = <buildingnamedrop>.Selected.Value, BuildingNumber)

I need the lookup to provide the correct Building Number for the selected building name. This information is located in the Buildings SharePoint List.

The next twist is I do not want to have to add extra fields. I have 1 user that will only be using the SharePoint List and not the PowerApps. So extra fields will cause them to question the need for extra fields and PowerApps in general.

Any suggestions greatly appreciated.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @techtudoor ,

What result are you getting from

Lookup( Buildings, BuildingName = <buildingnamedrop>.Selected.Value, BuildingNumber )

If the buildingnamedrop is based on a Lookup field, the output reference is correct and if the BuildingName matches the item in the list Buildings, it should how the corresponding BuildingNumber.

You can also try

Lookup( Buildings, BuildingName = <buildingnamedrop>.Selected.Value, ).BuildingNumber

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @techtudoor ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
techtudoor 249 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

I am getting close with

Lookup(
Buildings,
BuildingName = DataCardValue1.Selected.Value,
).BuildingNumber

It shows what the expected output should be, but the dropdown for BuildingNumber does not show anything. The error I get is "Expected Table value."

I should mention that BuildingNumber in the Buildings list is a single line of text, while the lookup field in Things is of course a dropdown. Could this error be due to BuildingNumber being a single line of text in the Buildings List?

I am so close. I will have 2 more fields that will use the same syntax as well. So if I can get this one working, the others would work as well.

Thanks

Was this reply helpful? Yes No
WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@techtudoor ,

Can you please tell me what type of fields these all are in your data source.

Was this reply helpful? Yes No
techtudoor 249 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , I apologize for the delay I have been a little under the weather. My data source were lookup fields which created my controls to be drop down options. What I ended up doing, was to remove 3 of the look up fields and make them single line of text fields only. Then I set the control for the 1 remaining lookup field to do a lookup from the Buildings SharePoint list.

Default:
If(Form1.Mode = New, LookUp(Buildings, BuildingNumber = DataCardValue3.Selected.Value).BuildingName, Parent.Default)

Once I selected the building name from the dropdown, it then runs a lookup to populate the other fields from the Buildings List. The record is then stored in the Things list.

I appreciate your assistance.

Thank you

Was this reply helpful? Yes No