Power Platform Community Forum Thread Details

Good afternoon,

I have a project which in a sentence is "build an audit"

I am trying to find the best way to do this

We run a user appropiateness audit once a year for about 2000 employees. They are split into departments and it is the responsibility of the department heads to log in, see the names under their department and either confirm or request their user access is modified. This information is captured within the SP list.

Today, I tried to build a Sharepoint list and build a flow around when an item has been modified or updated. The issues I am hitting is

a) 2000 lines

B) HOD edits line - add name and time into HOD columns

c) If modifications are required a member of the IT department will then go in and modify the item confirming the changes have been actioned. WITHOUT Overwriting the HOD time and date.

d) is a sharepoint list the best way to go about this, or is there a better platform?

Apologies if this is the wrong forum.

Categories:

Building flows

pls try the following:

Create a Dataverse Table: Columns: Employee Name, Department, HOD Confirmation, HOD Name, HOD Timestamp, IT Action Needed, IT Comments, IT Timestamp (same as SharePoint). Dataverse is built for relational data, so you can easily link departments and employees.

Build a Power App: HOD Dashboard: Displays only employees in the logged-in HOD's department. HOD can confirm or flag users for modification. IT Dashboard: Displays flagged items for review and allows IT to update comments and mark actions as complete. User Authentication: Use Microsoft Entra ID to authenticate users and show filtered data based on roles.

Automate with Power Automate Automate the same workflows as in SharePoint: Track timestamps and update them only when relevant fields change. Notify IT when a department head flags a record for action.

Reporting and Analytics: Use built-in Dataverse reporting or Power BI for dashboards and insights into audit progress.

let me know if you need more help.