Announcements
Good Morning Everyone,
I am having an issue with my app that tracks time spent on various projects for my company. I have 2 Sharepoint lists - one that lists all the projects (Projects) being worked on and that is synced to my first gallery, and the other list (Project Time System) which is basically a spreadsheet showing who worked on which project and when - when the user selects one of the fields from gallery linked to "Projects" - I would like to have another gallery that associates the names of the employees working on the specified project - which I will then have a display form or something else that shows the employee's total number of hours worked on the project and other information - This app will be used by supervisors so they are able to keep track of all projects and time spent on them. I have tried everything from filtering to searching to lookup - all to no success. Any push in a direction would be appreciated.
Hi!
Can you be more specific about the problems you are facing? Ts the problem that the second gallery doesn´t show the correct records?
//Pontus
Sorry, first time posting - The gallery is not showing any records at all -
Filter('Project Time System', Title = ProjectGallery.Selected.Title) (on "Items" on screen that should show employees) - Title is the field name on 'Projects' Sharepoint List (Didn't rename yet) - Is it possibly because of the condition? I feel like it's not right.
No problem!
First of all, I usually use a variable to save the selection...think it´s easier. I.e Set(SelectedProject,ThisItem.Title).
Second, is "Title" the name of the field in Project Time System as well? That´s the key? If yes, this formula should work:
Filter('Project Time System', Title = SelectedProject)
BR
Pontus
The name of person who made the time entry is the 'key' (first field) in Project time system - I see what you are doing with the variable - I was defining mine wrong - However in 'Project Time System' - the 'key' is 'Name' (name of employee who made the entry) and 'Project' is the name of the field that holds the project name
Ok, so if field 'Project' in 'Project Time System' is the same as 'Title' in 'Projects', I.e the link between these lists....shouldn´t the formula be like this:
Filter('Project Time System',Project = SelectedProject)
I was trying that earlier - it's throwing 'invalid argument type' on the '=' in the condition - Maybe because the project name isn't the key in Project Time System?
I dont think that it should matter. However, I found another thread where others had similar problem: https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/suddenly-Invalid-argument/td-p/2702. Seems like the solution could be to add .Value in the argument. Seems to be a known issue for SP lists. New formula:
Filter('Project Time System',Project.Value = SelectedProject)
YES! It appears that was the only combination in filter I didn't try - You, my friend, are a rockstar!
Perfect! Glad I could help 🙂
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 936
Valantis 604
11manish 518
