I everyone,
I need to make an app in power apps which will serve several department in my organization each department should manage part of the data in some cases even only see part of data which relevant to their job and of course I need maybe an admin who can see and manage all the data.
regarding one of the department use cases I need a way that each worker will be able to manage a specifics rows in the data based on a field value, lets says that in my data i have a column of a school id or name and i can have a specific person responsible for this school there for i want only him to see and manage that school rows, also i need that a manager of this department will be able to see and manage all the data without filtering by a specific school.
How can i let a user to import excel into the data (for example to the dataverse) or is there a easy way to integrate this data that eventually comes from the ERP System / database?
How can i filtered the data and export the filtered data to an excel, I need that after some of the departments process the data and approving some of the rows i need to provide a way that a worker from another department will be able to get an excel files based on those records who have been approved.
What is the best way to implement such a requiernaments?
looking forward for your guidances and advices
Thanks.

Report
All responses (
Answers (