02-12-2020 04:49 AM
First of all, Great place to seek inspiration from all the different PowerApp projects. Hopefully my project will bring some inspiration back!
The purpose with my project is to create a simple, userfriendly planning tool for rigs and vessels.
Here are a list of components used in my project:
- Azure SQL (direct query / live connection)
To secure good performance are all calculations programmed in stored procedures and functions in the database.
I have also implemented Row level sequrity (RLS) for securing data, but this is also positive for the performance.
- Power Platform:
PowerBI report w/embedded PowerApp. For interaction with the PowerApp I use PowerBIIntegration.Data and PowerBIIntegration.Refresh.
Flow is used to trigger different stored-procedures (calculations) in the SQL DB.
I also created a .Net Core Web Application where the tool is embedded using Iframe.
The next release of the tool will include a route map (timelapse) to illustrate future rig/vessel moves.
Due to the setup with SQL DB and RLS, the tool is not easy to publish here in this forum. I will try to create a duplicate where i use "dummydata" in .xls instead of SQL, but since all calculations is built in the back-end, the main functions will not work.
Hopefully someone will find inspiration in the video of the app.
Dag Andre Pell