Unanswered

Patching error

(0) Share

Report

Posted on by WeAllStardust

Hi,

I have an error popping up when I try to patch an excel sheet. Here is the code.

Patch(
Table2,
{
Name: Text_Name.Text,
Place: Place.Text,
Number: Dropdown_Num.Selected.Result,
Code: ComboBox_Code.Selected.Code,
StDate:TextInput_DSTT,
StTime:TextInput_TSTT,
EdDate:TextInput_DETT,
EdTime:TextInput_TETT
}
)

The errors I get are:

Screenshot 2021-05-20 074109.jpg

The StDate Column in my excel sheet is formatted to a 'Date' format and I'm wondering if that is affecting it. I need it to show a date format in the excel sheet and not some general text. I've also tried; .text, .format(date()), .selected.value.

Any ideas? Thanks for looking

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Sort by

C-Papa 1,836 on at

Like (0)

Report
Copy link

Link copied!

Hi, try converting the text date string to a date, as an example, in the patch, change TextInput_DSTT to DateValue(TextInput_DSTT), you will need to do similar for all dates.

Was this reply helpful? Yes No
WeAllStardust 45 on at

Like (0)

Report
Copy link

Link copied!

I tried that and it gave me an error.
I added a '.Text' after TextInput_DSTT and it removed the error but the output showed as '2021-05-20T05:00:00.000Z' which is a weird format. I'm looking for '5/20/2021' format.

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like (0)

Report
Copy link

Link copied!

ok, maybe try, Text(TextInput_DSTT,"dd/mm/yyyy"), you might have to change "dd/mm/yyyy" to match your column format in excel.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@WeAllStardust

You need to account for the proper datatypes for your columns. Your StDate appears to want a date/time value.

Also, you are referencing the controls...not the control values. You need to specify the property that has the value you want. Assuming all of your controls are text controls, you need to reference the .Text property.

Please consider changing your Formula to the following:

Patch(Table2, { Name: Text_Name.Text, Place: Place.Text, Number: Dropdown_Num.Selected.Result, Code: ComboBox_Code.Selected.Code, StDate: DateValue(TextInput_DSTT.Text), StTime: TimeValue(TextInput_TSTT.Text), EdDate: DateValue(TextInput_DETT.Text), EdTime: TimeValue(TextInput_TETT.Text) } )

I hope this is helpful for you.

Was this reply helpful? Yes No
WeAllStardust 45 on at

Like (0)

Report
Copy link

Link copied!

I get the same error again

Was this reply helpful? Yes No
WeAllStardust 45 on at

Like (0)

Report
Copy link

Link copied!

When I use that I get the 'Invalid Argument Type' control error. When I added the '.Text', it gave me a weird format that I didnt want. See my reply above.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@WeAllStardust

Have you used the formula I provided for you?

Was this reply helpful? Yes No
WeAllStardust 45 on at

Like (0)

Report
Copy link

Link copied!

Yes I did. The error goes away but this is what I get on excel

I had this working one time when I used labels instead of a text input. The text input box is what giving me errors.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@WeAllStardust

What is the format for the cells in Excel for the dates?

The value you are getting in Excel is accurate as it is a date, but the format of that would be governed by the cell format.

Was this reply helpful? Yes No
WeAllStardust 45 on at

Like (0)

Report
Copy link

Link copied!

Here are the snapshots from excel

Was this reply helpful? Yes No