Gallery to display data from multiple records

(0) Share

Report

Posted on by Pathum1

I've got a Canvas app which is connected to three Sharepoint Lists.

1) Occurrences

2) Hazards

3) Risks

A certain event triggers my hazardGallery to be populated with the hazards related to a particular occurrence.

Each hazard has multiple risks related to it. I'm trying to find a way to populate my riskGallery with all the risks that are applicable to all hazards related to a particular occurrence.

My tables are sort of like this.

For example, if I filter my hazard gallery for 22OC01, it shows 22HAZ01, 22HAZ03 and 22HAZ04. I need to filter my risk gallery with the risks associated to the above three hazards. The risk gallery SHOULD show details of 22Ri01, 22Ri02, 22Ri07, 22Ri03, 22Ri06.

Some help would be appreciated greatly.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-liwei-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Pathum1

Could you please tell me:

Do you want to enter the OccID through a control like TextInput to display the hazardID in the hazard gallery?
Then filter the riskID of the risk gallery based on the hazardID displayed by the hazard gallery?

I have made a test for your referene:

1.

2.

Filter(Hazard,HazardID in ForAll(Filter(occurrence,OccID=TextInput1.Text),HazardID))

3.

Filter(Risk,HazardID in ForAll(Filter(Hazard,HazardID in ForAll(Filter(occurrence,OccID=TextInput1.Text),HazardID)),HazardID))

Best Regards,

Levi
Pathum1 29 on at

Like
a
(0)

Report
Copy link

Link copied!
The code you've shown sort of gave me an idea and I redid it this way. The below works perfectly and does what I need. There is a delegation warning for "in", i'll deal with it later on.
Filter(Risks,RiskID in ForAll(Hazards, LookUp(Hazards, RiskID = RiskID, RiskID)))
Pathum1 29 on at

Like
a
(0)

Report
Copy link

Link copied!
The code you've shown sort of gave me an idea and I redid it this way. The below works perfectly and does what I need. There is a delegation warning for "in", i'll deal with it later on.
Filter(Risks,RiskID in ForAll(Hazards, LookUp(Hazards, RiskID = RiskID, RiskID)))