cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TyphonExpanse
New Member

Labels linking to cell in Excel spreadsheet on Map

I'm creating an interactive floorplan for our small company.  PowerApps sees my excel data source (Table1), but I can't seem to link each label to a single cell in my spreadsheet. Can you guys nudge me in the right direction?

 

The pic shows how I would like it to look (sans the blank rooms. and I entered names in the labels manually just for reference) When the user clicks on a room, the data table in the upper-right shows their Name/Extension/E-mail (or the single row that the cell is from.)

 

So for example, for the Boardroom, I would like the label to link directly with cell B2 in my spreadsheet. so that it shows the name like in the pic.

 

I've tried this but it's not working. What am I doing wrong?

LookUp(Table1,Name=[B2]).Name

 

Getting the search field working is a whole other issue entirely... I understand I'll need to create a gallery overlay for this. but I'll take it one step at a time for now... 🙂

 

 

2 REPLIES 2
GarethPrisk
Resident Rockstar
Resident Rockstar

Power Apps will only be able to access rows and columns within tables that are used in the app. The other cells of the workbook are not accessible by the Power App. It also reads the tables without resolving formulas, only as their resulting values.

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-excel

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/cloud-storage-blob-connecti...

 

You can accomplish the outcome you're looking for, but you will need to refactor the data. If you image that your map is a grid - maybe 100x100 squares, then it can be reflected in a table. Perhaps

  • Map Rooms
    • Room ID (some sort of way to distinctly identify, even if just a #)
    • Description/Name
    • Border Squares (comma-delimited list of squares which represent the border)
    • Interior Squares (comma-delimited list of squares which represent the interior)
    • Border Color (to tell the app how to color the border)
    • Interior Color (to tell the app how to color the interior)
  • Map Room Assignments
    • Room ID
    • Assigned To
    • Start Date/Time
    • End Date/Time

You'd then be able to render a Gallery. Let's say the Gallery was 12x12 (144 squares). Here is a basic example of how you could then structure the data so it could be displayed in a Gallery.

This is a rudimentary example. It does, however, give you some great functionality so if someone clicks into any of the cells of the grid, you'd know the Room ID they clicked and could show the assignment/contextual info.

 

Map Gallery Grid Example.png

TyphonExpanse
New Member

Thank you Gareth,

 

That is very helpful, thank you. That clears up a lot of the questions in my mind regarding how I would pull it all together. This seems like a bit of an undertaking for a floor plan map. I have a lot on my plate right now and time isn't on my side... I may buy a Visio license and experiment with linking and sharing my map with a sharepoint spreadsheet first before resorting to this.... 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,183)