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 / Sharepoint List with P...
Power Apps
Answered

Sharepoint List with Power Apps - updateIf

(0) ShareShare
ReportReport
Posted on by 94

Hello, I need some help with updateIf, because I have a sharepoint list and using powerApps to share data to the list.

 

Site.pngODS.png

 

I use a drop box to select my records and the one selected shows up in the ODS Code box. The dropdown box is called drpBox. I have tried many attempts to be able to modify each field, but once I make a change, the list remains the same.

I have also made changed and it replaced the whole items for each record in the list.

 

 

 

These are my attempts to make a change and the updateIf statement is just not working.

 

UpdateIf(
    'GP Site Details', (sharepoint list)
       //txtODS.Text in 'ODS Code',
       //drpBox.Selected.'ODS Code' in 'ODS Code',
       //'ODS Code' = drpBox.Selected.'ODS Code' 
       //  LookUp( Table1, 'ODS Code' = drpBox.Selected.'ODS Code')
       //'ODS Code' = Value(drpBox.Selected.'ODS Code'),
       // 'ODS Code' = 'ODS Code'.Selected.value,
       //drpBox.Selected = OrgNotes.Selected.Result,
       //SharePointForm1.Selected = OrgNotes.Selected.Result,
       //drpBox.Selected = 'ODS Code',
       //drpBox.Selected = 'ODS Code'.text,
       SharePointForm1.Selected = 'ODS Code_DataCard1'.Text,
    {
        ClinicalSystem: txtCliSys.Text,
        'ODS Code': txtODS.Text,
        Server: txtSer.Text,
        'Server IP': txtSerIP.Text,
        OS: txtOS.Text,
        TAG: txtTag.Text,
        'CCG Code': txtCCGCod.Text,
        'CCG Name': txtCCGNam.Text,
        'PCN Code': txtPCNCod.Text,
        'PCN Name': txtPCNNam.Text,
        'Contract Type': txtConTyp.Text,
        'Practice Name': txtPraNam.Text,
        'Practice Name 2': txtPraNa2.Text,
        Address: txtPraAdd.Text,
        Town: txtTow.Text,
 County: txtCou.Text,
'Post Code': txtPosCod.Text,
'Practice Manager': txtPraMan.Text,
'Practice Telephone': txtPraTel.Text,
'Asst Practice Manager': txtAssPM.Text,
'IT Dept Contact': txtITDeC.Text,
'Practice Email': txtPraEM.Text,
OrgNotes: txtOrgNot.Text
}
)
Categories:
I have the same question (0)
  • Verified answer
    LaurensM Profile Picture
    12,516 Moderator on at

    Hi @Miik,

     

    If you want to update the selected record in that dropdown you can use a Patch statement:

    Patch(
     'GP Site Details',
     LookUp('GP Site Details', ID = drpBox.Selected.ID),
     {
     //Add your fields here
     }
    )

     

    If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

    Thanks!

  • Miik Profile Picture
    94 on at

    Thanks, this really solved and saved me weeks of work. I would have never thought to use Patch

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 977

#2
Valantis Profile Picture

Valantis 664

#3
11manish Profile Picture

11manish 530

Last 30 days Overall leaderboard