I have an application I built where I am using the deep linking function.
I originally was using SharePoint as a data source, but have recently moved over to SQL. When doing so I have experienced an issue with the form when the user is directed there. For some reason, it keeps getting stuck on "Getting your data." I'm assuming this is something pretty simple that I'm overlooking, but wanted to know if someone could help out.
For the Items property of the form I am using the following:
When selecting the Gallery Item:
And for OnStart of the application:
varRecordID <> 0,
Notification_ID = varRecordID
Param("ScreenName") = "TestScreen",
Hi @cperry07 ,
Try changing the items property of the form to your varRecord variable.
It looks to me like you've already set the variable to the record via the on start or gallery selected item functions so there's no need to look it up again.
Only other thought is that you have multiple records in your variable when a deep link is used.
I.e. You might have duplicate values in you SQL Notification_ID column.
Does it work when navigating from a gallery selection where the varRecord is set to ThisItem?
If it does then check the variable to make sure it has a single record when using a deep link or Try adding First(varRecord) to the form items property to test for multiple records.
I haven't used the SQL connector before so if that doesn't work then hopefully someone else who has SQL experience can assist.
To diagnose this further, here are a couple of things that I would try. If you add a label and set the text property to the following, does it display the correct notification ID?
Also, if you were to set the items property of the form so that it looks up the record based on the record ID variable, does your form still get stuck on "Getting your data."?