App Architecture - Any suggestions

Question

Hey Folks,
We are developing an app using which:

1. Flow reports for KPIs should be triggered at regular intervals.
2. Users accessing the flow reports should be tracked for analytics.

Anyone here has suggestions on what kind of architecture to follow. I had the following approach in mind.

Approach #1:
1. Generate flow reports through Power Automate.
2. Create a one click link in the flow report email for users to click.
3. Upload the user click info to Kusto database.
4. Use app(thinking of Power BI app) to pull user click data from Kusto database to show the analytics. 

Approach #2(Could be):
1. Generate flow reports from Azure App(need to explore more, any suggestion?).
2. Create a one click link in the flow report email for users to click.
3. Upload the user click info to  SQL database.
4. Use Azure App to pull flow report user click data from SQL database to show the analytics. 

Thanks
Monisha

  





 





1.	Flow Reports should have a user receipt link.
2.	The link should be a one click link at the bottom of the email, likely, so that users might have read content at the end of the email.
3.	The user click data should be uploaded to a database.
4.	User data should be fetched by app to build analytics. 

Answer 1

Thanks for question! Your Approach #1 seems to be more towards power automation for Approach #2 you can use Azure function that will trigger as per schedule to get the reporting data from their API.