web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Creating a Dynamic War...
Power Apps
Unanswered

Creating a Dynamic Warehouse Map in Power Apps

(0) ShareShare
ReportReport
Posted on by 4
Hello Power Apps community,
I am working on a Power Apps project to create a dynamic warehouse map based on data from an Excel data source.
My objective is to visualize a layout similar to the attached images example :
 
 
 
 

where different warehouse sections have different sizes and positions. Each section should be a clickable rectangle that shows additional information in a popup.
Additional Notes :
Each rectangle should be clickable to show a popup with more information.
The layout should be data-driven and adaptable for multiple warehouse plans.
Does anyone know how to achieve this data-driven, dynamic positioning of elements in Power Apps? Are there better ways to accomplish this layout in Power Apps, or is there a way to make the gallery approach work as expected?
 
What I've Tried :
Data Structure: I have an Excel table with fields like Name, Width, Height, PositionX, PositionY, and Color to define the layout. Each item (e.g., W19, Z01) has unique dimensions and coordinates.
Initial Approach: I attempted to use a nested gallery setup (Vertical Gallery containing Horizontal Galleries) where the vertical gallery groups items by PositionY (to create rows).
The horizontal gallery inside the veritcal gallery filters items by PositionX within each row.
Result: However, this approach does not replicate the layout from my Excel example. Items are stacked incorrectly and the positions values do not align items horizontally within rows as intended.
 
Expected Outcome :
I want each rectangle to respect its Width, Height, PositionX, and PositionY values dynamically, based on the data, without manually adding each element. The rectangles should appear as they do in the Excel layout (see attached image).
Thank you in advance for your help!
Categories:
I have the same question (0)
  • ronaldwalcott Profile Picture
    3,862 Moderator on at
     
    Power Apps does not understand the layout or colours in an Excel file, only the data contained in columns.
    There isn't a translation for grouping columns in Excel to some object in a Power Apps control.
     
    Here is a mad starting point
    You cannot automatically create controls in screen therefore the controls you wish to manipulate already have to exist (all set to invisible).
    Visually each cell has to be a control, rectangle, textbox or container depending on if colouring it is sufficient.
    You therefore have a screen filled with these controls (there may be limit to the number of manageable controls on a screen)
    Each of these controls is managed by a table so the X position of the first one may be something like 
    Index(sampleTable, 1).Column1
    Y position, size, colour, also set with a value from the table
    The OnSelect can also be set in a similar manner.
    You are obviously confined by the size of the screen so you have to calculate the cell size based on the screen size and the number of cells in each row.  
  • SR-04112210-0 Profile Picture
    4 on at
    @ronaldwalcott : 
     
    I forgot to tell you that i convert the excel map in to a table like this: 
     
     
    So it's not possible to create the map dynamically? i need to create each control manually for each map? 
     
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard