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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Update share point lis...
Power Apps
Answered

Update share point lists form gallery item based on item field value

(0) ShareShare
ReportReport
Posted on by RV_KONDRA 50

Hi,

 

In my power app gallery list of items, i need to send the update from gallery item to my master share point list (Master action list) and child share point list(BW Action list). Below is the scenario i created and this works only to update one list, but i want to see the update in my master list as well.

 

1. First in my gallery i created a text box for user to provide update

2. i created a update button and on select i gave below statement

    If(ThisItem.'Partner Name'.Value="BW",Patch('BW Action List',Defaults('BW Action List'),           

 {Update:Update_textbox.Text,Title:ThisItem.Title}))

 

In above statement i need to patch the update into my master list as well.

 

Regards,

RK

Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 156,277 Most Valuable Professional on at

    Hi @RV_KONDRA ,

    Do you mean something like this?

     If(
 ThisItem.'Partner Name'.Value="BW",
 Patch(
 'BW Action List',
 Defaults('BW Action List'), 
 {
 Update:Update_textbox.Text,
 Title:ThisItem.Title
 }
 );
 Patch(
 'Master action list',
 ThisItem,
 [Whatever you are updating]
 )
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

  • RV_KONDRA Profile Picture
    RV_KONDRA 50 on at

    Hi Warren, thanks for your response.

     

    With your statement it is updating master list, but in child list it is creating a new item,instead of updating the existing one.

    Below is the new statement i tried.

    If(ThisItem.'Partner Name'.Value="BW",Patch('BW Action List',Defaults('BW Action List'),{Update:Update_textbox.Text,Title:ThisItem.Title}),

     

    If(ThisItem.'Partner Name'.Value="BLR",Patch('BLR Action List',Defaults('BLR Action List'),{Update:Update_textbox.Text,Title:ThisItem.Title});

     

    Patch('Master Action List',ThisItem,{Update:Update_textbox.Text,Title:ThisItem.Title})))

     

    Regards,

    RK

     

     

     

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 156,277 Most Valuable Professional on at

    Hi @RV_KONDRA ,

    I simply copied your code for the child list as you said it was working as you wanted it to. Defaults() will always create a new record, so my question is what common value (field name) do you use to identify the relevant record in the Child list?

    You would need something like

    If(
 ThisItem.'Partner Name'.Value="BW",
 Patch(
 'BW Action List',
 {ChildField:MasterFieldControlValue}, 
 {
 Update:Update_textbox.Text,
 Title:ThisItem.Title
 }
 );
 Patch(
 'Master action list',
 ThisItem,
 [Whatever you are updating]
 )
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

  • RV_KONDRA Profile Picture
    RV_KONDRA 50 on at

    Hi @WarrenBelz ,

     

    I got 4 partners, below is the scenario that i developed.

     

    • I created 4 sharepoint Lists for 4 partners and one master list, so total 5 share point lists
    • My app is linked to all share point lists and my gallery list is linked to master SP List
    • i created a field in SP list to develop unique reference number
    • So in my app what new action is requested, new item will be created in master share point list and in associated child list based on user selected partner name value form the drop down in request form.

    For your question - common value (field name) need to identify the relevant record in the Child list is my Title field (UNIQUE REFERENCE NUMBER)

     

    Regards,

    RK

  • WarrenBelz Profile Picture
    WarrenBelz 156,277 Most Valuable Professional on at

    Hi @RV_KONDRA ,

    What field does UNIQUE REFERENCE NUMBER match in the master list - the ID?

  • RV_KONDRA Profile Picture
    RV_KONDRA 50 on at

    Hi @WarrenBelz ,

     

    When i created share point lists for all partners and master list, the unique ID field is my Title field.

    PA 13072020.PNG

    Regards,

    RK

  • Verified answer
    RV_KONDRA Profile Picture
    RV_KONDRA 50 on at

    Hi @WarrenBelz ,

     

    It is sorted now, i used "updateif " and "Patch" function and it worked perfectly.

     

    Thank you very much for your support.

     

    RV

  • WarrenBelz Profile Picture
    WarrenBelz 156,277 Most Valuable Professional on at

    Thanks @RV_KONDRA ,

    You have tagged you own post as the solution? Please correct if not the case as it will confuse.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 392 Most Valuable Professional

#2
11manish Profile Picture

11manish 136 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 109 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans