Power Platform Community Forum Thread Details

I have a timer job in the Gallery which runs every 12000 milliseconds. Repeat and Autostart set to true and Autopause set to false.

OnTimer End i have below patch function where i set the boolean column BC to true. My datasource has more than 2000 records. May i know how to ensure that this patch function runs without getting into delegation issues. Currently this patch function works for some records and doesn't work for some.

OnTimerEnd code

If(
    ThisItem.'Request Status' = "Approved" && (ThisItem.FCR= false || ThisItem.FCR= Blank()) && (ThisItem.BC= false || ThisItem.BC= Blank()),
    Patch(
        'Data Source',
        LookUp(
            'Data Source',
            ID = ThisItem.ID && ID > 3000
        ),
        {BC: true}
    )
)

Categories:

AI Builder

Building Power Apps

Error handling

Experimental features

GCC, GCCH, DoD - Federal App Makers (FAM)

Connector development

Microsoft Dataverse with Power Apps

Governance & administering

Power Apps Pro Dev & ISV

Power Query

General topics

@Poweruser32490,

A gallery has built in pagination, which means it will only load the first 100 records from the data source. Only if you sroll down and reach the end of the gallery, it will load the next 100 records, and so forth. This may be the reason your app is not behaving as you expect it to.

May I ask about your use case though? You seem to want to implement some sort of business logic, but I don't think using a timer control in a gallery in Power Apps is the right thing to do that. In case you are using SharePoint as a data source, consider using a Power Automate cloud flow, to be triggered when an item is modified, with some trigger conditions to be the same as the logic in you Power Fx formulat, to do the trick.

This will make updates much faster, reliable, monitorable, and will take away the workload from Power Apps, improving the performance.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.