Power Platform Community Forum Thread Details

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!

Categories:

Building Power Apps

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.

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":