Filter Many to Many

(0) Share

Report

Posted on by iwonder

1,142

Thank you for taking the time to read my question.

I have 2 tables related as n:n

'Scheduler Tasks'

'Scheduler Resources'

I want to show all the tasks related to a resource. I select a resource from a drop down box.

So far I can't seem to accomplish this. I thought I should be able to use dot notation to refer to the Resources...

'Scheduler Tasks'.'Scheduler Resources'.Name but this is not the case. I'm also not able to return the GUID which is what I think I'm supposed to be doing.

Here is an example of what I'm trying

With({tRez:LookUp('Scheduler Resources',Name = cboResources.Selected.tnca_name,'Scheduler Resource')},
Filter('Scheduler Tasks','Scheduler Tasks'.*Thought I would be able to select Resources here* = tRez)
)

Any help is greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Gochix 1,935 Moderator on at

Like (0)

Report
@iwonder ,

Correct me if I'm wrong. You want to do the following I believe?
Display all the tasks from 'Scheduler Tasks' where tRez value matches.

In this case you would need to have a column with the "Scheduler Resource" in "Scheduler Tasks" or any other column where this value is matching.

With({tRez:LookUp('test1',Name = Dropdown3.Selected.Value,resource)}, Filter(test2,resource = tRez))

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
iwonder 1,142 on at

Like (0)

Report

Hi Gochix.

Thank you very much for your reply.

The tables have a many to many relationship. So I was thinking that there must be a way to filter 'Scheduler Tasks' by a resource as 'Scheduler Resources' is related.

So I think the field is there, I just don't know which one or how to reference it.

Was this reply helpful? Yes No