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!
Solved! Go to 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,
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}))
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,
Fantastic - Thank you so much
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
252 | |
122 | |
84 | |
83 | |
67 |