I am working on a project. We collect employment data from 80 organizations. They shares in excel sheet and we compile them together in an excel sheet and make reports. We ask organizations to to update the respective excel file for their organization every quarter. We also check quality issues if there is any quality issue we flag them in a column of excel sheet.
Now I wish to develop a powerapp wich will allow organizations to login with their email ids (obviously different email id for different organization). Once they log in they will be able to select only the records submitted by them , not from other organizations. I also intend to prpepare a PowerBI dashboard and apply RLS so that organization can see records from their organizations only. And embed the power app in the report so that they can select the records in the PBI and the same row will be shown in the power app ready to be edited. Powerapp will also allow them to enter new record also.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.