Showing results for 
Search instead for 
Did you mean: 
New Member

Power App dropdown field in form doesn't display exist record in SharePoint list



I am pretty new to PowerApp and trying to crate a phone for a SharePoint list.

I started creating the form by clicking "customized form " from SharePoint list. However all the drop down fields on my form don't display existing record if I clicked on an exitsing record.  How could I fix this?



Thank you!





Community Support
Community Support

Hi @EllianHsieh,

I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:4.JPG

Please make sure that the Items property of All Combo Box control within your Drop down field Data card is set to following:


the DefaultSelectedItems property of All Combo Box controls within your Drop down field Data card is set to following:


Please take a try to clear cache of your browser, then try your custom form again, check if the issue is solved.

In addition, please also take a try to remove the custom form from your SP list, then re-create a new one for your SP list, check if the issue still exists.


Best regards,


Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Kris,


I used Distinct('MyList',Country) instead of Choices and wasn't able to set Defaul property to Parenr.Defualt. I got an erro message satets" The property expect Record value, but this rule produces incompitable Text Value" Is it becasue I used "Dinstinct" instead of "Choices"?


I also created a new list in sp for testing Choices function but I wasn't able to use choice function. I got "The choices has some invalid argument. The list I used is in a excel file in my one drive and I had add the data into PowerApp.


Choice function.PNG



Not applicable

adding @emmac to review and assist. 



Hey @EllianHsieh


Can you share the structure of your data that you are trying to show in your dropdown? 

Is it:

-a choice field in the SharePoint list? 

-a text field in the SharePoint list? 

-a LookUp field in the SharePoint list? 

-using Excel to present the options in the dropdown?

-another type of data? 


Are you writing the data in your PowerApps form to a SharePoint list? 





Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (30,080)