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
Filter('[dbo].[Signature]',FK_FacilityInspectionId=Value(Param("InspectionId"))).
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:
What I think is happening
I'm at a loss as to what it might be that's preventing the signatures from loading based of my passed parameter.
Solved! Go to Solution.
Well.. how humbling.
It turns out that I solved this myself and the reason the problem happened was that I made a silly mistake in not capitalizing the foriegn key in the param lookup. I mistakenly assumed that Param("InspectionID") was the same as Param("InspectionId"). Once I capitalized it the problem went away.
Well.. how humbling.
It turns out that I solved this myself and the reason the problem happened was that I made a silly mistake in not capitalizing the foriegn key in the param lookup. I mistakenly assumed that Param("InspectionID") was the same as Param("InspectionId"). Once I capitalized it the problem went away.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
190 | |
53 | |
51 | |
35 | |
33 |
User | Count |
---|---|
268 | |
92 | |
80 | |
68 | |
67 |