Rota in PowerApps

[Anonymous]

Hi,

For my PowerApp, I basically need to build a rota, so on certain days it shows that certain people will do each of the 3 tasks of cleaning, drying and washing.

On the first screen when someone clicks to see the days rota, I need this rota to show:

For example, on a Monday, it will show in the rota, John will clean, Mary will dry, Martin will wash.

On a Tuesday, it will show in the rota, Hugo will clean, James will dry, Tony will wash.

I could create the rota using excel (static data) or just type a rota directly into PowerApps and play with the Visible function.

However, I want the Rota to be able to be changed easily via the PowerApp so if someone wanted to change the rota permanently, they could go into a screen, change the names of who does what 3 tasks on certain days and this would then change the rota permanently. Rather than having to go into a static/excel file or into the PowerApp edit mode to edit anything.

Therefore I am thinking on a second screen, I could have the Master Rota which can be edited and then this would be pulled through so when new rotas were looked at, they reflected the changes to the Master Rota. I am assuming this will require the Master Rota to be uploaded somehow into SharePoint, and then that info dragged into the other rotas based on the day. However, I am unsure of how best to do this.

Any advice is much appreciated.

Thanks

[v-jefferni]

Hi @Anonymous ,

You can try and use the Excel table as data source and create the App from data:

Build an App Using Excel as a Data Source (powerapps911.com)

Best regards,