Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Patch data from radio button answers to sharepoint list

Hi guys,


Having trouble patching data to my sharepoint list.


I have a gallery with about 30 audit questions in. The gallery's data source is a differnet Sharepoint list containing the list of audit questions.
Each question on the app has a radio button control for the user to score the question a 1, 2, 3 or 4, as shown below.



Because the questions are in a gallery, there is only 1 Radio Button control (Radio2), when it comes to patching to my sharepoint list, it will only patch the 1 record rather than all 30. 

My patch statement looks like this: 

Patch('Active Monitoring Answers', Defaults('Active Monitoring Answers'),
{Title: Dropdown3_2.Selected.Value, Score: Radio2.Selected.Value})

Is there a way to patch each score to my list? Or a way of making each question have its own radio button control showing in the screen section on the left?



Super User
Super User

Hi @JD2301,

You can accomplish your goal with the ForAll() and either Patch() or Collect() functions, see General-Discussion/patch-forall-gallery-control/td-p/43320#M17984 for the details.

Community Support
Community Support

Hi @JD2301,

Do you want to save Radio button answer for each item within the Gallery to your SP list?

Based on the formula that you mentioned, I think there is something wrong with it. I have made a test on my side, I think the ForAll function could achieve your needs, please take a try with the following workaround:7.JPG

Set the OnSelect property of the "Patch" button to following formula:

Title: "Questuion Save",
'Rating Value': Value(Radio1.Selected.Value)

On your side, you should type:

      Gallery1.AllItems, /* <-- Gallery1 represents the Gallery control within your app */
'Active Monitoring Answers',
Defaults('Active Monitoring Answers'), 
Title: Dropdown3_2.Selected.Value, 
Score: Radio2.Selected.Value
) )

More details about the ForAll function, please check the following article:

ForAll function


Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-xida-msft 


I try to use the formula you gave to meet my needs, and this is the formula i used:
ForAll(GalleryChecklist.AllItems, Patch('_Report Line 1', Defaults('_Report Line 1'), {Temperaturehumiditylogbook: Radio1_1.Selected.Value, Equipmentlogbook: Radio1_1.Selected.Value, Chillercoolantcheck: Radio1_1.Selected.Value});


However, its not working as i expected.

The one that i need is that the patch fucntion is created only one single record.

In other words, i want to patch the whole gallery which contain many multiple radio control into one single record in a sharepoint list.


This is my gallery example:

gal patch 1.png


And this is my SP list, which i dont want to (i want to patch it all in a single record/create a new record😞
gal patch 2.png


Please help, i dunno if this achieveable with powerapps.





Frequent Visitor

Hi @PytByt ,


Weere you able to accomplish this task? I am doing something similar and stuck at the same step.

If you did, please post it here as it would be very helpful for me.

Hello @sh020ho 

Have you find your solution yet?

I'm using this formula to directly patch my whole gallery items:

ForAll(GalleryInspectionChecklist.AllItems, Patch('SMU_Service Line', Defaults('SMU_Service Line'),
{cr1e4_so_numberinspection: TextInputSONumber.Text,
cr1e4_key: Concatenate(GalleryFilterSO.Selected.cr1e4_serviceorderid, "-", LabelQuestionNumber.Text),
cr1e4_questionsnumber: LabelQuestionNumber.Text,
cr1e4_questionsname: LabelQuestion.Text,
cr1e4_responds: Radio_RespondsInspection.Selected.Value,
cr1e4_respondtext: TextInputAnswerText.Text,
cr1e4_remarks: TextInputRemarks.Text}));

The green ones is my CDS Entities Column fields

The blue ones is my Gallery object (inside the gallery)

I'm still struggling with update the CDS with patch function.

In other words, i still have problem when i try to patching/update the gallery items into the CDS.
If you have an insight for me, please let me know.


Hope this help,





I guess there is misunderstanding when others propose ForAll. The formula for ForAll is correct if you wish to save multiple records.

What u r looking is Single Record with multiple questions. This is a checklist for your audit questions which we used to use.

So you should NOT use Gallery to prepare. Questions.
You should put in into very single labels or preferably using Scrollable Screens and add cards for each question and and radio buttons.
Then you
Patch(DS, Defaults (DS), {Q1 : Radio1.Selected.Value, Q2: Radio2.Selected.Value,.... }).
That's all.

Hope this helps.

Hi @PK_Hong & @sh020ho 

I'm using this formula for patching new line into my CDS:

ForAll(HeaderColl, Patch('SMU_Service Report Headers', Defaults('SMU_Service Report Headers'),
{cr807_so_numberheader: SO_NumberHeader,
cr807_visittype: Visit,
cr807_description: Description,
cr807_sitename: SiteName,
cr807_planneddate: PlannedDate,
cr807_actualdate: ActualDate,
cr807_assignedengineersname: AssignedEngineer,
cr807_actualengineersname: Engineer1Name,
cr807_engineer2name: Engineer2Name,
cr807_equipmenttype: Machine,
cr807_status: "Submit"}))

Some how it works just fine with my scenario.

I hope this help.




Helpful resources

Ignite 2022


Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,432)