Hello all,
I am using deep linking, when i click the link i generate from flow that has my param. I am navigated to the correct screen so i got all the "App OnStart" code working. In the OnStart, i set the record to a variable by doing a lookup to the sql table equaling the param. So i have a form on the screen the user is navigated too and some fields are missing values and some are not. Why is this ? i need those fields values. Any help is appreciated.
Thanks
Hi @mmattar ,
Could you please show more details about the formula you typed within the OnStart property of App?
Could you please share a bit more about the Parameter value you passed to your canvas app from the deep link?
Based on the needs that you mentioned, I think it is not necessary to store the retrieve record value into a variable, you just need to store the parameter value into a variable. I assume that you specify the PrimaryColumn value as parameter value within the deep link, so your embedded deep link would look like this:
https://apps.powerapps.com/play/18d2e0dd-50e9-43e0-aeac-3feb321972c3?tenantId=xxxxxxxx-f6a5-41a2-xxxx-9785a9d6c706&PrimaryColumn=SpecificPrimaryColumnValue
Then within the OnStart property of App, please type the following formula:
Set(PrimaryColumnValue, Param("PrimaryColumn"));
Navigate(TargetScreen)
Within the Target screen, bind the Edit form to your SQL Table ('[dbo].[YourSQLTable]'), then set the Item property of the Edit form to following:
LookUp('[dbo].[SQLTable]', PrimaryColumn = PrimaryColumnValue)
Please check and see if my response within the following thread would help in your scenario:
Best regards,
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2