I have got an app with 2 screens, one with gallery showing the list of records, second is edit form to create/edit.
The form has about 15 fields of various types, that includes 2 lookups and couple of option sets. So my app is based on 3 CDS entities, one main entity and 2 related entities for lookups. I have created a custom security role, given organisation level permissions to all the 3 entities. I have assigned this role when sharing the app with other user. But for some reason, the lookups and option sets are blank.
If i give System admin role to the user, it works fine.
As i come from Dynamics 365 CE background, i was pretty sure that i have configured the role right, but i missed the bit from the MS documentation that we should have the "Min Privileges to run the App", thanks for the link.