Time tracking solution ⏱ in Teams with PowerApps and Power BI

Поділитися
Вставка
  • Опубліковано 10 гру 2024

КОМЕНТАРІ • 104

  • @GHRichardson
    @GHRichardson 5 років тому +3

    Hi Ruth, Love the quick solution!

    • @CurbalEN
      @CurbalEN  5 років тому +1

      Yes! You are sooo right! In this case it makes more sense to get the data directly in power bi service! Awesome tip, thanks!!
      Pinned!
      /Ruth

    • @ArkWorksCNC
      @ArkWorksCNC 5 років тому

      Ruth, I love this video and concept! It ties in with a concept that I've had for some time now with one slight difference, maybe you can help.
      I need to have a user input form like you created in PowerApps, but my form needs to have other fields tied to a pre-existing unique record from a list. Example would be if the SP list was pulling in new data daily from a DB and the user of PBI/Form needed to use a drop down to select a record and add some local comments to that unique record that wouldn't tie back to the DB necessarily, but would be stored in an alternate table. All of this of course, would tie together from SP to PBI and vice-versa. Any thoughts on how to implement, along with a MSFlow immediate refresh like Geoff mentioned would be greatly appreciated? Keep up the great work!

  • @SaniGarba
    @SaniGarba 5 років тому +8

    The enthusiasm is infectious. Thank you, Ruth.

    • @CurbalEN
      @CurbalEN  5 років тому

      I had a lot of fun doing that video :)
      /Ruth

  • @berniefigueroa4117
    @berniefigueroa4117 4 роки тому +1

    Wow this is amazing, You made this really easy to understand. I am a PM and currently we are using a spreadsheet per person and in each spreadsheet one tab per month. I have to compile monthly and it's very very painful. Thank you for presenting this.

  • @JamieWillisRose
    @JamieWillisRose 5 років тому +2

    Great video. FYI - The Title Field has special powers in a SharePoint list. Specifically, in the the List view, SP automatically makes the value of the "Title" into hyperlink to view that list item. I highly recommend renaming the Title field, rather than hiding it. IF you really, really want to make it hidden, you can go to Advanced settings and click "Yes" under "Allow Manage of Content Types", then click OK, then edit the "Item" content type and set the "Title" field to "Hidden (will not appear in forms)" instead of Required. But again, I wouldn't do that unless you absolutely were sure you didn't want the usefulness of the hyperlink in the list view as described above. (Bonus Tip: You can turn off Attachments in the List Advanced settings)

    • @CurbalEN
      @CurbalEN  5 років тому +1

      Wonderful!! Love your tips 😍, thanks!
      I still “hate” the title by default. It makes sense on a library, never used it on a list, I should be able to choose if I want it... ;)
      /Ruth

  • @kimpaciotti8913
    @kimpaciotti8913 4 роки тому

    I appreciate the 20 minutes, and the enthusiasm. I wouldn't have minded a bit slower with out feeling the time pressure.

    • @CurbalEN
      @CurbalEN  4 роки тому

      You can slow down a youtube video if the pace is too fast:)

  • @HachiAdachi
    @HachiAdachi 5 років тому +1

    Simple yet so POWERFUL! Thanks, Ruth!

    • @CurbalEN
      @CurbalEN  5 років тому

      Exactly! Mind-blowing!
      /Ruth

  • @ferranpineda
    @ferranpineda 3 роки тому +1

    That's exactly the app that I'm finding, well done!

  • @scotchbonnetracing
    @scotchbonnetracing 2 роки тому +1

    Did anyone ever find the calendar in community downloads??

  • @kingdomarrows7508
    @kingdomarrows7508 5 років тому

    Really enjoyed that Ruth.....so simple. Will definitely be using this

    • @CurbalEN
      @CurbalEN  5 років тому

      Complete madness that it is so simple... the integration between power apps and SharePoint is simply outstanding! Blew my mind 😳
      /Ruth

  • @andrebernard3204
    @andrebernard3204 2 роки тому

    and what do you think about cloud Timestatement time tracking and invoicing?

  • @Zsebtetu
    @Zsebtetu Рік тому

    Great content, thanks. I've tried to re-create it, but I'm lost at the calendar in the description. Can you please help me?

  • @robfreeman1987
    @robfreeman1987 3 роки тому

    Thanks for the great video.
    I would be very interested in what the World Cup 2018 Report shows and how you built it.

    • @CurbalEN
      @CurbalEN  3 роки тому

      Will do a new football report soon :)

  • @vida1719
    @vida1719 5 років тому

    Ruth, that's great business solution

    • @CurbalEN
      @CurbalEN  5 років тому

      Thanks Vida! :)
      /Ruth

  • @DebuG35
    @DebuG35 4 роки тому

    Nice video! Thank you Ruth!

  • @asifkhawaja
    @asifkhawaja 4 роки тому

    Great effort in less than 20 minutes.

    • @CurbalEN
      @CurbalEN  4 роки тому

      Amazon, isnt it?
      /Ruth

  • @410guy
    @410guy 3 роки тому

    thanks very helpful

  • @opeenitan
    @opeenitan 4 роки тому +1

    Thanks for the beautiful video...i implemented this and it worked well on my PC but when i try to open it via teams on my colleagues PC it says the report isn't available to you. Check with the report owner to see if you need additional permission or a different power bi license to view it.

  • @amarsodhi
    @amarsodhi 4 роки тому

    Hi Ruth, thank you for your quick response previously. Is it possible to block the visibility of data to everyone? Like I should be able to see and edit only my data not others.

    • @CurbalEN
      @CurbalEN  4 роки тому

      Only in power BI with with RLS

  • @terencealmeida4594
    @terencealmeida4594 4 роки тому

    Hi Ruth, thanks for the info, it was indeed helpful, I have prepared a time tracker, can you let me know if we can capture the login and logout time/hours from power apps to sharepoint lists.

  • @jollo0815
    @jollo0815 4 роки тому

    I literally love your enthusiasm. Unfortunately I can't find the calendar download. Can you assist?

    • @CurbalEN
      @CurbalEN  4 роки тому +1

      Hi Jörg,
      It is on the download center, community downloads. Search by calendar.

  • @luisedugarridosoares
    @luisedugarridosoares 5 років тому

    Hi Ruth. How are you? As you had created a calendar table it means in Power BI desktop you don't select the option "time series" correct? I believe it increases report performance, correct?

    • @CurbalEN
      @CurbalEN  5 років тому

      Hi Luis,
      What do you mean with ”time series” option? This one?
      m.ua-cam.com/video/d4yAzhIQqNk/v-deo.html
      /Ruth

  • @JohnBrines1969
    @JohnBrines1969 3 роки тому

    Hi Ruth, great video. Is it possible to have a running total for that week, once that week finishes then it starts a new week?

    • @gachaizzy1454
      @gachaizzy1454 3 роки тому

      Hi john i am after something similar, but i would like to carry forward any hours under the monthly target to the next month and add to that months total
      For example each employee has to work 160 hours per month and if they have only worked 140 then the next months total should read 180 and the totals use the 180 rather than the 160.
      I am struggling to find out how to do this any help would be really appreciated
      as this solution is amazing and just what i needed but just needs that last tweak to make it work for me

  • @terencealmeida4594
    @terencealmeida4594 4 роки тому

    Thanks Ruth, I have prepared the app, but can you help me here the date and time when selected in power app does not match with the date and time reflecting in share point when a new entry is submitted.

  • @NirRobinson
    @NirRobinson 5 років тому

    Great!!
    Right on time 😊

  • @AnOAPHorde
    @AnOAPHorde 4 роки тому

    Hi,
    Thank you so much for this tutorial, however I am having some issues finding the calendar information that you mentioned. Do you have a link to this?
    Thank you,

    • @semfredmartinez2912
      @semfredmartinez2912 3 роки тому

      Did you find it? Hi @curbal I am stock with the calendar. May I request for it?

    • @peircingblueeyes
      @peircingblueeyes 2 роки тому

      @@semfredmartinez2912 i AM STUCK TOO

  • @epiccipe3061
    @epiccipe3061 7 місяців тому

    Can you make a tutorial for an app that can track employees breaks, employees can click on break button also see how much break is pending and manager can view which employee is currently on a break also approve break requests ?

  • @mountainmonk2
    @mountainmonk2 4 роки тому

    This is amazing !! thanks a lot

  • @abhiramikarthikeyan6200
    @abhiramikarthikeyan6200 4 роки тому

    Great Job. I am facing issue when i use power apps inside power bi. I am unable to see the two tab " Choose App and Create App" . Do we have any access restrictions ? Could you please help me with that ?

  • @MoonlightSecret1
    @MoonlightSecret1 4 роки тому

    Saving my life at work right now. Thank you!! Question: Is there a way to restrict Resource Name to members of the team/group only (as opposed to the whole environment)?

    • @CurbalEN
      @CurbalEN  4 роки тому

      In sharepoint?

    • @MoonlightSecret1
      @MoonlightSecret1 4 роки тому

      @@CurbalEN Thank you for your reply. Yes, in SharePoint. We have a big environment with a lot of smaller teams. So I wanted to restricted to just my team. But doesn't seem like I'm able to. I'm also unable to access the User Information List, but the PowerApp definitely has potential to solve our time tracking frustrations, THANK YOU!

    • @CurbalEN
      @CurbalEN  4 роки тому

      There are always ways to solve the issue, it all depends on your requirements. Would you mind posting on the powerapps community? Make sure you provide as many details as possible to get quick help.

  • @ptu1969
    @ptu1969 3 роки тому

    Thank you!

  • @JavierSanchez-co6gn
    @JavierSanchez-co6gn 3 роки тому

    Ruth hi, thanks for that awesome video. I do have a question for you though. I have an education 365 tenant, do I need to buy PowerBi license for this?

    • @CurbalEN
      @CurbalEN  3 роки тому +1

      If you are going to share the report with others, you need a license.

    • @JavierSanchez-co6gn
      @JavierSanchez-co6gn 3 роки тому

      @@CurbalEN do you know if a free one will do it? Though I think A1 do not include power bi

    • @JavierSanchez-co6gn
      @JavierSanchez-co6gn 3 роки тому

      Or else, how would I export weekly reports to excel?

    • @CurbalEN
      @CurbalEN  3 роки тому

      I dont think so..

    • @CurbalEN
      @CurbalEN  3 роки тому

      You can use R, dax studio:
      ChNtb2JpbGUtZ3dzLXdpei1zZXJwEAMyBAgAEA0yBAgAEA0yBggAEA0QHjIICAAQDRAFEB4yCAgAEA0QBRAeMgYIABANEB4yBQgAEIYDMgcIIRAKEKABOgQIABBHUNgOWKsRYJ8TaABwAXgAgAGZAogBmQKSAQMyLTGYAQCgAQHIAQjAAQE&sclient=mobile-gws-wiz-serp

  • @amarsodhi
    @amarsodhi 4 роки тому

    Hi Ruth, I didn't find powerapps plugin in the marketplace, any idea or anything else I can use instead?

    • @CurbalEN
      @CurbalEN  4 роки тому

      It is now built in power bi , dont need to install it.
      /Ruth

    • @amarsodhi
      @amarsodhi 4 роки тому

      @@CurbalEN thanks, I will check.

  • @rawadnasser474
    @rawadnasser474 4 роки тому

    Hello dear Thank you for this useful video,
    Kindly I would like to ask is it right that I can not give access to other users unless I have powerBI pro

  • @carlosalfaro5517
    @carlosalfaro5517 2 роки тому

    Is there an option to upload the list by using a file?

  • @stwilhite1
    @stwilhite1 4 роки тому +1

    Great video! I got it to work, just like you explained in the tutorial, and that never happens! Question though; how can I prevent other users who enter their time via the PowerApps add-in on Teams? I have a small team of eight employees (summer college scholarship workers actually), and don’t want them to see each other’s time entry. It’s not necessarily private, and maybe not even sensitive, but I do want to put something in place that filters everybody else’s time entry but their own. Any suggestions? Thanks again!

    • @CurbalEN
      @CurbalEN  4 роки тому

      Use row level security in power bi:
      m.ua-cam.com/video/9ap2EBjgRdc/v-deo.html
      /ruth

    • @stwilhite1
      @stwilhite1 4 роки тому

      Curbal Thanks. I’ll give it a try. But keep in mind, I’m talking about when a student worker opens the PowerApps UI tab in Teams so the can enter their time for the day, I’m assuming there will be a longer and longer list of new data cards that contain their co-worker’s time entries too. I haven’t thought about their visibility into a BI dashboard strictly for them, but that’s not a bad idea. Anyway, thanks for the quick reply, and I’ll give the other video my full attention tomorrow when my freshman are painting the baseball outfield wall! Thanks again- Scott

    • @CurbalEN
      @CurbalEN  4 роки тому

      @@stwilhite1 You can search on drop-downs in powerapps I think.. not sure if there is Row level security on powerapps, check on the powerapps community to get expert help!

  •  5 років тому

    Hola Ruth. Muchas gracias por subir este vídeo ha sido super útil. Espero puedas ayudarme con un problema. Al importar los datos de la lista desde Power BI no me aparece la tabla User Information List (ni su equivalente en español). ¿A qué creer que se pueda deber? ¿Cómo podría solucionarlo? ¡Gracias mil!

    • @CurbalEN
      @CurbalEN  5 років тому

      Hola Angie,
      Pues no se, mejor preguntar en un foro de SharePoint.
      /Ruth

    •  5 років тому

      @@CurbalEN Hola de nuevo. Ya descubrí la solución. Para que salga la información de la lista de usuarios es necesario que tu seas el creador del equipo en Teams. Saludos. Gracias por todos tus aportes. Seguiré al tanto de tus videos.

    • @CurbalEN
      @CurbalEN  5 років тому +1

      Perfecto y muchas gracias por compartir la solución!
      /Ruth

  • @yanshymshilashvili8560
    @yanshymshilashvili8560 2 роки тому

    Hi, very cool video. But person peacker doesn´t work at all. If I click on it it shows only item 1, item 2.... there are no users in the list and no results if searching. I had to delete the app. Then I created a new one. it worked. But two days later i have the same issue. Do you have some information about that bug?

  • @Menixhunterz
    @Menixhunterz 4 роки тому

    Hi Ruth
    Finally our governmental organization here in DK aired the 365 solution. I've managed to accomplish all of your steps in this guide, but I've encountered one problem: When entering data through the power app in Teams, the date reported back to me in Power BI is one day behind.
    For example: I choose 8. december (today) and click enter in the power app. Then, when visiting power bi, I see that the entry is now registered on the 7. december. I'm using your calendar but can't seem to find the error related to this?
    Hope to hear from from you!

    • @CurbalEN
      @CurbalEN  4 роки тому

      And the dates are ok on sharepoint?
      Difficult to tell without seeing the data, but if the issue is consistent then you can always add a day on power bi and that should solve it.

    • @gachaizzy1454
      @gachaizzy1454 3 роки тому

      @@CurbalEN I had the same sort of issue and all dates in sharepoint were correct. I had to add the hours and minutes to the PowerApp for the start of the shift to resolve this issue
      I dont know exactly why it was pulling the wrong date but this resolved the issue for me

    • @CurbalEN
      @CurbalEN  3 роки тому

      It was the same for me. I could easily solve it by adding a day. Probably it has to to with timezones and UTC times?

  • @realmcafee
    @realmcafee 3 роки тому

    can i access the timestamps or call history of one or all employer? with graph, i dont manage to find a solution

  • @scotchbonnetracing
    @scotchbonnetracing 2 роки тому

    I found the calendar. It is in the Community downloads but search didn't find it. Go to page 2 of the list and its there.

  • @komalpagare961
    @komalpagare961 4 роки тому +1

    how to autopulate logged in user some of the fields in the form so that use need not enter it every time

  • @rajashahzad2613
    @rajashahzad2613 4 роки тому

    Hi, I have connected the power-apps successfully with teams but in need to show/display the description/detail on the same screen instead of right arrow option. Is there any way ?

  • @pabeader1941
    @pabeader1941 5 років тому

    I can't seem to find the links you mention in the video. I'm most interested in the calendar link you mention.

    • @CurbalEN
      @CurbalEN  5 років тому +1

      Here it is:
      curbal.com/donwload-center
      I don’t have direct link to individual files though.
      /Ruth

  • @scottng8171
    @scottng8171 3 роки тому

    Hi, that is a good tutorial, but i feels like want to simplified the things. I want to make it like the Task from outlook, the problem with Outlook task is that it don't record completion time of the task but only date.
    I want to make it as my team to just tick complete of the task, then it records the completion time and date of the task. I want it that they don't need to manually input the completion date and time, which users can put whatever date and time they want.
    I am still very unfamiliar how this all Power Apps works

  • @gustavodalpai4293
    @gustavodalpai4293 5 років тому

    Hello Ruth, I loved the solution and I want to try here where I work. However, I have some doubts:
    1) Before "submit item", is it possible to have a window for review? It would be interesting if the user could confirm what he typed before sending in order to avoid errors.
    2) Is it possible that "Resource Name" already appears the username, instead of having to type the name and search the mailing list?
    3) Is it possible to block the editing of items? My co-worker added an item, but I can edit it normally. Just as he can edit my items.

    • @CurbalEN
      @CurbalEN  5 років тому +1

      Hi,
      I am almost sure all those things are possible, but I have never done them myself.
      I recommend you to try the powerapps and SharePoint forums to get them answered!
      /Ruth

    • @gustavodalpai4293
      @gustavodalpai4293 5 років тому

      Thanks for the quick response @@CurbalEN. I found that for 2 I can use the "Created by" column in the list. For 1, a workaround would be to modify the powerapps interface to show the activity name + date + resource name + time. But 3 remains a mystery to me. Even so, thanks for the video = D

    • @CurbalEN
      @CurbalEN  5 років тому

      Yey!!
      To block editing, can you just delete the edit screen in the app? That should do it!
      /Ruth

  • @semfredmartinez2912
    @semfredmartinez2912 3 роки тому

    Hi May I request the Calendar_PowerBi? please master

  • @mustafahussainmohsin320
    @mustafahussainmohsin320 4 роки тому

    Miss, your video is so awesome, I am impressed with the integrated power of SharePoint and Powerapps.
    But I need your little help in an app, I want to create a "Activity Time Log" for our company, in which we have to type in the tasks from 9:00 AM to 5:30 PM, (Office Hours) and just like that you did some other informations.
    I am confused how can I make this time time Static on each row,
    like:
    User | Date | TimeSlot | Task
    UserX | 3/4/2020 | 9:00 AM | PowerApp Learning
    UserX1 | 3/4/2020 | 9:30 AM | Power Bi Learning. and so On..
    can you help me in this? would appreciate it.
    @Curbal

    • @asifkhawaja
      @asifkhawaja 4 роки тому

      Watch this: ua-cam.com/video/6DjGvzd2CKA/v-deo.html

  • @juansepowerplatform
    @juansepowerplatform 5 років тому +1

    Great, why spend thousands of dollars implementing other solutions when this will do. Thank you

    • @CurbalEN
      @CurbalEN  5 років тому

      ...in just about 20 min ;)
      /Ruth

  • @Deadpool12353
    @Deadpool12353 5 років тому

    Sharepoint and powerapps relationship isnt very good either..we hope to see lots of improvement there.

    • @CurbalEN
      @CurbalEN  5 років тому

      PowerApps is even newer that Power BI so it will take them some time..
      /Ruth