cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
FacundoGorla
Level 8

Problem with any column that uses Datasource. Nothing showing. Please help!

Hi, as the title says I'm having problem with Choice columns, even user columns or an one that have data on them.

 

Basically every day when I try to use my list the dropdown menus appear empty.

For example I have a Choice type column with the name "Tipo NC" that has 2 options.

When I try to create a file and go to that combo box (correct me if that is not a combo box) it's empty and doesn't give me anything to select.

 

Then I go to edit with powerapps and as I enter the app it shows me EVERY single choice, user or any column that uses a datasource in Red saying that the datasource is not correct. But when I go to edit it I just put the same thing that was already written there and then it fixes. The problem is that at the next day the same problem appears.
I've already checked datasource multipletime and it only uses 1 list so there's no error there.

 

For example the datasource of that "tipo NC" column is "Choices('PGTNC CERRO 1'.'Tipo NC')". PowerApps shows me an error, then I just delete a letter, put it back again and then it solves.... It's driving me crazy.

It seems like it doesn't load the datasource correctly. Even when it's fairly simple.

I leave two images, one working fine and the other that shows no choices when I click the dropdrown even when both use the same Datasource.

 

@Shanescows Big fan of your YT videos BTW

2 REPLIES 2
Community Support Team
Community Support Team

Re: Problem with any column that uses Datasource. Nothing showing. Please help!

Hi @FacundoGorla ,

I've made a similar test but not met the same problem like your description.

I think your problem may because of combo box.

 

1)If the data type is single choice, then using drop down control and combo box is both ok.

(Using combo box, no need to enter any word, it displays selection.)

2)If the data type is multiple choice, I suggest you use combo box.

3)If the data type is person, I suggest you use combo box instead of drop down.

 

Person type is a little special, it needs you to enter words firstly, then the list will show related items for you selecting.

If you do not enter words in the combo box, it will not display any selection.8278.PNG

//enter no word, show no items to select

 

8279.PNG

//enter words, show related items

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FacundoGorla
Level 8

Re: Problem with any column that uses Datasource. Nothing showing. Please help!

Hi! Thanks for the reply.

 

They are all single option. The Choice columns have "searchable" on, that's why I can write on them to filter options.

I know in User columns I have to write at least 3 letters for it to start searching, what I tried to show in the image was that I can't write or even if I could nothing would show up.

 

The problem is, some way, the datasource. It's like it lost conection with the List. 

Once I go on each Datacard, erase and write the SAME datasource in the exact same way it fixes with time. 

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,260)