Answered

Users can't see their items in gallery

(0) Share

Report

Posted on by AterCZ

Hi!

Users access a Sharepoint list using a Power Apps gallery. They create and view items via the Power App. For some users everything works fine, a few users are able to create the items but the created items do not show up in the gallery. Do you have any suggestions how go around fixing this?

Items property in the gallery:

SortByColumns(Filter(helpdesk_db, TextSearchBox1.Text in Title && 'Created By'.Email = User().Email), "Created", If(SortDescending, Ascending, Descending))

User's permissions for the Sharepoint site and list: Edit

Advanced settings: Read all items and Create and edit all items

Example user email: Jan.Novak@company.sk

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

HI @AterCZ ,

'Created by" is not delegable, so if you have a standard limit, you will only be able to access the first 500 records. You only can increase this to 2,000.

The workaround would be to write the user's email address (as it is unique) into a Text field when the item was created and then query on that.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 155,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AterCZ ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
AterCZ on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
sorry for the delay, I was waiting for the affected users to confirm the fix. It worked when using the additional text field, thanks a lot!

Was this reply helpful? Yes No