Seeking feedback - Order Exception handling workflow with Power BI + Power Automate + ?

Hi NL_cAK25,

Thank you for your question on the Microsoft Fabric Community Forum.

We appreciate you sharing your workflow and explaining it in detail. You have done a great job setting up Power BI and Power Automate.

From what I understand, the main problem is that SharePoint Lists are not good for handling large amounts of data. They work well for small team collaboration but get slow and hard to use when there are more than 1,000 rows. Also, it is difficult to make batch edits, which makes it tough for the Operations team.

Here is a better and more efficient way to handle the Order Exception process and solve the problems with SharePoint Lists, while reducing manual work:

1. Use Dataverse to store the exception data through Power Automate.
2. Build a Power Apps canvas app connected to Dataverse so the Operations team can easily filter, review, and give feedback.
3. Connect Dataverse to Power BI using DirectQuery or Dataflows for real-time data updates.

This setup will allow faster data entry and updates, work better with large datasets, and provide role-based access and audit logs.

For your reference, kindly review the following links:
What is Microsoft Dataverse? - Power Apps | Microsoft Learn
Link your Dataverse environment to Microsoft Fabric and unlock deep insights - Power Apps | Microsoft Learn
Use data operations in Power Automate - Power Automate | Microsoft Learn
Create and manage environments in the Power Platform admin center - Power Platform | Microsoft Learn

If you find our response helpful, please mark it as the accepted solution and provide kudos. This will assist other community members who may have similar queries.

Should you have any further questions, please feel free to reach out to the Microsoft Fabric community.

Thank you.