Hi,
I know there are old threads on this just looking for if someone has any new info
Is there any way to share an app with users where users don't have access to either sharepoint lists or dataverse tables?
I don't think secure implicit connections can do this? They are geared towards things like SQL server if I undertstand this correctly?
I don't want to use power automate to get the data into the app as it is can only get one table per flow for this, so there would be many flows to set up and keep track of.
I have this app that's gotten kinda popular and other contracts want this as well.
Yes, I can filter data in the app based on users and display correct data in the app but if I were to add other contracts to this they could just go into the datasource and view all the data for other contracts then their own, which is a no.
So far the only way of doing this would be to create apps for each contract, which could rapidly grow to an admin pain.
Or is my only option here to either use power automate or look into learning and setting up say an MS SQL server?