cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
simms7400
Level 8

Display ComboBox Value Using LookUp Formula?

Hi Folks -

 

I have a DataCard on my EditForm that also has a ComboBox. The ComboBox is populated with Alias values of data element. As you know, the business user only knows Aliases vs the unique ID. For instance, Massachusetts is the Alias but the financial system recognizes it as 0987.

 

I have placed the CombBox over this field to "trick" the user.

 

Then, based on the CombBox selection, I have a LookUp on my Value card that uses the ComboBox selection  (i.e. Massachusetts) to return the unique id from a table (i.e. 0987) which is what is sent to th undelrying SP List. Therefore,  if/when the user goes back to the form and wants to edit this field, I need to display what is in the SP List. But what it's the SP List isn't in the ComboBox as explain above.

 

Essentially, I need to do the reverse logic. Based on the SP List value, I"ll need to lookup it's corresponding "Alias" to return the value that is available in the ComboBox list of values.

 

How do I acheieve this?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Display ComboBox Value Using LookUp Formula?

Hi @simms7400 ,

 

To achieve this, in SharePoint list, please have 2 sharepoint lists as below:

List1

Alias_ID           Alias

0987                Massachusetts

 

List2

Title         Lookup_Alias (lookup column which source is the "Alias" column of List1)  

 

When you create this Lookup_Alias column, also check the checkbox for Alias_ID, Sharepoint will automantically add the additional field called "Lookup_Alias:Alias_ID". This field will show the ID instead of the Alias value. But when you create an auto-generated app with List2, users would be able to pick value with Alias for Lookup_Alias in the edit form.

 

Capture.JPG

 

 

If you do not want to show "Lookup_Alias" column and only want to see the "Lookup_Alias:Alias_ID" in List2, you can hide the "Lookup_Alias" column by selecting "Show/hide columns":

1.JPG

Regards,

Mona

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

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Display ComboBox Value Using LookUp Formula?

Hi @simms7400 ,

 

To achieve this, in SharePoint list, please have 2 sharepoint lists as below:

List1

Alias_ID           Alias

0987                Massachusetts

 

List2

Title         Lookup_Alias (lookup column which source is the "Alias" column of List1)  

 

When you create this Lookup_Alias column, also check the checkbox for Alias_ID, Sharepoint will automantically add the additional field called "Lookup_Alias:Alias_ID". This field will show the ID instead of the Alias value. But when you create an auto-generated app with List2, users would be able to pick value with Alias for Lookup_Alias in the edit form.

 

Capture.JPG

 

 

If you do not want to show "Lookup_Alias" column and only want to see the "Lookup_Alias:Alias_ID" in List2, you can hide the "Lookup_Alias" column by selecting "Show/hide columns":

1.JPG

Regards,

Mona

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

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 87 members 5,028 guests
Please welcome our newest community members: