Power Platform Community Forum Thread Details

Select a dataverse table dependent on who’s logged in

Hi there,

I'm relatively new to Power Apps and have been developing apps within my company for some time now. However, I've encountered an issue with one particular project that I've been struggling to overcome for a while now: data selection when a colleague logs into my app.

My requirements are quite specific. I manage a team of 8, and I'm building an app to support our work intake process, collecting project task details in a tabular format. Currently, we use Excel for this purpose, but I'm keen to move away from that and leverage the dynamic capabilities of the Power Platform.

To achieve this, I've stored my table data in Dataverse and I'm fetching it into Power Apps, where I'm populating it nicely in a gallery. This gallery includes several formulas and functions to handle various tasks such as populating dates, durations, row numbering, and allowing for insertion and removal of rows, among others. It's quite extensive for our needs. Additionally, I've implemented side menus to allow selection of different colleagues.

However, here lies my dilemma: each colleague's data is different, and I anticipate the need for continuous service improvements for this project.

So, my question is: how can I maintain the design of my gallery as a unified entity? I'm considering two options:

Dynamically select data from the Dataverse table based on who's logged in, while keeping one gallery structure so that all future changes can be contained within it.
Alternatively, I could build a custom component with the gallery I've created and somehow set up a custom variable (table) to allow ingestion of a collection. Then, I could add this custom component into any new sheet I create with minimal code adjustments to accommodate each colleague's data. This approach would also help contain future adjustments to the gallery.

In essence, I'm seeking the best way to dynamically select data to populate a gallery's item list while ensuring that design changes to the gallery are limited to just one instance.

I hope that clarifies my situation.

Thanks, John

Categories:

Microsoft Dataverse

Tables

Hi @Maddish0906

Not sure if you have reviewed the security capabilities of Dataverse. There are a lot of great options on how you can store the data and have the tasks show the right users based on how you set the ownership on the records. See the following post where I provided some details here.

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Assure-Row-Level-Secuity-in-Dataverse/m-p/2683085#M39851

Also, just a thought... You might want to look at Model-Driven Power Apps as you might be doing a lot of work with building the gallery, navigation, etc. that is built out-of-the-box with Model-Driven Power Apps. https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/model-driven-app-overview

Quick Links

Subscribe to this forum!