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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.