Answered

Displaying data from dataverse in PowerApp

(1) Share

Report

Posted on by emilymont

I'm having trouble getting security roles configured correctly so that users can see the info they need in my powerapp.

In the app, users should be able to select from a list of options in a gallery (based on a dataverse table) and then submit a new form to record a response. Everything looks just fine from my end, but my users aren't able to view the options in the gallery. I'm trying to be restrictive with what privileges they have since the underlying tables contain some sensitive information, but it seems like it should be working now with how I have it configured.

For the security roles, I based it on the 'app opener' default role, but I've added permissions for all of the tables that app is based on too. For the table that the gallery is based on, users have the following:

Shouldn't they be able to view the items in the gallery? Any thoughts would be much appreciated. Thanks!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

MichaelFP 1,847 Super User 2025 Season 2 on at

Like (2)

Report

@emilymont Can you bring for information about the field? It has column security applied, the choice is a global choice or created direct on the attribute?

Check on your security role if you are setting the the values for the metadata (in the customizations sections) to be able to read on organization Level.

If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as solution ✔️. This is help the community.

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (2)

Report

Do you have multiple Business Units? if you do, perhaps the data is in a different business unit that the user's business unit. As a test, make Read ability Organization and see if your users see your data then.

Note that if you are trying to create a form and associate it with an item that they selected from your Gallery, they should have Create rights in addition to Append & Append To on both the primary and the associated record.

Was this reply helpful? Yes No
Verified answer

emilymont 45 on at

Like (2)

Report

I found the issue. The gallery was filtered based on a view that relied on a linked column. After I added access to the table for the linked column it worked perfectly. Thanks for your ideas!

Was this reply helpful? Yes No