I'm building a safety auditing app which uses the SQL Server connector. I pass the ID of a completed inspection to a user in an email via Flow. https://web.powerapps.com/webplayer/app?InspectionID=12&appId=%[intentionally deleted].
The form loads the correct safety inspection off of the FacilityInspection table so I know that the parameter is being read in correctly. Elsewhere on the form I have a gallery for signatures. An inspection can have one or more signatures so it's a separate table. I have a foreign key in SQL set to FK_FacilityInspectionID on my signature table to associate it to the FacilityInspection's ID.
For my gallery of signatures I am attempting to set the items property to
When the email goes to the user it loads the correct inspection on the form, but all the signatures are missing.
What I've tried so far:
- Hardcoding a value into Filter command for the FacilityInspectionId - works and loads the signatures.
- Inserting a label with the value of Value(Param("InspectionId"))) -- works, correctly shows the parameter number. I had to use the Value command because otherwise it complained about a type mismatch.
What I think is happening
- The items property isn't the right place to run my filter command & load the data
- Perhaps the gallery needs its own separate command to query the database first?
I'm at a loss as to what it might be that's preventing the signatures from loading based of my passed parameter.