Trying to use Patch command to update records in Inspections, an SQL table and getting and error on the command.

(0) Share

Report

Posted on by Johnh1

Hello,

I am trying to use the Patch command,

Patch(

PAT,

colInspection

);

the table PAT is an Azure SQL table. The issue is that the colInspeciton gives the following error "Invalid argument type (Table). Expecting a Record value instead". I have no idea how to resolve this error. Any suggestions on how to resolve this issue or what to look for?

Thanks in advance for your help.

Kind regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Please disregard this as I completely misunderstood your issue 😅

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Johnh1 ,

For that code to have a chance of working, every field in colInspection needs to exist in PAT in both name and field type. I assume you are trying to add new records here.

Was this reply helpful? Yes No
Johnh1 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @warren,
That is what I thought Warren and yes, I am adding new records. Thanks for the update. I am going to review the field names in the colInspection and PAT and make sure they are all equal. Thanks again for the help.

Was this reply helpful? Yes No