Dropdown like InfoPath

[JR-BejeweledOne]

One of the features of the InfoPath list dropdown control was the ability to set what column data the user would see while the value was a different column.

Is it possible to do something like that in Power Apps.

[JayMagness]

Hi,

After the field there should be a "." then will give you the choices in code assist

If you want you can send me a note and I can get on message with you and try to help you.

[v-yutliu-msft]

Hi @JR-BejeweledOne ,

Do you want to make a drop down display a column that data comes from another data source?

Could you tell me:

1)the relationship between current list and the new list?

2)the field's data type that you want to display? does it com from another data source?

I need you to describe more clearly about the data that you want in the drop down. 

Usually, if you want the drop down to display one field that does not exist in the original data source, you could use AddColumns function to reshape the data source(will not update data source).

For example:

set the drop down's Items:

AddColumns(listname,"newfield",formula about new field)

Then you will get a new field that value comes from the formula that you write, you could write the formula about another data source.

Then set the drop down's Value to that new field. The drop down will display that new field.

I suggest you know more about AddColumns function:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

Best regards,

[JR-BejeweledOne]

No, all the data comes from the same data source.   It's just nice way to show the user of the form a 'friendly' choice while using a different column as the actual 'value'.

You can do it if you are creating a collection to be used for a dropdown in the app by doing this:

Example:

ClearCollect(RequestType, {DisplayName: "Access to Additional Sites", ActualValue: "access"}, {DisplayName: "Replacement Badge", Actual Value: "replacement"})

I was hoping to be able to do something similar using a SharePoint list as the data source.

[v-yutliu-msft]

Hi @JR-BejeweledOne ，

If you just want to use a sharepoint list as a drop down's data source, thing is easy.

You just need to firstly create connection with your sharepoint list.

Then set the drop down's Items to this sharepoint list.

Choose the field that you want to display as the drop down's Value.

Best regards,

[JR-BejeweledOne · Accepted solution]

It was just a question.   There are other ways to access the value of the item using the controls overload properties.   Right now I am not even sure why I asked that.  Must have been having a day.