Power Platform Community Forum Thread Details

I am new to Powerapps and I want to create an staff attendance app were staff members fill out a MS Form to submit a work from home request and the data gets saved in a SharePoint list then the data gets displayed in Powerapps so staff members can see where people are working from.

So fair I have created the MS Form (the questions on the form are start date and end date of working from home), created two automate flows, one for creating the item and a second to trigger a flow when an item is created to send a choice email to management to approve the work from home request then a simple power app that displays the status of the request, Approved or in progress for each staff member in that SharePoint list (we have no need to display rejected requests). All the above was easy.

My question is this, I want the power app to display every person in the company and set the default work location to office BUT display the work location field as home if the current time is between the start and end dates of the work from home request.

My first thought is to create two SharePoint lists one that stores the work from home requests (we will call this list 1) and another with every staff member with the work location set to office (we will call this list 2), then configure the power app to display each staff member from list 2 BUT if the current time is between the start and end dates display the item from list 1 only for that staff member.

Hopefully this makes sense.

First off, is this possible?

Secondly, if possible, what would the logic look like (what code do I need)

I am open to suggestions to do these other ways, if you believe something would work better.

Lastly, I happy to provide more information or screen shots of anything if needed.

Thanks

Categories:

Building Power Apps