Power Apps Exchange

Hi there,

We have a use case where the Sales team needs an app that they can lookup data from a SQL Azure database when working at different client sites in offline mode. The SQL Azure database stores hundreds of thousands of data in multiple tables. My thought process is to have the data from these various tables populate approximately 6-8 dropdown controls in the app to filter results that the salesperson can view. There is no requirement to add/edit/delete data. The second screen would contain a collection of results from the lookup screen. From that collection, a third screen would contain data for selected item that includes full details of the item showing all the SQL fields that pull from a different table.

Summary:

• Screen one. Filters

• Screen two. Gallery

• Screen three. Details.

Again, the requirement is that this is available in the local offline cache / offline mode as salepeople may not always be connected to WiFi. 

------------------------------
Beth Beck
O365 Business Analyst
Fort Myers FL
------------------------------

Power Apps used offline as you indicated might be the case for sales peoples can use two functions: SaveData and LoadData.  LoadData cannot access an online source, even if there were internet access; iit can only load data saved with SaveData.  Your app would have to be constructed such that a salesperson, while connected to the Azure instance, would have to get at least the primary collection of results, save it, then rely on running the app subsequently with a LoadData function.

Certainly for a smartphone this won't accomodate hunndreds of thousands of records, so hence the need to filter them down before saving a workable sized subset.

You can also construct the app to distinguish between connect and offline modes.  If connected, then skip LoadData and get results from SQL otherwise do a LoadData to get saved results.  I would also add logic to validate if there is good SaveData values as a user might not realize that the app is suddenly running offline.

Hi there,

We have a use case where the Sales team needs an app that they can lookup data from a SQL Azure database when working at different client sites in offline mode. The SQL Azure database stores hundreds of thousands of data in multiple tables. My thought process is to have the data from these various tables populate approximately 6-8 dropdown controls in the app to filter results that the salesperson can view. There is no requirement to add/edit/delete data. The second screen would contain a collection of results from the lookup screen. From that collection, a third screen would contain data for selected item that includes full details of the item showing all the SQL fields that pull from a different table.

Summary:

• Screen one. Filters

• Screen two. Gallery

• Screen three. Details.

Again, the requirement is that this is available in the local offline cache / offline mode as salepeople may not always be connected to WiFi. 

------------------------------
Beth Beck
O365 Business Analyst
Fort Myers FL
------------------------------