Hi hoping for some help,
Quite new to this but struggling to show data from excel table in a drop down. Currently using: -
Distinct(TABLE NAME, COLUMN NAME)
I've connected to the data source but when i preview it doesn't show any data.
You have the correct syntax so I would expect PowerApps to show some options. Did you use this code within the Items property of the dropdown?
Can you please share a screenshot of your app? Make sure the code you used in the Items property is displaying in the formula bar inside your screenshot.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
please add the column to your source within the Distinct like:
thanks for your feedback. If you click on the arrow under your formula bar, you would see a preview of your items. Is there any data shown?
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.