Thank you for choosing Microsoft Community.
Your understanding of the process is on the right track!
Here’s a detailed breakdown of the steps to create the platform you described:
Create a Page in Power Pages with a Sign Up / Login Page:
Use Power Pages to design a user-friendly sign-up and login page.
Ensure the page is responsive and accessible.
Use Azure AD for Authentication:
App Registration: Yes, you will need to register your app in Azure AD to enable authentication. This involves creating an app registration in the Azure portal and configuring the necessary permissions.
Configure Authentication: Set up Azure AD B2C for user authentication. This allows users to sign up, sign in, and reset passwords securely.
Show Progress and Score Based on Logic or Rules:
Use Power Automate to create workflows that calculate and display progress and scores based on user inputs.
Alternatively, you can implement custom logic directly in Power Pages using JavaScript or Power Fx.
Store Responses in a New Table in Dataverse:
Create a new table in Dataverse to store user responses.
Ensure the table schema matches the data you need to collect.
Use Dataverse to Match Existing Customers:
Implement logic in Power Automate or Power Pages to match user responses with existing customer records in Dataverse.
Use Dataverse’s querying capabilities to find and link relevant records.
Perform Decisions Using Power Automate or Power Pages Custom Code:
Use Power Automate to create decision-making workflows based on user inputs and predefined criteria.
For more complex logic, consider using custom code in Power Pages.
Dataverse to Azure Data Lake Copy Data Using Synapse Link or ADF:
Use Azure Synapse Link or Azure Data Factory (ADF) to copy data from Dataverse to Azure Data Lake.
Configure the data flow to ensure timely and accurate data transfer.
Connect Power BI to Databricks Unity Catalog:
Set up a connection between Power BI and Databricks Unity Catalog to visualize the data.
Ensure that the data model in Power BI is optimized for performance and usability.
By following these steps, you can create a robust platform that ensures good user experience, authentication, and security.
If this fixes the issue, please mark as resolved to help others with find it.
Happy to help
Robu 1
