Patch Statement has invalid Arguments

(0) Share

Report

Posted on by CliveMM

Hi All. This Patch statement fails and it says the patch statement has an invalid argument:-

ForAll(QuestionTemplate, Patch(JobItems, {Q1: QuestionTemplate.Q1}))

However this is ok: ForAll(QuestionTemplate, Patch(JobItems, {Q1: "Hello World"})) so its I believe then formula is not seeing QuestionTemplate.Q1 as a text input when it is.

QuestionTemplate.Q1 and JobItems.Q1 are both columns in a SharePoint list of type 'single line text'

I have also tried ForAll(QuestionTemplate, Patch(JobItems, {Q1: Text(QuestionTemplate.Q1}})) but that does not work either.

Help!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

ForAll(QuestionTemplate, Patch(JobItems, {Q1: QuestionTemplate.Q1}))
Please note that Q1 should be your columnName in your list and QuestionTemplate should be the name of the textbox on your form or screen. If what I have said is the case then your formula should be:
Patch(JobItems, {Q1: QuestionTemplate.Text}))

Your comments are welcome
If you like this post give thumps up. If it resolved your question then mark as a solution.

Was this reply helpful? Yes No
CliveMM 68 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Eka24, Thank you for your response, However I am updating without and screen controls, just moving rows from one share point list to the other. I had forgotten the defaults but I have added them now but still get the same error

ForAll(QuestionTemplate, Patch(JobItems,Defaults(JobItems), {Q1: QuestionTemplate.Q1}))

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CliveMM ,

Do you want to update JobItems's Q1 field by using the data of Q1 field in QuestionTemplate?

If so, I suggest you use [@] to avoid ambiguity。

Try this formula:

ForAll(QuestionTemplate, Patch(JobItems, {Q1: QuestionTemplate[@Q1]}))

Best regards,

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Main issue has to do with the QuestionTemplate.Q1 portion of the formula. Try this
ForAll(QuestionTemplate, Patch(JobItems,Defaults(JobItems), {Q1:Q1}))

Was this reply helpful? Yes No
CliveMM 68 on at

Like
a
(0)

Report
Copy link

Link copied!

Fantastic - Thank you so much

Was this reply helpful? Yes No