Unanswered

How to scale powerapps to show multiple weeks through buttons

(0) Share

Report

Posted on by Rama96x

149

I am currently in the process of building a PowerApps where it should be possible to add where you currently are located (Out of Office, working from home or on-site) for the current week. Please see attached image.

For only one week (current week), this is pretty manageable to do within a gallery, as I can just hardcode the week days within Dataverse table (e.g., Monday_OoO, Monday_Home, Monday_Site ... Friday_OoO.) and then through buttons, I could then just patch a true/false value to the Dataverse table and visualize them with filled/non-filled button colours.

However, the catch here is that I would like to scale this to more weeks than just the current one.
Ideally, I should be able to go as many weeks ahead and add in where I will be working from and obviously with the ability to go back to previous weeks to see where people are located.

One thing I had been thinking about was to generate Dataverse Tables through "next week" button, so that it automatically would create a table for each week you click: (Table 1: Current WeekNum, Table 2: Current WeekNum +1 etc.).
I don't think this is best practice and even possible.

Is there anyone that has other ideas how I could structure my Dataverse Table so that it could allow my PowerApps to go back and forth to multiple different weeks?

Thank you in advance!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Shashank Bhide 944 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hmm, I think you need a datastructure like this.

first using date functions you can generate data for as many weeks as you want.
Then you use Gallery and child gallery component to bind to this data structure.
When you build the datastructure, for each view index, you fill the values for full week, then increment the weekIndex and build the week view again.
When you click the next week button, you set the gallery to show the schedule to next weekIndex
{ "myCalendar": { "schedule": [ { "nameOfDay": "string", "workStatus": [ { "location": "string", "workingFromLocation": true } ], "weekindex": 1 } ] } }

Was this reply helpful? Yes No
Rama96x 149 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response @shashankbhide, though I am not sure if I understand this solution, so please bear with me here:
- The code you have attached, where would that be implemented? Within PowerApps?
- How would the structure of the dataverse table look like with your solution?

Was this reply helpful? Yes No
Shashank Bhide 944 Moderator on at

Like (0)

Report
Copy link

Link copied!
So this is how I think it should work.
You don't have a direct data source representing your screen layout.
That's why you've to create an in-memory object first in the desired shape.
You can start with an empty object on the start of the application and then fill it with data by calling powerapps functions.
Finally you can bind the screen layout with this in-memory data object.

Was this reply helpful? Yes No