PowerApps Canvas App - Patch multiple forms to a single list

(0) Share

Report

Posted on by kmw1130

958

On my PowerApps Canvas App, I have 4 Forms and I want to be able to patch to a separate list. The first Patch would be to create the item in the 2nd list and then the other 3 forms would update that item in the second list.

For a little more context:

The app has 4 survey forms for the same employee:

for each of the Survey Days, I created separate forms, and each form has their own Submit button. I want to be able to add/update a record in a separate list that I can use to bring all 4 of these forms together on another Screen.

Looking for ideas on the best way to do that or should I create a Flow to do what a Patch would do?

Thanks

Kim

Categories:

General Questions

I have the same question (0)

All responses (7)

Answers (0)

Michael E. Gernaey 47,125 Super User 2025 Season 2 on at

Like (0)

Report

PowerApps Canvas App - Patch multiple forms to a single list

Hi @kmw1130

Any updates on this?

Was this reply helpful? Yes No
kmw1130 958 on at

Like (0)

Report

PowerApps Canvas App - Patch multiple forms to a single list

@Michael E. Gernaey

I am going to try doing it one list and see how that goes.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 47,125 Super User 2025 Season 2 on at

Like (0)

Report

PowerApps Canvas App - Patch multiple forms to a single list

Hi @kmw1130

Thankj you for clarifying.

If the Survey's for instance, had the exact same number of questions, so that they took up the same # of rows then possibly putting them all in one would make retrieval easier, but would also grow that list quicker, OR saving the survey as JSON in 4 separate columns in the same row would work. As who knows what if you have 20 surveys later, you do not want 20 lists.

In a sense, the above is like having a property bag, you can either store ALL of them as a single JSON together, in a single column (rich text multi-line), then when you wan to display it, it just turns into a collection.

Its better to try to fit them in one if you can, even if that means you have to have an identifier like

Survey Batch ID, so that even though their are 4 rows to cover all 4, you can easily find them all. Then you would have your attribute for the Days 7, 10, whatever or at least the Ordinal for them 1, 2, 3, 4 so you know what section in the UI it belongs too, in case you add more, or change it from 7 days to 8 days.. you wouldn't want to have to go back in time to fix all those.

Target 1,

But go with 4 if it truly is an issue.

Its not harder to target updates in 1, versus 4 separate ones.

Was this reply helpful? Yes No
kmw1130 958 on at

Like (0)

Report
PowerApps Canvas App - Patch multiple forms to a single list

@Michael E. Gernaey

I'm sorry, I don't mean to make it confusing. Let me describe what I have:

Survey Lists all have survey questions, but also has the

Day 7 List

Day 30 List

Day 60 List

Day 90 List

Each Survey list has the employee information and the survey questions. I was thinking I needed another list that I would create an entry that has the employee information, the Survey completed and the date it was completed, so I could use that list in a Gallery for HR to select the user and see their 4 different surveys that were completed.

My question is should I have done all 4 surveys in one SharePoint list?

Was this reply helpful? Yes No
Michael E. Gernaey 47,125 Super User 2025 Season 2 on at

Like (0)

Report

PowerApps Canvas App - Patch multiple forms to a single list

Hi @kmw1130

At the moment its completely confusing as to what you have, what you want. I answered based on your post, now your saying something different.

So if you can just write up a clear description it would help.

Was this reply helpful? Yes No
kmw1130 958 on at

Like (0)

Report

PowerApps Canvas App - Patch multiple forms to a single list

Michael E. Gernaey

The 4 different Days are 4 different Lists, I started to do them in 1 list, but it was a lot of columns, so I split it into 4 lists and then the other list would just update the Employee Name, their Emp ID, form complete (for each Day) and the Date they were completed. I was thinking if I had the List that has which forms were completed, I could tie them all together in a view on a new Screen.

The user will complete Day 7 form and in 30 Days will complete the next form and so on.

So with using a Next button are you suggesting it be one list for the Survey questions?

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 47,125 Super User 2025 Season 2 on at

Like (0)

Report

PowerApps Canvas App - Patch multiple forms to a single list

Hi @kmw1130

So let me clarify one thing. Does the single List 2 have columns for all data on all Forms? If the answer is yes, it really depends on you.

Since you wouldn't want to do a Submit, since the data is from another list, not the one you are targetting, then Yes you would use a Patch, do not create a flow.

However, what you have to decide is, do you want to have the user constantly hitting Submit each time, OR do you want them to treat it like a wizard, fill out the first 4 screen using a Next button on the first 3, and on the 4rth then hit submit.

Personally that is what I would recommend UNLESS, you want to give them the option to say... fill in Form 1 and Form 2 but not 3 and 4 yet, or if you ever want to support "partial" creation with coming back later. Now that is a WHOLE other bag of worms honestly.

But lets say you want all 4 things filled in first. I would use a Next button, heck even do a Back button, but only put submit on the 4rth form.

So how do you get data from 1 to 4.

Easy enough, you can access the Forms if they are all on the same screen and you are simply hiding them as you click stuff, or if you are using a gallery / tabs situation as long as it is all on the same screen, then you can simply wait until you get to the 4rth screen and do a Large Patch with all the data across the Forms.

Please let me know if you have any follow up questions or thoughts.

Cheers

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No