web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Batch operation - bulk...
Power Apps
Unanswered

Batch operation - bulk update date fields.

(0) ShareShare
ReportReport
Posted on by 482

I'm trying to update multiple records using the batch operations available. I've got it working for text fields and option sets, but date fields don't seem to be working for me. Does anyone know how to format the request so my date fields update?

This works:

 

//--batch_123456
//Content-Type: multipart/mixed;boundary=changeset_BBB

//--changeset_BB
//Content-Type:application/http
//Content-Transfer-Encoding:binary
//Content-ID: id1

//PATCH /api/data/v9.2/entityname(id) HTTP/1.1
//Content-Type:application/json;type=entry

//{ "a1a_actionstatus": 548070001 }
//--changeset_BB--
//--batch_123456
//Content-Type: multipart/mixed;boundary=changeset_BBB

//--changeset_BBB
//Content-Type:application/http
//Content-Transfer-Encoding:binary
//Content-ID: id2

//PATCH /api/data/v9.2/entityname(id2) HTTP/1.1
//Content-Type:application/json;type=entry

//{ "a1a_actionstatus": 548070001 }
//--changeset_BBB--
//--batch_123456--

 


This does not work:

 

//--batch_ID12345
//Content-Type: multipart/mixed;boundary=changeset_BB

//--changeset_BB
//Content-Type:application/http
//Content-Transfer-Encoding:binary
//Content-ID: id1

//PATCH /api/data/v9.2/entityname(id1) HTTP/1.1
//Content-Type:application/json;type=entry

//{"scheduledstart":"2021-12-29T14:00:00.000Z","scheduledend":"2022-01-09T14:00:00.000Z"}
//--changeset_BB--
//--batch_ID12345
//Content-Type: multipart/mixed;boundary=changeset_BBB

//--changeset_BBB
//Content-Type:application/http
//Content-Transfer-Encoding:binary
//Content-ID: id2

//PATCH /api/data/v9.2/entityname(id2) HTTP/1.1
//Content-Type:application/json;type=entry

//{"scheduledstart":"2022-01-08T05:13:10.244Z","scheduledend":"2022-01-12T03:27:48.293Z"}
//--changeset_BBB--
//--batch_ID12345--

 

 

I have the same question (0)
  • MayankP Profile Picture
    464 on at

    Hi @skoofy5 

     

    is this for Dateonly field? I guess in that case only date details needs to be passed for this..

     

    Refer following example for this..

     

    https://www.inogic.com/blog/2016/05/set-value-for-date-only-field-using-web-api-in-dynamics-crm-2016/

     

  • Verified answer
    skoofy5 Profile Picture
    482 on at

    Thanks for the suggestion, but I did end up solving this by correctly parsing out the array I build up for the request payload in my join:

    data.join("\r\n")

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard