Share via

Should I use Microsoft List with PowerAutomate or PowerApps?

Anonymous
2023-11-16T12:13:52+00:00

I work in Procurement and need to confirm the best solution for a particular problem, either Microsoft List with PowerAutomate or PowerApps. We have a list of 100,000 parts with a particular sub category classification we'll call 'Taxonomy Code' and we need the capability for our category team to be able to review and make a mass update request across many parts to correct and reclassify the Taxonomy Code attribute of the part. I'd like for this list to be based on historical data as well as connected to another dataset in case new parts are created. When category managers make change requests, they need to be reviewed and approved (maybe in daily email batches rather than individual email per part change) by the current Director responsible for that part. Also, we want to be able to connect to this updated parts list and Taxonomy code as a table for other analytical reports in the in PowerBI. Which is the best solution for this?

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-16T12:55:15+00:00

    Dear Alex,

    Good day!!

    I understand your concern and to my knowledge, the best solution for your requirement should be Power Automate because Power Apps will help you to customize the List Form but the Power Automate will help to remind the related team about the changes made and approval requirement. Moreover, we can use the Power Automate custom flow to update the attributes based on the conditions etc.

    So, to get the custom flow details based on your requirement, I suggest you to post your concern in the Microsoft Power Automate Community - Power Platform Community to get the detailed help from the experts.

    Moreover, the List data can be connected to the Power BI for generated the analytical reports and to get more details, I suggest you to post your concern in the related community i.e., Microsoft Power BI Community - Microsoft Fabric Community to get the detailed help from the experts.

    Apologies for redirecting you to a different community as the moderators in the category posted focus on the users with the Microsoft 365 out-of-the-box concerns and have limited knowledge of Power Platform, so to get the fast and better assistance, we have redirected you to the correct community.

    Appreciate your patience and understanding. Have a great day!!

    Best Regards,

    Sophia

    0 comments