I have an urgent question.
We would save data in a SQL on azure and would like this data to be shown in a powerapp, filtered per user.
Now, our train of thought was to make a 'peoplefield' in azure where the domainusers are stored. Then we would filter in the powerapp on that field. I'm having the hardest time to find if that is possible + if that is the way to go.
Is there a different/better approuch?
Thanks a lot!
If you are saying there will be a column in the Azure SQL table that has for example a list of email addresses or usernames, then yes its very possible to filter the list in PowerApps that way. Just be aware that it isn't the same as security. Users will need access to the whole table and could use the established connection to pull the data and filter it differently.
Thank you for the faast reply, much appreciated!
- So in SQL you just need a textfield where the users email(s) would be stored?
- I did not think of that, thank you very much. So we would give the users access to that SQL so it would work? Or is that established automaticcaly when you lay that connection?
Or maybe we would copy the needed records and maybe put them in cds? Is that the safer option?
The SQL connector asks for a connection account when you connect to Azure SQL. This will be a SQL account, since the connector doesn't support the use of Azure AD accounts for Azure SQL. That account has to have permission for whatever you want to do with the data in SQL.
If you want security, CDS might provide more options. But in general I don't think its worth the overhead of duplicating the information and keeping it in sync. I think its usually best to have only one copy of any piece of information. So if its in SQL and you can use it from SQL without major concerns that is where I would leave it.
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021