Answered

Taking Offline Data from a Collection And Updating Existing Records

(0) Share

Report

Posted on by AK-06092009-0

As the title says, I'm struggling to do this, I think what I have looks good, but it isn't working:

LoadData(colJobUpdate, "offlineJobUpdatesData");

ForAll(
 colJobUpdate,
 Patch(
 Jobs,
 LookUp(
 Jobs,
 'Activity Sheet Number' = ThisRecord.'Activity Sheet Number'
 ),
 {
 'Time Start':Now()
 }
 );
 Notify(
 "Jobs Updated",
 NotificationType.Success,
 1000
 );
);

Clear(colJobUpdate);
ClearData("offlineJobUpdatesData");

Does anyone have any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Anchov 1,986 on at

Like
a
(1)

Report
Copy link

Link copied!
Try updating this portion of the code to add As job, then reference job instead of ThisRecord. This should reduce the ambiguity of field names.

ForAll( colJobUpdate As job, Patch( Jobs, LookUp( Jobs, 'Activity Sheet Number' = job.'Activity Sheet Number' ), { 'Time Start':Now() } ); Notify( "Jobs Updated", NotificationType.Success, 1000 ); );

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
AK-06092009-0 23 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you! This worked!

Was this reply helpful? Yes No