cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Creating one dropdown from SharePoint lookup columns

Hi,

 

I have two lookup columns in SharePoint List (MasterID:Inspector1 and MasterID:Inspector2)

 

Is there any way that I can use these two columns in one dropdown in my EditScreen Form?

 

Any help is appreciated.

 

Regards,

May

4 REPLIES 4
Highlighted
Helper II
Helper II
Highlighted

Hi,

 

Thank you for your reply.

 

I am sorry I am not clear. I need to create one dropdown from two SharePoint lookup columns.

 

Regards,

May

Highlighted
Community Support
Community Support

Hi @mayarnaldo ,

Do you want to display two lookup fields in one drop down?

Could you tell me:

1)two lookup fields name?

2)lookup field1 looks up to which field in which column?

3)lookup field2 looks up to which field in which column?

4)the relationship between these two lookup fields?

5)after you select values in this drop down, which field do you want to update?

 

Since I do not quite understand your meaning, I suggest you post your screenshoots to describe.

 

What's more, if you want to display two fields value in one selections, I suggest you use combo box, which could set two fields as primary text.

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

Hi @v-yutliu-msft 

 

Thank you for your reply.

 

There are two Sharepoint list: Master List and Detailed List.

 

1)two lookup fields name? MasterID:Inspector1 and MasterID:Inspector2

2)lookup field1 looks up to which field in which column? MasterID:Inspector1 looks up in the master list with primary inspector name

3)lookup field2 looks up to which field in which column? MasterID:Inspector2 looks up in the master list with secondary inspector name

4)the relationship between these two lookup fields? They are input from the Master List with Inspection Title and Inspection ID which is a lookup column also in Detailed list. 

5)after you select values in this drop down, which field do you want to update? In the Detailed List, there's a Inspector column that suppose to be a dropdown which the user can choose if they are with Primary inspector or Secondary inspector.

 

 

Inspector name.jpgInspector.jpg

 

 

 

 

I tried to use combobox but it seems lookup column is not showing in the edit fields.

 

 

Hope I make it clear. Thank you again.

 

/M

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,827)