Answered

Pulling information from one SharePoint list into another SharePoint List.

(0) Share

Report

Posted on by Matthey

In one SharePoint list (A) I have a choice field called "Plant Area". In my power App, when the user selects the "Plant Area" I want the Reviewer/Approvers to be filled in from the data from the second SharePoint List (B). Both SharePoint List have matching "Plant Area" data.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Matthey have you considered using a lookup column instead a choice field?

ListB will contain all Plant Areas and approvers. ListA has a lookup to ListB.

This may or may not solve your needs - depending on what you want to achieve.

If you do want to do it with your current list layout I need some more details. Is each column a person field? So ListB has several person columns as ListA does? Si gle or Multiselect?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Matthey ,

You can make the Update of the Data Card

LookUp( YourSecondList, 'Plant Area' = YourDropDownName.Selected.Value ).YourRequiredFieldName

I would not recommend a Lookup field as they will cause you a lot of unnecessary grief in Power Apps.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Matthey 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Your suggestion above works well. Is there another step for the name to show up in the choice field on the App? I have the display set to view so the user can not change the valve, But I want the user to see the Reviewers and Approvers, so they know who the request will be going out. Currently under the Update, it is displaying the correct information when I select the down arrow.

Was this reply helpful? Yes No
WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Matthey ,

If this is a Combo Box, the DefaultSelectedItems assuming you are displaying a Text field would be

{Value:ThisItem.YourFieldName}

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No