Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Updating a calculated Power App Field in a SharePoint list

Posted on by

I am building a Power App with two SharePoint lists. One list has coaches and the other has coachees (employees that are being coached). In my power app, I have a formula that calculates the number of coachees each coach has and that is working perfectly. I need that number to update in my SharePoint list when a coach is chosen for a coachee. 

 

For example:

When coach field is updated in "Coachee List," send field update for number of coachees field to "Coach List."

 

I'm thinking maybe a Patch when the coach field is updated... I'm pretty new to Power Apps so any help with detailed instruction is appreciated! 

  • IBrant Profile Picture
    IBrant on at
    Re: Updating a calculated Power App Field in a SharePoint list

    Also tried:

     

    SubmitForm(Form1);
    Patch('CP CPP Coach List','CP CPP Coach List'.Name = RecordsGallery1.Selected.Coach, {Coachees: DataCardValueCoachees.Text})
  • IBrant Profile Picture
    IBrant on at
    Re: Updating a calculated Power App Field in a SharePoint list

    I also tried:

     

    SubmitForm(Form1);
    Patch('CP CPP Coach List','CP CPP Coach List'.Name = RecordsGallery1.Selected.Coach, CountRows(Filter('CP CPP Coachee List', Coach = 'CP CPP Coach List'.Name)))
  • IBrant Profile Picture
    IBrant on at
    Re: Updating a calculated Power App Field in a SharePoint list

    I did try this on the Coachee List submit form button and it didn't work. I'm not sure what I'm doing wrong:

     

    SubmitForm(Form1);
    Patch('CP CPP Coach List', Filter('CP CPP Coach List', Name = ThisRecord.Coach))

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,651

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,727

Leaderboard