Skip to main content

Notifications

Community site session details

Community site session details

Session Id : En1vG348pGO0YfSLAi3q0e
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
    146,668 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
    146,668 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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard
Loading started