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."
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 the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021