Showing results for 
Search instead for 
Did you mean: 
New Member

Is it possible to build a multi user lieu time tracker with power apps?

Hey Everyone 

Trying to find out if there is a easier way for this to be completed.

Currently run a share point where individuals would fill in the selected fields for earning or using lieu time.

This would then get exported to a excel spread sheet which will update only when I open the excel spreadsheet. 

In the excel spreadsheet, I have many calculations to calculate the totals of different individuals lieu time. 

(Page 1 is where all the inputs get submitted) (Page 2 is just a total to show what they earned/used and total remaining time)

Essentially I tried to build a app earlier but kept getting stuck in many spots. Biggest one was that once the information was sent in, it wouldn't update till I opened the excel spreadsheet which was located in the one drive. I'm reaching out to see if anyone has built a similar tracking tool or if it is even possible. 
Would it be best to use a share point? Excel spreadsheet ? Flows? combination of all the above? 

Any guidance would be greatly appreciated


Impactful Individual
Impactful Individual

Honestly your best bet is to import the data into CDS and use a Model-driven app. I've built a time tracker in both canvas and Model-driven and the experience is much better in Model-driven.

I guess the biggest question I would have is do I need to start over?

I would like the power app to ask the same questions that the techs would fill out when they fill out the current tracker (Sharepoint list )

This List then updates a excel spreadsheet when I open up the spreadsheet called lieu time tracker. It runs a script that updates all new responses which then calculates the totals of techs on a different page. I'll try to include some pictures if that helps

Excel lieu tracker.PNGLieu time Sharepoint.PNGsharepoint info in spreadsheet.PNG

Essentially I would like the power app to ask the same questions that the sharepoint has 

Collaborate all the information then display the totals for everyone to see. Is that possible ?

If so, would Entities be the correct option?

Impactful Individual
Impactful Individual

Create an Entity in CDS called Time Tracking (or something like that) then just add the fields that exist in the SharePoint list. Once your fields are in, select Forms and edit the main form for the entity to have the fields you want, displayed how you want them. 

Once this is set up, if you create a model-Driven app, you just add your custom entity to the site map and launch the application.

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (34,263)