cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
meddlema
Helper I
Helper I

Dropdowns blank after refreshing data

Hello, 

 

I have a Sharepoint List.   I am customizing the form in Powerapps for the Sharepoint list.  

 

When I refresh the data the dropdown fields will get an error on them and the data in the dropdowns is no long there. 

 

I have to retype the value in the Items field or set isSearchable to false to get the choices to come back .   Both steps work to return the data.  

 

This has happened several times and gets frustrating to have to do the work over again every time I refresh the data.  This is definately slowing me down. 

 

Is this a bug or this something I am doing wrong?

 

 

Correction:  There seem to be two different issues going on here after refreshing data

 

1.  The dropdown fields have an error in the ITEMS field.  I am finding if I click on the red circle and select Edit in the Formula Bar on each error acutally stops the error.  I don't even have to retype anything.   I just keep selecting Edit in theFormula Bar and the error goes away. The error still comes back if I refresh the data.  This very aggravating. 

Powerapps error.png

 

 

 

2. I have to change isSearchable to false and the data comes back.   Fortunately, when I refresh data the data in the dropdown stays.  I should not have to change the isSearchable for every dropdown I have. 

 

Again, is this a bug or something I am doing wrong?  I have tried in different browsers with the same results. 

1 REPLY 1
v-siky-msft
Community Support
Community Support

Hi @meddlema ,

 

What is the column type of these dropdown fields with errors?

 

I am guessing there might be some issue with the data source connector. Can you please try to remove your Sharepoint connection, then logout of your browser, clear the cahe, relogin and recreate the data source connection. Please try this out and let me know the details.

 

Best regards,
Sik

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,145)