Answered

Error Patching to Dataverse Table - Invalid Argument Type (Guid). Expecting a table value instead

(0) Share

Report

Posted on by McKennaM03

I have a single dataverse table PEG_Data for a canvas app. I am trying to Patch a collection to the table

ForAll(colPEG_Members, Patch(PEG_Data, Lookup('PEG_Data':Member = 'colPEG_Members':Member),{Member_Stat: Member_Stat, Record_Status: Record_Status}));

The first PEG_Data in the statement is giving me the Invalid Argument Type error.

Any assistance would be appreciated

Marty

Categories:

Microsoft Dataverse with Power Apps

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @McKennaM03,

Could you please show me the screenshot of your formula?

Do you want to update the Dataverse table with the same Member?

If you just want to update records that share the same Member with colPEG_Members, I think you could directly use the UpdateIf() function.

ForAll(colPEG_Members, UpdateIf(PEG_Data, Member = 'colPEG_Members'[@Member],{Member_Stat: 'colPEG_Members'[@Member_Stat], Record_Status:'colPEG_Members'[@Record_Status]}));
McKennaM03 35 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @v-qiaqi-msft

Yes I am updating the records in table PEG_Data where Member = Member in colPEG_Data and updating two fields
I have changed my statement to match your proposal thanks.

I am getting an Invalid Argument Type on the PEG_Data

Marty
Verified answer

McKennaM03 35 on at

Like
a
(1)

Report
Copy link

Link copied!

I've solved my issue. I added the As operator to the collection