Filter by DateTimeValue shows me records on a gallery but not to people with who I share the app with

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone!

A have a gallery that shows records that their load time is the same or above Now(). I'm using DateTimeValue(LOAD). On my screen it shows the correct records but when I share the app with other people the gallery is empty. My code is as follows:

FirstN(SortByColumns(
 Filter(PEDIDOS,
 DateTimeValue(LOAD) >= Now() // alterei de LOAD para field_25
 )
 ,"KEY"
 ,SortOrder.Descending
), 4)

Thanks in advance for any help!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rui_Couto,

Make sure that this user has permission to access to the Data Source.

If the permission is okay, I think you should note that Now() is changing every seconds, unless you filter the records and update the load time at the same seconds, it is difficult for the Gallery to filter the records with the same time value with the Gallery.

If you could accept the date value, I think you could refer to DateValue().

Was this reply helpful? Yes No