Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ue2EKdu0tVHHbYnPc1XLs3
Power Apps - Power Apps Pro Dev & ISV
Unanswered

Format of Dropdown data

Like (1) ShareShare
ReportReport
Posted on 16 Oct 2024 18:38:35 by 2
I am somewhat new to Power Apps.  I know what I need to do, but I was not able to find any information on the format for my dropdowns.  I will need to create multiple dropdowns, and I prefer to create it in an Excel file.    Now what I am unsure of, is in what format do I create each of my dropdown lists.
 
  • Should they be on the same sheet as a 1 large table??
  • Or should they be Separate tabs for each list???
  • Should each list be it's own separate table?
 
Is there a visual example that can be provided?  Each of my lists has a varying number of items.
  • WarrenBelz Profile Picture
    147,112 Most Valuable Professional on 25 Oct 2024 at 00:01:27
    Format of Dropdown data
    Just following up to see if you received the answer you needed, or if you require further assistance.

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee
  • WarrenBelz Profile Picture
    147,112 Most Valuable Professional on 16 Oct 2024 at 20:48:41
    Format of Dropdown data
    The first suggestion I will offer is that is you have access to SharePoint Lists, use them instead of Excel, which is really only a viable option if you have nothing else.
    To answer your questions, each List needs its own Table and separate Tabs would be good housekeeping, although not technically necessary.
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Apps Pro Dev & ISV

#1
WarrenBelz Profile Picture

WarrenBelz 83 Most Valuable Professional

#2
mmbr1606 Profile Picture

mmbr1606 55 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 50

Overall leaderboard
Loading started
Loading complete