Problem Patching date column from date picker using desktop and mobile interface

(0) Share

Report

Posted on by venka91

1,119

Hello team,

I have built mobile app for food delivery vendor. I have been facing issue in patching a date column into SP.

in my SP list i have a date column with type text. The reason being storing date column as text is to avoid any delegation.

In my Power Apps i am using date picker to select the date. in the date picker format property i have chosen the format as "dd/mm/yyyy"

I have no issues in patching if i use desktop or laptop. the date column in my SharePoint list properly getting patching.

But at the same time, if i use the app in mobile, when i patch , the date column is getting patched as September 1, 2024. Due to this when i use the app in mobile, filters not working.

what is the solution to this ? anybody have idea ?

My code on patch button onselect :

ForAll(varMenuItems As _DynamicItems,
Patch(MyMealPlan_Dynamic, {mealtype:_DynamicItems.mealtype,Title: _DynamicItems.mealname,mealdate:Text(Left(dp_menu.SelectedDate,10),"dd/mm/yyyy"),vegtype:LookUp(varMenuItems,mealname=_DynamicItems.mealname,Title)}));

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report
Hi Venka91

There shouldn't be any need to call Left 10 on the selected date. I'd suggest the following which specifies a locale of "en-GB" (eg, one that uses the dd/mm/yyyy date format). Hopefully that might work better for you on the mobile device.

ForAll( varMenuItems As _DynamicItems, Patch( MyMealPlan_Dynamic, { mealtype: _DynamicItems.mealtype, Title: _DynamicItems.mealname, mealdate: Text(dp_menu.SelectedDate, "dd/mm/yyyy", "en-GB"), vegtype: LookUp(varMenuItems, mealname = _DynamicItems.mealname, Title) } ) );

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi venka91

Adding to timl 's suggestion as I am a bit perplexed at a couple of things. Firstly Date fields are Delegable in SharePoint for equals and greater/less than (everything you would normally query on). Storing as Text will actually cause Delegation issues when you convert them inside a query. Also would not the value patched to vegtype simply be _DynamicItems.Title (you are looking up the matching record and returning this field value).

Was this reply helpful? Yes No