@v-monli-msft
Please find below the code I am using, it is in the OnStart of my app. I do want to emphasize this seems to be working for Varchars, Date & Times. Once I initially load the data, I go offline and see all that data, just not the pictures, which are VarBinary(MAX).
If(Connection.Connected,
//if it is connected clearCollect the collections and save the data locally
ClearCollect(collectionOne, Filter('[dbo].[collectionOne]', conferenceId = varconferenceID));
ClearCollect(collectionTwo, Filter('[dbo].[collectionTwo]', conferenceId = varconferenceID, isDisabled = false ));
ClearCollect(collectionThree, Filter('[dbo].[collectionThree]', conferenceId = varconferenceID, isDisabled = false ));
ClearCollect(collectionFour, Filter('[dbo].[collectionFour]', conferenceId = varconferenceID, isDisabled = false));
ClearCollect(collectionFive, Filter('[dbo].[collectionFive]', conferenceId = varconferenceID, isDisabled = false));
ClearCollect(collectionSix, Filter('[dbo].[collectionSix]', conferenceId = varconferenceID, isDisabled = false));
ClearCollect(collectionSeven, Filter('[dbo].[collectionSeven]', conferenceId = varconferenceID));
ClearCollect(collectionEight, Filter('[dbo].[collectionEight]', conferenceId = varconferenceID));
ClearCollect(collectionNine, Filter('[dbo].[collectionNine]', conferenceId = varconferenceID));
SaveData(collectionOne, "collectionOne");
SaveData(collectionTwo, "collectionTwo");
SaveData(collectionThree, "collectionThree");
SaveData(collectionFour, "collectionFour");
SaveData(collectionFive, "collectionFive");
SaveData(collectionSix, "collectionSix");
SaveData(collectionSeven, "collectionSeven");
SaveData(collectionEight, "collectionEight"),
//if the app is not connected, load what ever data is stored locally in the app
Clear(collectionOne);
Clear(collectionTwo);
Clear(collectionThree);
Clear(collectionFour);
Clear(collectionFive);
Clear(collectionSix);
Clear(collectionSeven);
Clear(collectionEight);
LoadData(collectionOne, "collectionOne", true);
LoadData(collectionTwo, "collectionTwo", true);
LoadData(collectionThree, "collectionThree", true);
LoadData(collectionFour, "collectionFour", true);
LoadData(collectionFive, "collectionFive", true);
LoadData(collectionSix, "collectionSix", true);
LoadData(collectionSeven, "collectionSeven", true);
LoadData(collectionEight, "collectionEight", true));
