help with creating this canvas app

Question

1. Dropdowns not showing custom columns

• I created custom columns in my Dataverse table, but when I connect a dropdown, it only shows the default table view.
• I want the dropdown to pull values from the custom columns I created.
  • I’m not sure if this is a permissions issue or a configuration issue. Where exactly do I check permissions or views so that my custom columns appear in the app?
  • Any practical guidance or step‑by‑step instructions would be really helpful. Thanks in advance!

Answer 1

Hi Bi,

Thank you for the update and confirmation. You can try these other steps.

Okay, here's how to actually fix it in 3 steps:

Step 1: Use a Combo Box (not a Dropdown)**

Add a Combo box to your app. In the Items property, put this:

'MyDataverseTable'

Step 2: Set Up Display and Search**

Go to the Combo box's advanced settings and change these:

DisplayFields = [YourCustomColumn1,YourCustomColumn2]

SearchFields = [YourCustomColumn1,YourCustomColumn2]

This makes the box show and look for stuff in your columns.

Step 3: Update Your Data

After you add columns in Dataverse, hit Refresh under the Data tab in Power Apps or use this code:

 Choice or Lookup Columns?

 

Use the Choices() thing:

Items = Choices('MyDataverseTable'.Status) // Status is a choice column

Then, set DisplayFields = [Value].

 Check Your Access

 

 

I hope this helps.

 

Best Regards,

Noel

Answer 2

Hi Bi,

Thank you for sharing your question. I can totally assist you get those canvas app dropdowns showing your Dataverse stuff.

This is a regular head-scratcher in Power Apps. Dropdowns, combo boxes, and Dataverse data types each have their own weird settings. A tiny property mix-up can hide the exact column you're after.

Usually, dropdowns don’t show your custom columns because the control's Items and Value (or DisplayFields) settings aren’t right for Dataverse, or the column is a Choice/Lookup that needs the Choices trick to show its labels. In canvas apps, a Dropdown expects a table and just one column to show. If your Dataverse column is a Choice or Lookup, you HAVE TO use the Choices trick to get the list of values. If you're working with a Combo box, you'll point DisplayFields to the columns you want to show, and you’ll link Items to a table or to Choices for Choice/Lookup columns.

Here's what you can do, step by step, to get custom Dataverse columns showing in your dropdowns or combo boxes. Plus, how to double-check permissions and views so your fields show up.

To set up a basic Dropdown to show a text column: If your custom column is just text or a number, set the Items thing to your table and the Value to the column you want to show.

 

I hope this helps.

 

Best Regards,

Noel

Answer 3

I was able to resolve this issue on my own. What worked for me was turning on Modern Controls and Themes, then refreshing the page. After that, the Field option became available, and I could add my custom columns to display as needed.

I don't if that's the final solution for now