ForAll/Patch not working

(0) Share

Report

Posted on by elodonnell

Hello -

I'm struggling with Patching multiple related records. Backend is Dataverse. This is a PowerApps for Teams canvas app.

In the database, amongst other things:

A table named Patients that lists patient data (one)
A table named Caseload that lists related data about which Patients are on individual providers' caseloads (many)

I have a collection of data called colPtUpdates - this is a stash of Patient records that have been updated on a form. I am saving these updated records to the database via Patch, no problem.

Next step would be to save some of the Patient information to the Caseload table. This seems like it should be so simple, and I am referencing an example that I found here: How to bulk update records in PowerApps | Microsoft Power Apps

The code is attached. The error it's getting is: "The specified column is not accessible in this context."

I've similarly tried just collecting related Caseload records in a collection with similar errors happening.

I'm completely mystified.

Does anyone have any thoughts about what I'm missing? I'm sure it's a lot - PowerApps has not come easily to me...

Thanks,

Liz

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @elodonnell ,

Firstly please post any code also in Text - saves re-typing this end. Try this

If( CountRows(colPtUpdates) > 0, Patch( Patients, colPtUpdates ); ForAll( colPtUpdates As _Update, Patch( Caseloads, LookUp( Caseloads, clPatient = _Update.Patient ), {clPatientName: _Update.ptName} ) ); Clear(colPtUpdates); );

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.

MVP (Business Applications) Visit my blog Practical Power Apps
elodonnell 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @WarrenBelz -

Thank you for the help, my apologies for image vs copy-able text.

The code that you sent is at least not getting an error! However, it only is updating the first related Caseloads record. I think I understand that this is due to Lookup only returning one record - how do I update ALL related Caseload records?

Thank you again very much for your time and help.
Verified answer

elodonnell 19 on at

Like
a
(0)

Report
Copy link

Link copied!
What actually seems to work is this:
If(CountRows(colPtUpdates) > 0, Patch( Patients, colPtUpdates ); If( CountRows(colPtUpdates) > 0, Patch( Patients, colPtUpdates ); ForAll( colPtUpdates As _Update, UpdateIf( Caseloads, clPatient.Patient = _Update.Patient, { clPtName: _Update.ptName } ); ); Clear(colPtUpdates); ); );

Thank you very much for getting me started in the right direction!
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @elodonnell ,

Is the field clPatient in Caseloads a unique value for each record and does it always match the relevant Patient field in your collection?
elodonnell 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , no - clPatient is NOT always unique for each record --> one Patient can be on the Caseload of providers from multiple disciplines.
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@elodonnell ,

I responded without seeing the solution - that is the direction I was heading with my question