Patch Statement has invalid Arguments

[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!

[eka24]

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.

[CliveMM]

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}))

[v-yutliu-msft · Accepted solution]

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, 

[eka24]

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

[CliveMM]

Fantastic - Thank you so much