Unanswered

this type of the argument does not match the expected type record

(0) Share

Report

Posted on by joyce2919

hi everyone, im encountering an error in patch function which says this type of the argument does not match the expected type record. found type table. would like to ask for your expertise as i am fixing this for hours now.

below is the formula. ExpenseType is a gallery field which is a combo box and i want to patch it to my SP list column which is a choice column.

i tried the {value:expensetype} since that is what i found on google but not working. thanks a lot!

ForAll(PCVCollection,Patch('PCV Detail',Defaults('PCV Detail'),{Particulars:Particulars,Amount:Amount,

PCVID:PCVMaster.LastSubmit.ID, ExpenseType:{Value:ExpenseType}}))

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

@joyce2919 ,
Are you Collecting Expense Type in the PCV collection? I would try that first.
joyce2919 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, yes i am collecting it first in the PCV collection since it is a repeating tables in a gallery type. then i am putting the above formula to the On Success of the Form.
turnerj3 2,039 on at

Like
a
(1)

Report
Copy link

Link copied!
@joyce2919 ,
It is something to do with how you are writing Value:ExpenseType in {}. It thinks it is a table. Can you say something like Expense Type:Combobox1.selected.value
Have you looked at your collection to see what column it is stored in?
joyce2919 10 on at

Like
a
(0)

Report
Copy link

Link copied!

It is still not working. when i checked the column type of Expensetype in the collection, it is in table type.
joyce2919 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hiii I think this is solved now. Since the expensetype in collections is a table type column, I changed the settings of SP column ExpenseType to allow multiple selections and in Power Apps, i just turned it off for that combo box. Not sure what happened, but it works like a charm 🙂 thank you for your help!
turnerj3 2,039 on at

Like
a
(1)

Report
Copy link

Link copied!

Good job @joyce2919 ! Glad you got it working.