Is there a way to create a delegatable filter in some way that does the following?
Filter(task_list, 'phase_list:ID'= _task_id ) Filter(task_list, 'phase_list: phase_number'= _phase_number )
So, there's a sharepoint list called task list with a relationship to a phase list and has the phase_list as a foreign key to task_list.
The phase_list becomes a lookup column with additional fields that are populated by sharepoint to have the ID and phase_number.
So in addition to the regular fields in task_list: there is a "phase_list", "phase_list:ID" and "phase_list: phase_number".
All of them being lookups from the phase_list and phase_list respective fields
Is there a way to make the filter function above, delegatable as:
Filter(task_list, phase_list.Id = _phase_number)
does not appear to be.
Thank you for your posts, so there is no way to delegate records based on foreign key ids as of right now?
One workaround I'm considering is adding a Microsoft flow to each table that triggers whenever a row is added or modified such that the foreign key references, the foreign key id is written to a regular number field.
For instance if Tasks, has a phases lookup column, there will be a regular number field that gets Phases.ID and writes it to this number field. Not sure about performance considerations/consistency as powerapps may not be aware of the changes.
Does filter always call Sharepoint or does it use a cache? So if I have a delegateable query, then will it get fresh information on what I need?