Это видео недоступно.
Сожалеем об этом.
Time tracking solution ⏱ in Teams with PowerApps and Power BI
HTML-код
- Опубликовано: 2 авг 2024
- In this video I am going to show you how you can create a time track app in 20 minutes using MS Teams, Sharepoint, PowerApps and Power BI.
That is why the call it the power platform ;)
#curbal #powerapps #msteams #sharepoint
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
www.amazon.com/shop/curbal
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#SUBSCRIBE #CURBAL
Hi Ruth, Love the quick solution!
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
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!
The enthusiasm is infectious. Thank you, Ruth.
I had a lot of fun doing that video :)
/Ruth
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.
Simple yet so POWERFUL! Thanks, Ruth!
Exactly! Mind-blowing!
/Ruth
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)
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
I appreciate the 20 minutes, and the enthusiasm. I wouldn't have minded a bit slower with out feeling the time pressure.
You can slow down a youtube video if the pace is too fast:)
Really enjoyed that Ruth.....so simple. Will definitely be using this
Complete madness that it is so simple... the integration between power apps and SharePoint is simply outstanding! Blew my mind 😳
/Ruth
That's exactly the app that I'm finding, well done!
Awesome!!
This is amazing !! thanks a lot
Nice video! Thank you Ruth!
Great effort in less than 20 minutes.
Amazon, isnt it?
/Ruth
Thank you!
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.
Great!!
Right on time 😊
;)
/Ruth
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.
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 ?
Ruth, that's great business solution
Thanks Vida! :)
/Ruth
thanks very helpful
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
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.
Hi how did you find the powerbi calendar?
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?
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.
Only in power BI with with RLS
and what do you think about cloud Timestatement time tracking and invoicing?
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 ?
Is there an option to upload the list by using a file?
how do I make daily Sing In Sign Out button to trigger email and use power BI for weekly report later?
can i access the timestamps or call history of one or all employer? with graph, i dont manage to find a solution
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?
Hi Luis,
What do you mean with ”time series” option? This one?
m.ruclips.net/video/d4yAzhIQqNk/видео.html
/Ruth
Thanks for the great video.
I would be very interested in what the World Cup 2018 Report shows and how you built it.
Will do a new football report soon :)
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?
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
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)?
In sharepoint?
@@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!
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.
I can't seem to find the links you mention in the video. I'm most interested in the calendar link you mention.
Here it is:
curbal.com/donwload-center
I don’t have direct link to individual files though.
/Ruth
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
Did anyone ever find the calendar in community downloads??
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,
Did you find it? Hi @curbal I am stock with the calendar. May I request for it?
@@semfredmartinez2912 i AM STUCK TOO
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?
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.
I literally love your enthusiasm. Unfortunately I can't find the calendar download. Can you assist?
Hi Jörg,
It is on the download center, community downloads. Search by calendar.
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!
Use row level security in power bi:
m.ruclips.net/video/9ap2EBjgRdc/видео.html
/ruth
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
@@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!
how to autopulate logged in user some of the fields in the form so that use need not enter it every time
I was going to ask the same question
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 ?
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!
Hola Angie,
Pues no se, mejor preguntar en un foro de SharePoint.
/Ruth
@@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.
Perfecto y muchas gracias por compartir la solución!
/Ruth
Hi Ruth, I didn't find powerapps plugin in the marketplace, any idea or anything else I can use instead?
It is now built in power bi , dont need to install it.
/Ruth
@@CurbalEN thanks, I will check.
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!
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.
@@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
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?
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?
If you are going to share the report with others, you need a license.
@@CurbalEN do you know if a free one will do it? Though I think A1 do not include power bi
Or else, how would I export weekly reports to excel?
I dont think so..
You can use R, dax studio:
ChNtb2JpbGUtZ3dzLXdpei1zZXJwEAMyBAgAEA0yBAgAEA0yBggAEA0QHjIICAAQDRAFEB4yCAgAEA0QBRAeMgYIABANEB4yBQgAEIYDMgcIIRAKEKABOgQIABBHUNgOWKsRYJ8TaABwAXgAgAGZAogBmQKSAQMyLTGYAQCgAQHIAQjAAQE&sclient=mobile-gws-wiz-serp
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
Watch this: ruclips.net/video/6DjGvzd2CKA/видео.html
Hi May I request the Calendar_PowerBi? please master
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.
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
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
Yey!!
To block editing, can you just delete the edit screen in the app? That should do it!
/Ruth
Great, why spend thousands of dollars implementing other solutions when this will do. Thank you
...in just about 20 min ;)
/Ruth
Sharepoint and powerapps relationship isnt very good either..we hope to see lots of improvement there.
PowerApps is even newer that Power BI so it will take them some time..
/Ruth