Validate Sharepoint list value on start

[Joppel]

We have a problem with a filter for the start screen. When we run Onstart to test the validation, everything works as it should. when the app is published the validation does not work. We think it has to do with the fact that the data we want to validate is not yet available at startup, but how could we solve this? We use the code below:

If(
    And(
        CountRows(Gallery_1.AllItems) = 0 Or DateDiff(
            DateTimeValue(First(Gallery-1.AllItems).Created),
            Today(),
            Days
        ) >= 28,
        Value(LookUp('Sharepointlist',Value_1=Profitvalue.Text,Profit))>=100000
    ),
    Profitscreen,
    Startscreen
)

[fuzzy_fuzz]

I'm thinking on placing a 500ms or so Timer that starts on the OnStart. Then at OnTimerEnd execute your code.

If you think the issue comes from not having the data at the Start moment a delay should solve it.

[Joppel]

We've built in a timer, but to make sure the data is loaded, we set it to 5 seconds.

For now we achieve what we wanted, but if someone knows how we can load this faster, we'd love to hear about it.

[v-jefferni · Accepted solution]

Hi @Joppel ,

You could just copy the formulas from Items of the Gallery_1 to replace Gallery_1.AllItems that in OnStart. The Timer Control is no more needed.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.