I am currently trying to build a Timesheet PowerApp. The aim is to allow users to record time spent against each project they work on.
I want to filter a ComboBox based on information from a different Sharepoint List.
Details...
I have a SharePoint List where the data is written to. Let's call this 'Timesheet List'. This includes the following columns:
- Week Start (Date)
- Employee (Text)
- Project Name (Look Up)
- A row for each day of the week (For hours spent) (Number)
- Total Hours Spent (Number)
There's a completely separate SharePoint List called 'Projects'.
- Project Name (Text)
- Status (Choice)
My Timesheet List uses a LookUp to pull the Project names from the Projects List. This way (in theory) the app always stays up to day with the list of current projects.
The Project list also has a column marking if the project status is Live or Ended.
My PowerApp has a combobox referencing the LookUp column in 'Timesheet List'. This works fine - however I'd ideally like to be filtered, based on the 'Project' list's project status column.
Is this possible, and if so... how?
