Mar 31 2020 02:27 AM
Mar 31 2020 06:06 AM
Hi Chris (@Chrisglasg ) yes this would be achievable with SharePoint plus possibly also making use of Power Automate to send you email alerts if a stage is overdue.
Your description says that your app sends files and the form to SharePoint. They would go into a Documents Library. But does/can the app actually send details from the form into SharePoint? It would make it easier if it can do this. For example we use Microsoft Forms for submission of data. A flow in Power Automate triggers when a new form is submitted, sends an acknowledgement email back to the submitter with the details of their responses and saves the details to a list in SharePoint. That list has views for each site and is formatted to show if a submission is due today or is overdue. On the day that a submission is due an email goes to the responsible manager at 08.30 and continues to be sent at 8.30 each day until they have changed the status column of the item to Closed.
You can format the list in SharePoint to show (as in the image below) different sites in different colours. That list also formats the date and status columns so that if the status is changed to closed it immediately changes the background to green. If the due date is today then it changes the background to amber, if it's overdue then it changes the background to red.
So that sort of basic formatting can give you clear visual clues as you would have in a dashboard. There are also more funky things you can do with formatting like display pie charts, although that's using complex JSON formatting on that column.
I'm sure there are lots of other ways of using the column and view formatting features . Or you might find that using Power BI to link to the data in the SharePoint list and create your dashboard is a better solution, particularly if you are needing to do reports.
Hope that helps a bit but come back with any further questions.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Apr 01 2020 03:30 AM
SolutionApr 01 2020 03:30 AM
Solution