Power Platform Community Forum Thread Details

I have an app which does approvals for high spend. The data for the requests and the approvals is saved in SharePoint. On the app OnStart property it creates a collection to get around the 2000 row limit.

ClearCollect(colApprovals,Filter(APP_Approvals,Number > 0, Number <= 2000));
Collect(colApprovals,Filter(APP_Approvals,Number > 2000, Number <= 4000));
ClearCollect(colAllReqs,Filter(APP_CAPEX_Requests,Number>0,Number<2000));
Collect(colAllReqs,Filter(APP_CAPEX_Requests,Number>=2000,Number<4000));

This works perfectly for my UK users, but my users in France get a screen full of errors. Monitor tells me that the errors come from an inability to convert the date/time in the "Modified" column to a valid date/time. The date time value from the SharePoint site is coming through as e.g. 16 juillet 24, rather than 16/07/2024. The SP site is set to GMT time zone, the columns are set to "Standard" format rather than "Friendly".

I've tried date formatting but I can't find a reliable way to dynamically pick the local date format of the user. Has anyone else experienced this and found a work-around?

Categories:

Building Power Apps