Hi, I am new to power apps so hopefully this will make sense and you guys will be able to help.
I want to create a Timesheet Form app that will take data from one SharePoint list and submit it into the other.
I have 2 lists, 'Job Progress Tracker' and 'Timesheet'. 'Job Progress Tracker' basically our sales order processing with columns for Job number, order number, part number, quantities, progress and assigned to, along with other information.
For each job I want to record the hours worked on each part in the 'Timesheet' list, via a form recording the following info:
- User - default to current user - Done
- Date - default to today date - Done
- Job - Pulldown
- Part no. - Pulldown
- Hours - Input
For the Job pulldown, I would like to filter to only "In Progress" jobs ('Progress'='In Progress') and jobs assigned to that user ( 'Category0'=User).
For the Part no pulldown, I would like to filter the list of part numbers to those of the selected job number.
Hope you can help.