Hello anyone! Thank you in advance for you replies hoping can help others too.
I'm trying to develop a Power Application that keep tracks few fields of N users of a company. I mean, this application have to show a gallery where each record contain (Date, Company worked for, Hour in and Hour out). I would like to use a single Excel file to store all the data and I've already filtered the things to show up to the people who use the application through a:
Filter(User().Email exactin "Field".Email).
Now my first question is: since to let the app works for all the employes I have to share the Application + the Excel file to the people I want in Powerapp there is no problem cos they can not read and edit others people information but just regardingthemself, but of course they can access to the shared Excel and manipulate other employes data, right??
Which solution could be better?
I was thinking about different ideas:
- Can be doable to create a single Excel file/table for each employee? In this case how can I manage that the User X can only read the excel X.Y?
- Is there a way to let the Connectors be dynamics? I mean, if I have a user X, he can call the relative connector to display/add/edit the datas.
- Is the only solution to let the application be based SQL?
Thanks a lot !