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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard