Unanswered

Created by field populated differently with lookup vs selecting a record from gallery

(0) Share

Report

Posted on by ossidabossi

Hi guys,

I have an app with a gallery that lists records from Table A from dataverse. When selecting a record, the user is taken to a screen where the record can be edited. The user is however only allowed to edit records that he himself has created (and view records others have created). The user can also create a new record, after which the user is taken to the edit screen.

In order to evaluate whether the record is created by the user or not, the created by field from the "current_record" global variable is compared to the User() function. The comparison is as follows: current_record.UserName = User().Email.

This works fine when selecting a record from the gallery, but when I set the variable in the Patch function in the new record creating (or as I tried, to set it again with lookup), the created by field is missing this .UserName column (it only shows "fullname" and "systemuserid", which can not be compared to any User() attribute). So PowerApps seems to limit the amount of columns that are shown in this record from the created by lookup column (which is a lookup to the User table, standard dataverse table).

Any ideas how to show more columns with this lookup / patch, or some other way to compare the user data?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Jonathan Manrique 2,695 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ossidabossi

One of the limitations that Canvas App has is the amount of records it can return and that is 2000, if you have more than that amount the search only returns the first ones.

In this sense that field you are using as a search field, you will have to use some kind of filter with non-delegable formulas so that you can limit the number of records that should be returned.

There are many techniques that will allow you to do this, but the first thing you need to do is understand delegation.

https://learn.microsoft.com/es-es/power-apps/maker/canvas-apps/delegation-overview

An example of how to resolve delegation

https://www.youtube.com/watch?v=2cKcylsGlPg

Was this reply helpful? Yes No
ossidabossi 12 on at

Like
a
(0)

Report
Copy link

Link copied!

This problem is not about delegation. It is actually about the "Explicit column selection" that can be found in the Upcoming features of the Settings. This feature limits the columns of retrieved data to the ones that are actually in use. In this case however, I would like to force it to retrieve data ('User Name' from the User table).
I actually solved this by setting the User Name into a global variable. This way the app understands that this column is being used and retrieves that from the database. I was looking for a solution where this can be done in the code where I set the context variable but seems like that is not possible.
Thanks for the help anyway.

Was this reply helpful? Yes No