My app has 3 screens:
On my HomeScreen, OnVisible I have a Collection that specifies which Report Group the logged in user is in.
My goal is that the logged in user only sees records that are in their Report Group. I have column in my SQL table called rpt_group.
Is there an easy way to do this by pulling a Collection? Or is there a better method? Thank you in advance!
First the rpt_group should be connected to the user in one way or the other, is this the case?
If not, I would collect the Office365 info off the user and store this in a new users table in your database. Then let the User select his rpt_group when he uses the app for the first time and store this GroupId also in this Users table. Then the next time you run a script at start in where you lookUp the user in this table and return the result in a local variable with UpdateContext() formula. Lets say this variable is called _PUser then you can filter the report with
rpt_group = _PUser.rptGroup
I would use Flow and a stored procedure to do this, but lookup will also work.
Hope this helps.