Unanswered

Choice and Lookup Column

(0) Share

Report

Posted on by AsheerHasan

Hi,

I want to use a choice column from Table A as a lookup column in my second table, Table B. However, when adding the table to the PowerApps form, only the 'ID' values are populating instead of the choice column values.

Can someone assist me with this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (16)

Answers (0)

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The "ID" is being populated because "ID" is your Primary Name column.

"I want to use a choice column from Table A as a lookup column in my second table, Table B" - could rephrase what you mean?

Was this reply helpful? Yes No
AsheerHasan 93 on at

Like (0)

Report
Copy link

Link copied!

Then how can I populate the values instead of ID. As my point is to display the values in lookup column.

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you please show an image it would help very much.

Depending on the Control, if you bind a table, you can Pick the Field you want to display.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@AsheerHasan - you will get a solution quicker if you can answer my question.

Please look at this related post I answered a few months ago on returning related columns on a Form:

Solved: Dataverse Lookup Tables and Canvas Apps Forms - Ho... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
AsheerHasan 93 on at

Like (0)

Report
Copy link

Link copied!

Hello Amik,

Thanks for the step-by-step instructions. But still, I am unable to see the values in the choice column. Attaching the snapshot blow, please.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@AsheerHasan -

What do you have in the Items property of that Combo Box/Dropdown.

Is that a Custom DataCard or did you modify an existing DataCard?

Not sure what you want me to glean from the second screenshot - it does not tell me anything useful

Please provide detail

Was this reply helpful? Yes No
AsheerHasan 93 on at

Like (0)

Report
Copy link

Link copied!

In the item property of the combo box is showing primary ID from the Table A not the values.
I have added a new Custom DataCard and then added a combo box into that.
When I click on the item property of the choice column, then I saw it is indicating that the data type for evaluation. (So, I thought to attach the screenshot for your reference.)

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@AsheerHasan - when I say Items property, I mean click on the Combo Box, select the Items property, and tell me what expression you're using:

You have not provided that but I am going to guess you need to add the following into the Items property of that Combo Box:

Choices('Your Choice Column (Your Table Plural Name)')

Was this reply helpful? Yes No
AsheerHasan 93 on at

Like (0)

Report
Copy link

Link copied!

Please check.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@AsheerHasan please recheck my edited response - there was an error in the syntax (you need the Table "plural" name for a Local Choice).

If the Choice column in Table A is a Global choice, then use:

Choices('Your Global Choice Name')

Was this reply helpful? Yes No