web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch to same SharePoi...
Power Apps
Answered

Patch to same SharePoint List from multiple galleries

(0) ShareShare
ReportReport
Posted on by 52

Hey all,

 

I am using multiple galleries to recreate ppt like feel for users and due to this have the need to patch data from multiple filtered galleries to same SharePoint list, without using collections.

 

My app page would look something like below: multiple galleries, each filtered on Region selected from the drop down and Brand from the list column in my SharePoint

OnlyGooner_0-1691655569314.png

My SharePoint list looks like: Q1, Q2, Q3 and Q4 are the columns to be patched basis QTR selection from the drop down

OnlyGooner_1-1691655630456.png

I am using something like below:

 

If QTR_Dropdown.Selected.Value = "Q1 2023"

ForAll(
                Gallery1.AllItems,
                Patch(
                    'My SharePoint',
                    ThisRecord,
                    {
                        Q1: txtbox.Text,
                        'Last Modified': Now()
                    }
                )
            );

,

... So on for each gallery and for all four Quarters

 

Pls help as using multiple patch functions is not working, data is not getting stored for all galleries and sometimes it even throws Network error

Categories:
I have the same question (0)
  • OnlyGooner Profile Picture
    52 on at

    @v-hanytian-msft  - Pls can you help

  • PowerNuggets Profile Picture
    360 on at

    Hi @OnlyGooner 

     

    Please check the two posts below they may help

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Submit-from-Multiple-Galleries-into-a-SharePoint-List/td-p/561139

     

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Patch-multiple-items-from-gallery-back-to-my-SharePoint-list/td-p/1336409

     


    _____________________________________________________________________________________
    Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.

     

    MD

     

  • Verified answer
    OnlyGooner Profile Picture
    52 on at

    Had to use Collections to make it work. I think we can't patch multiple rows of data with one query so it has to be via collections.

    Sometimes not getting any help is the biggest help one can get 🙂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 936

#2
Valantis Profile Picture

Valantis 604

#3
11manish Profile Picture

11manish 518

Last 30 days Overall leaderboard