Answered

Help needed related to patch code

(0) Share

Report

Posted on by omarmahmood

Hi,

I am trying to do a simple patch to collection with data coming from a gallery, based on an if else, however the patch is not working, below code for reference:

if(Dropdown2.Selected.Value = Filter_Gal.Selected.CorrectAnswer,
Patch(QCollection,LookUp(QCollection,QuestionID = Filter_Gal.Selected.QuestionID,{Score:Filter_Gal.Selected.Marks}));

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@omarmahmood
What do you mean by 'its not working'? What is not working about the PATCH?

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @omarmahmood ,

I see a syntax error in your code:
if(Dropdown2.Selected.Value = Filter_Gal.Selected.CorrectAnswer, Patch(QCollection,LookUp(QCollection,QuestionID = Filter_Gal.Selected.QuestionID,{Score:Filter_Gal.Selected.Marks})))
use the above.

I hope this resolved your issue if you see any challenge/need further help let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@omarmahmood

I think @KrishnaV is correct about there being a syntax error but I think the error is in a different place.

If(Dropdown2.Selected.Value = Filter_Gal.Selected.CorrectAnswer,
Patch(QCollection,LookUp(QCollection,QuestionID = Filter_Gal.Selected.QuestionID),{Score:Filter_Gal.Selected.Marks}));

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @omarmahmood ,
Based on the formula you provided, do you want to update the record based on the selection from your dropdown?
Could you please share more about your data source and your gallery configuration, I guess when you pick a selection from the Dropdown, a record will display in the gallery which contains fields like”CorrectAnswer”,”ID”,”Marks”. You want to update the Score with the selected field value.
Please post some screenshots about your error message.
Here is a standard formula for reference:
If(condition,… Patch( QCollection, LookUp(QCollection,QuestionID = xxx), { Score: Value } ) )
Note: xxx is a specific value which you should specify from the gallery
And on your side, you should add a ) to your LookUp(). @mdevaney provides a correct solution, I just do some addition on the standard formula.
Please modify your formula as below:
if(Dropdown2.Selected.Value = Filter_Gal.Selected.CorrectAnswer,Patch(QCollection,LookUp(QCollection,QuestionID =Filter_Gal.Selected.QuestionID),{Score:Filter_Gal.Selected.Marks}))
Best Regards,
Qi

Was this reply helpful? Yes No