web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

Time Recording App

(0) ShareShare
ReportReport
Posted on by 12

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.

Categories:
I have the same question (0)
  • subsguts Profile Picture
    1,259 Moderator on at

    Hello, you will need to have a more specific question to get an answer.  It appears you are asking for how to design a brand new PowerApp.  That would take hours of time and involve more "consulting" than answering a question.  You should attempt to build the App and then when you run into specific issues folks here will most definitely help you through those road blocks.  

     

    I realize not the answer you wanted, but better someone let's you know that you are asking a question that really is not within the scope of this forum to answer.

     

    I hope you'll give it a shot though as there are lots of videos on how to start building a n App.  Personaly, I would build your SharePoint or other data sources and then create the screens to display your data.  Do it one piece at a time and I'm sure you'll get very far before you have significant issues.

     

    Good luck

  • fm950384 Profile Picture
    12 on at

    Will do, I will start a new question.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard