Solved: Filter form or create a Collection in a Many to Many relationship directly in CANVAS

I am using the Power Apps Canvas app…

I have been searching for an answer (with or without using Filter) for days. Either it’s a brilliant and difficult question, it is an unsolvable problem (is the such a thing?), or I as dumb as a box of rocks! I am hoping it is the first one....

QUESTION:

I have:

FormA with 2 columns

FormB With 1 column

Form A has:

2 Columns Named: CourseID & CourseTitle

It has 4 records in it

CourseID CourseTitle

1 Course One

2 Course Two

3 Course Three

4 Course Four

Form B has:

1 Column Named: CourseID

It has 2 records in it

CourseID

I wish to Create FormC.

FormC will should show only:

one column CourseTitle

with 2 records (the 2 IDs on FormB)

FormC result:

CourseTitle

Course Two

Course Four

FormC should show the CourseTitles (from FormA) but be filtered by only [all] the CourseIDs is present on FormB.

That is to say I wish to Filter FormC to show any and all the Course Titles that correlate to either of the records in FormB.

FormB could be a collection rather than a form but I believe I have the same issue.

For that matter both Forms A&B could be collections with FormC based on the result of the appropriate collection.

Either way, I’m trying to create a data set based on all records from a different data set (aka a Many to Many relationship)

NOTE: I don’t have permissions to use such features as CDS or List Relationships, so please limit any answers to solving this problem using code within the Canvas app (if it is possible!)

Thanks for any and all help!

Categories:

General Questions