Hi All
We are currently working on a mobile application which also requires offline use.
Our database is Dataverse.
On the "On Start" of our application, we collect filtered data from our dataverse
ClearCollect(colAllCampaignsStatusMobileInProgress, Filter( Campaigns, 'Campaign Status' = 'Campaign Status Choices'.'Sent to mobile' Or 'Campaign Status' = 'Campaign Status Choices'.'In Progress')), //Filter all campaigns with status "Sent to mobile & in progress
ClearCollect(colCampaignTechniciansEqUserEmail, Filter(Campaigns_Technicians, User().Email = 'Technician Reference ID'.Email) //Filter all campaign_technicians where logged in user is present in the email field
));
ClearCollect(colFilteredCampaigns, Filter(colAllCampaignsStatusMobileInProgress, Campaign in ForAll(colCampaignTechniciansEqUserEmail, 'Campaign Reference ID'.Campaign))) //All campaigns with status 'Sent to Mobile' or 'In Progress' for the logged in user
SO basically,
1. look for campaigns with 2 statusses
2. filter a joined table to see if user().email is present
3. Filter the first collection to only show the campaigns for the logged in user.
On my main screen, i have a gallery (galUserCampaigns) with item property: colFilteredCampaigns
When i go to my second screen, i have gallery (galRelatedBuildings) with item property: galuserCampaigns.selected.Campaign_buildings
I need to display the related buildings to that campaign.
Everything seems to work fine on the desktop, but when i open the same app on the tablet, the second gallery (galRelatedBuildings) just stays completely blank.
Am i doing something wrong here?
I need to work with collections for full offline capabilities, but it's hard to test all of this because when i go to the next gallery on my app, there isn't any data anymore.
Everything keeps working fine otherwise.
Thank you in advance & kind regards