Answered

save date from powerapp to sharepoint list using patch

(0) Share

Report

Posted on by Community Power Pla...

Hi powerapps community - have an app where I am displaying the date when the user opens the app, capturing data from dropdown fields, and would like to also save the date to a sharepoint list with the other data fields.

I have tried the Sharepoint list fields as both Text(date2) and Date(Date) formats, but while all the other data saves - the date does not.

Using Patch, here is the full formula (currently to date2(text formatted in SP).

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,

You need the DateValue() Function

date2:DateValue(Label_date.Text)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks, Warren - a value was passed to SP list using DateValue, but it shows as 3/3/2023 (when date is displayed in app as 27.03.2021).

When I changed the formula in label_date to Today() - the correct date did post to SP as 3/27/2021. Ideally, am looking to display and track the date in the European format DD.MM.YYY. Thanks!

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

Like (1)

Report

Hi @Anonymous ,

What exactly is in the label to produce that result? DateValue() simply converts text in a valid date format to a date value.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz , the label was Text(Today(),"[$-en-US]dd.mm.yyy") and display value was 27.03.2021

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

Like (0)

Report

Hi @Anonymous ,

I mean the content that produced 3/3/2023

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz , full functions below for both button and label:
button OnSelect
label Text (appears on screen today as 30.03.2021 - yet in SP List, appears as 6/3/2023

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@Anonymous ,

I have never used the xx.xx.xxxx for dates, but try this in your Patch

date2: DateValue( Substitute( Label_date.Text, ".", "/" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No