Using a SharePoint Lookup column in a Edit Form

(0) Share

Report

Posted on by bobbybob

108

Hello,

I have a Lookup column in my SharePoint list (List A) that connects to another list (List B). When the user selects an option from the lookup column (Column 1) in List A it populates a result in another column on List A (Column 2). I have created a App that connects to List A. I would like for the user to be able to select an option from Column 1 in an Edit Form and have it populate the result from Column 2 in the same form at the same time. Both columns are viewable in the App but the user must submit the form to see Column 2's result. I'd like the result to populate real-time on the same page while they're editing the info. Is this possible? If so any suggestion how I can accomplish this? Thank you for any info provided.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bobbybob

Sure, this is all quite possible.

A lookup column contains a record. The record has two columns, an Id and Value. The Id is to be the ID of the item in the looked up list and the Value should be the value of the column defined in the lookup column as the field to use (normally Title).

So, if you have a dropdown or combobox that is connected to your List, then what you would Update (in your Update property) would be the record. i.e. {Id: dropdown.Selected.ID, Value: dropdown.Selected.Title} as an example.

I am not sure I am completely following your logic though as you mentioned, "elect an option from Column 1 in an Edit Form and have it populate the result from Column 2 in the same form at the same time".

What do you mean when you say "the result from Column 2"? Are you stating that you want to update Column2 with the selection, or that somehow you want the "result" (please explain) to be involved?
bobbybob 108 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Thank you for the quick response.
When the user selects a choice from Column 1 it pulls the corresponding data to column 2. I would like the app to reflect this at the time column 1 is selected. Both Column 1 and 2 are retrieving data from List B. Does that make any more sense?

Here is my Lookup column settings:
bobbybob 108 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

???
CharlesDPower 21 on at

Like
a
(0)

Report
Copy link

Link copied!

I am working on the same problem, OP. I have a Power App this is using a SharePoint List as the Data Source. The SharePoint List has a LookUp column named 'Originator Command' from another SharePoint List named 'Address Book.' In my SharePoint list, when I added the LookUp column and connected to the 'Address Book' list, I elected to "Add additional columns from source list" (see attached image).

When I select an option from the 'Originator Command' drop-down menu in my Power App Edit Form, I would like it to show the user all of the "additional columns from source list" which I have pre-selected. When I attempted to add the "additional columns from source list" to my Edit Form, each having their own data card, they did not behave as expected. They appear as the standard Edit Form data card and do not update dynamically based on the choice that is made in the 'Originator Command' data card.

In researching this, I attempted to use LookUp formulas in my Power App to find the column/row in the 'Address Book' list which corresponds to my 'Originator Command' choice. However, I always received errors and was unable to resolve them.

In the meantime, I have opted to put a gallery in a custom Data Card, which filters the 'Address Book' list based on the selection from the 'Originating Command' data card. This works as a temporary fix, but I know that it is adding unnecessary strain on the app by having the filter a gallery every time I open an item from my main list.

@RandyHayes @bobbybob have either of you found a solution for this yet?