Hello-
We have a requirement to create a platform for business users where they need to authenticate first then would submit input as questions and based on selections the progress will be shown and on submit they will be getting a score based on the choice of selection, there would be decisioning criteria and match our internal systems like dataverse also store the responses and sent to azure for power BI requirement. We need to ensure good user experience and can also authentication and security.
My Understanding :
This can be done as follows.
1. Create a page in Power pages with a sign up / login page.
2. Use AD for authentication of these users. Not sure if an app registration is required by power pages ?
3. Then we will show progress and score based on logic or rules set in powerpage or power automate.
4. Store responses in a new table in dataverse.
5. Use dataverse to match the for existing customers.
6. Perform decisions using power automate or power pages custom code ?
7. Dataverse to azure datalake copy data using Synapse link or ADF ?
8. Then connect power BI to databricks unity catalog.
Is that the right understanding ? Could you provide detail of these steps for documentation in detail level.
Thank you
Sourav