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.
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.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

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