Unanswered

Date issue when doing a collection in PowerApps

(1) Share

Report

Posted on by hemanth1618

Hi i am trying to build a excel like power apps to a user maintained Oracle table.

for a new record insert i am doing a patch function directly to the oracle table and doing clearcollect function so that new record will be added to the collections. I am using UTC date format for date field.

patch(oracletable, column1, column2);

clearcollect(collectname, Oracletable)

i am using collection for my gallery to show data so if i add a new with 8/25/2022 date in the date field it is showing fine in gallery but in collection it is taking it as 8/24/2022 20:00:00 and actually sending this 8/24/2022 date when i do a patch to my oracle table from collection.

I am assuming when i entered the date 8/25 by default it will 00:00 hours not sure why it is substracting 4 hours when loading data into collection.

please advice. TIA

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@hemanth1618

I am not sure this is it, but does converting to UTC first help?
DateAdd( Now(), TimeZoneOffset(), Minutes )

DateAdd info - docs.microsoft.com

See if this helps @hemanth1618 .
hemanth1618 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure where to add the function you provided. I added it to default value of the field and it didn’t change anything. Do i need to add it in clearcollect function. If yes below is my function how do i modify to specify columns of the database table.

clearcollect(collectionnane, tablename) is there a way to mention columns individually in clearcollect funtion.

i am pretty new to powerapps and this is my first app so sorry for if my above question is invalid.