Unanswered

Updating a calculated Power App Field in a SharePoint list

(0) Share

Report

Posted on by IBrant

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

IBrant on at

Like (0)

Report
Copy link

Link copied!

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))

Was this reply helpful? Yes No
IBrant on at

Like (0)

Report
Copy link

Link copied!

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)))

Was this reply helpful? Yes No
IBrant on at

Like (0)

Report
Copy link

Link copied!

Also tried:

SubmitForm(Form1);
Patch('CP CPP Coach List','CP CPP Coach List'.Name = RecordsGallery1.Selected.Coach, {Coachees: DataCardValueCoachees.Text})

Was this reply helpful? Yes No