Large Checklist PowerApp - Need Help to Edit/Update

(0) Share

Report

Posted on by myawornicky

Hello - I have a large checklist that is setup in multiple phases.

1. Master Input Form - includes all the main details and sets the master record.

2. Checklist 1. Total of ~200 questions. No issue linking the master record to the checklist.

Also, have one list for Questions, Answers, and Input Form Info.

I have multiple inputs for each question. At the end of each I use a checkbox to patch the answers into a collection and when complete I run a bulk upload through powerautomate to patch my sharepoint list. I only receive answers for the answered questions (no issue).

Where I am stuck is when I go back into the powerapp and select what I was working on and want to pick up from where I left off or finish the missing sections.

I duplicated the gallery that lists the questions and answers, but how do I edit the record rather than creating a new when patch is executed?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

Patch will either create a new item in the data source you are patching to, or it will edit the specific record you tell it to target. This is done using the 2nd parameter which is optional. If this is left out, it creates a new item, if it is filled out it will look for the item and if found will patch updates to it based on what you give the patch statement.

Patch(SP_List_Name, boolean_Statement, {your changes});
boolean statement examples: Lookup(SP_List_Name, FullName = User().FullName)
your changes should be in format: {col1: value, col2: "value", col3: dropdown1.selected.value, etc...}

If done correctly this will edit an existing record rather than create a new one.

If this helped solve your issue please mark as the solution to help other find it!

Was this reply helpful? Yes No
myawornicky 2 on at

Like (0)

Report
Copy link

Link copied!

Yes, when I am just dealing with Patch I have a formula that does just that:
Patch(
SPLIST,
If(
_editingRequest,
LookUp(
SPLIST,
ID = Master.Selected.ID
),
Defaults(SPLIST)
),....

Works like a charm.

The gallery I have a ForAll then Patch...Where do I put the criteria to look up in the existing SP List? after forall or in Patch function?
ForAll(
colAnswer1,If(_editingRequest, LookUp(varID=Master.Selected.ID && QuestionID = QuestionID),

Patch(
Answers
Defaults(Answers),

Was this reply helpful? Yes No