Good example of a working app for a common use case! Explained very simply
@DataisKing
Жыл бұрын
Glad you liked it
@md.rafiqulislam2167
Жыл бұрын
Thank you, so many good tips. Concurrent, Sequence, duplicate functionality. This is better than some time entry software I have seen.
@chaithanyaaram3213
Жыл бұрын
Great tutorial for practicing thanks frm India
@ansi2605
Жыл бұрын
Great video. I am following the steps and the app is coming up great did not just get data table connected. i believe you had all the data already added in the table.
@robustbaidya9422
Жыл бұрын
Awesome, this was just what i was looking for. Thank you so much!😘😘😘
@degenerateartensemble5973
Жыл бұрын
Great video!!!! Thanks!
@muhammadrafiqulislam2167
Жыл бұрын
Great video A . I appreciate all the time and effort.
@md.abdulalim9648
Жыл бұрын
This is very helpful. thanks for the tutorial...
@DataisKing
Жыл бұрын
Welcome 😊
@ahjidan5865
Жыл бұрын
Awesome, this was just what i was looking for. Thank you so much!
@janikosta4202
Жыл бұрын
Excellent video, everything I needed and so well explained , thanks a lot for making this one 🙏
@balchandrak1894
Жыл бұрын
good job male, thanks!
@jonrojario2408
Жыл бұрын
Great video. I appreciate all the time and effort.
@yousseflabdi6467
Жыл бұрын
Very helpful thanks
@diparnaadhikary7648
Жыл бұрын
I cannot thank you enough for this! :)
@chancolallvideo
Жыл бұрын
Thank you so much. you are so amazing !!!!!
@DataisKing
Жыл бұрын
You are so welcome!
@ratulsheikh646
Жыл бұрын
Great👌👌
@bharathraj8296
6 ай бұрын
Everything well explained,but how the data is getting saved in SharePoint list using collection is not shown?
@AlonsoParejawee
Жыл бұрын
Amazing job! Thanks! How can we also introduce a selecting of weeks before entering the hours data?
@GarrettEngeset
Жыл бұрын
Is it possible to have lines (3 or more) show up as default? I've noticed that first time users have their gallery blank and have to click add lines to get started. Amazing video!
@DataisKing
Жыл бұрын
Change the code in the Add a Line Button to the code below: Set(TotalLines, TotalLines+3); Collect(TimesheetLines, { LineNumber: TotalLines +3 } );
@DataisKing
Жыл бұрын
Below is the code to the Add a Line Button: Set(TotalLines, TotalLines+1); Collect(TimesheetLines, { LineNumber: TotalLines +1 } );
@diparnaadhikary7648
Жыл бұрын
Hi, How are you sending the data from the powerapps to the sharepoint?
@DataisKing
Жыл бұрын
@@diparnaadhikary7648 The code below is for the OnSelect Property for the Save Icon Clear(FinalPayrollLines); ForAll( TimeKeeperGallery.AllItems, Collect( FinalPayrollLines, { ClientNo: ClientNameInput.Text, Employee: EmployeeTimeCardDropdown.SelectedText.Value, Supervisor: SupervisorInput.Text, BillTo: BillToDropdown.SelectedText.Value, SatHours: SaturdayHours.Text, SunHours: SundayHours.Text, MonHours: MondayHours.Text, TueHours: TuesdayHours.Text, WedHours: WednesdayHours.Text, ThuHours: ThursdayHours.Text, FriHours: FridayHours.Text, TotalHours: TotalHours.Text, DateTime: Text(Now(),"[$-en-GB]dddd, dd mmm yyyy") } ) ); ForAll( TimeKeeperGallery.AllItems, Patch( tbl_TimeCard, { Title: "Saving a Record", ClientName: ClientNameInput.Text, Employee: EmployeeTimeCardDropdown.SelectedText.Value, Supervisor: SupervisorInput.Text, BillTo: BillToDropdown.SelectedText.Value, SatHours: Value(SaturdayHours.Text), SunHours: Value(SundayHours.Text), MonHours: Value(MondayHours.Text), TueHours: Value(TuesdayHours.Text), WedHours: Value(WednesdayHours.Text), ThuHours: Value(ThursdayHours.Text), FriHours: Value(FridayHours.Text), TotalHours: Value(TotalHours.Text), //Signature: varBlob DateTime: Text(Now(),"[$-en-GB]dddd, dd mmm yyyy") } ) ); Notify("Your data has been saved",NotificationType.Information)
@diparnaadhikary7648
Жыл бұрын
@@DataisKing Thank you, i figured it out later! Happy to see it was the same patch function being used.
@juanhaces3501
5 ай бұрын
Helloooo! i dont see the moment when you create variable for add a line (total Line) can u say me how u created? thank you very much for the video :)
@joebolton3925
Жыл бұрын
Hi, thank you for the tutorials, I am stuck on where the collection of FinalPayrollLines is created? I have it all fine up to the part of the save button, where the 'FinalPayrollLines' isnt showing up as green on my powerapp?
@DataisKing
Жыл бұрын
Can you please send me a screenshot of your app so I can see where the problem is?
@DataisKing
Жыл бұрын
my email is koutlaw30@gmail.com
@johnnykal
10 ай бұрын
When I add new Line to Gallery, thee Total Hours is copied from the line above it and clicking on Reset does not Delete the Total Hours in Line 1
@niravbamrotiya6981
Жыл бұрын
i want to create the same but for month view and also on project wise(alloted to the worker) how to achieve it?
@simranbatada3626
Жыл бұрын
The data that you have used: Employees and Billing. Where can I get it?
@user-fk4yp9th6d
Жыл бұрын
These videos are great, thanks so much! I have created a Timesheet App for my employer. I have a problem though, when I start my App it doesn't show an initial row until I click add a line. Do I need to set a default somewhere?
Thank you for making this tutorial!! Didn't see you creating FinalPayrollLines collecion, but saw you adding it onthe 2nd screen. Is it possible to know how its created please?
@DataisKing
Жыл бұрын
At what time in the video are you talking about?
@frezermulugeta3021
Жыл бұрын
@@DataisKing The time is 22:05, Thank you for getting back to me
@eliashuch71
Жыл бұрын
this is "almost" what I need. Is it possible to make this usable by each individual employee so I can have them report the time rather than me and then have it collected at certain times?
@DataisKing
Жыл бұрын
I don't know what exactly you are wanting. Please explain
@lijunchen
8 ай бұрын
This is a very good tutorial with detailed instructions. I can follow without problem until halfway when the "With" function is used to add up the hours for Total Hours text input. I was told the argument type is invalid in the formula of "with" function. The list of 7 input values MondayHours+TuesdayHours ... are red underlined. It shows their data type as "control" instead of "number". I already set their default values as 0 with number format. I am baffled by this. Can you advice what can be the problem? Thanks.
@DataisKing
8 ай бұрын
Change the format of the textbox to Number
@najeedalshakhshir4959
Ай бұрын
This worked for me: With( { mon: InputHours_Day_1.Text, tue: InputHours_Day_2.Text, wed: InputHours_Day_3.Text, thu: InputHours_Day_4.Text, fri: InputHours_Day_5.Text, sat: InputHours_Day_6.Text, sun: InputHours_Day.Text }, mon+tue+wed+thu+fri+sat )
@john-paulmclaughlin9505
Жыл бұрын
Hello sir, do you have a way to make the saved information page with the data table editable? I know it would need to be changed to a gallery but I would like to allow to be modified when clicked on
@bahabdourahman174
Жыл бұрын
Thank you for this wonderful tutorial, really appreciate it!. Is there any possibility to have my timesheet added lines on the UI, by this I mean if I pick my 3 projects for the week on Monday, I want to have them stay on the UI for the rest of the week, so that when I log in the next day I just need to add my hours or change it and submit to my back end database on Fridays, This may sound basic, but I am curious to know as I am new to power app. Thank you once more for the effort!
@DataisKing
Жыл бұрын
When you save the information in SharePoint, the next time that go to the Timecard screen and search for the Project Name and or Employee Name, the save information will automatically appear. Make sure that you also look at this video because I have made some updates in the past couple of weeks. kzitem.info/news/bejne/kouOmGV9hH99fZw
@michaelpedersen362
2 жыл бұрын
Hi there Data is king i am struggling on how you make that collector for the gallari list. and to see when you make and write that code. is this something that youmaybe could make a video about
@DataisKing
2 жыл бұрын
Hi Michael Petersen, I plan on creating a video this week that will highlight the key things that I covered.
@michaelpedersen362
2 жыл бұрын
@@DataisKing Hi Data. :) That would be awsome. i will be looking forward to this. :)
@DataisKing
Жыл бұрын
@@michaelpedersen362 Make sure that you press the button to create the collection at 07:20
@michaelpedersen362
Жыл бұрын
@@DataisKing hi data. :) yes i think that is where i go wrong because i cant see a collection or find the collection, and i cant seem to find where i go wrong. :/
@john-paulmclaughlin9505
Жыл бұрын
Hello, if you did this on Dataverse instead of sharepoint, would the code for the save icon be much different?
@DataisKing
Жыл бұрын
Not different at all
@robertpietrobono13
Жыл бұрын
I'm not understanding how the data gets saved to a sharepoint list? Where is that link / connection built?
where have i gone wrong in gallery? i have not added the dropdowns as I don't need them, but when i play the app i cant see the gallery to edit the hours.
@DataisKing
Жыл бұрын
@user-el2ug6zl7m. Can you email me a screenshot of your app? My email is koutlaw30@gmail.com
from the above code posted. In Patch function if we provide the table name and column won't the system save the values. What is the purpose of having this line "ForAll( TimeKeeperGallery.AllItems,"
@DataisKing
Жыл бұрын
@@rarun0080 The purpose of the ForAll is to save all of the rows that are in the gallery to the Data Source which is SharePoint in this example
@poonamdabas289
Жыл бұрын
Can you help me in adding one more columns thats defines the tasks done , how to write that code
@DataisKing
Жыл бұрын
I need more information on what you are trying to do
@poonamdabas289
Жыл бұрын
@@DataisKing actually i have to show ,, what type of work is done by an employee in a week ,, three types of work are there ,,project, non project and training ... i want to know how many hours in a week an employee work ..i m confused how to create the lists ,,like by following this video ,,there are billing type ,,i want to customise it as work types i.e project or non project ,,but how to create its list in Sharepoint , i dont know that
@DataisKing
Жыл бұрын
@@poonamdabas289 Look at this video kzitem.info/news/bejne/sIqF0KSNi6Sqa44
@poonamdabas289
Жыл бұрын
@@DataisKing thankyou so much , i will try that
@poonamdabas289
Жыл бұрын
@@DataisKing is there any video where i could findout what are the columns name in the Sp lists and how many lists are there in this video?
@DataisKing
Жыл бұрын
Let me know in the comments if you need help building your Timesheet
@poonamdabas289
Жыл бұрын
i need help in building my app
@thrinadhgaddam4274
6 ай бұрын
Yes I need
@elizabethhcariguchi3778
Жыл бұрын
The TimesheetLines Collection that has?
@DataisKing
Жыл бұрын
What is your question?
@elizabethhcariguchi3778
Жыл бұрын
@@DataisKing When I use the TimesheetLines collection in the Gallery, the Dropdowns that are in the Gallery do not appear
@DataisKing
Жыл бұрын
@@elizabethhcariguchi3778 you have to first select inside of the gallery and then insert the dropdowns. I have another video that I posted today that shows this
Пікірлер: 80