cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpezzutti
Helper II
Helper II

Rollback

Hello 

My power app is writing to a common data service from a collection. Unfortunately only some records were pushed and not the whole lot. How can we be sure that all the transaction went through. Is there any mechanism that can be done to prevent only partial data being pushed

2 REPLIES 2
EricRegnier
Super User
Super User
v-qiaqi-msft
Community Support
Community Support

Hi@mpezzutti,

Could you please share more about your collection?

Do you use Patch() function to write collection to CDS?

Actually, When used with a data source, these functions can't be delegated. Only the first portion of the data source will be retrieved and then the function applied. The result may not represent the complete story. A warning may appear at authoring time to remind you of this limitation and to suggest switching to delegable alternatives where possible.

Combine that with the above description, please check if you have created a collection with a data source.

If your collection isn't used with a data source, you can try the following workaround:

 

ForAll(
  YourCollectionData,
  Patch(
          'YourCDSEntity',
           Defaults('YourCDSEntity'),
           {
             CDSColumn1: CollectionColumn1,
             CDSColumn2: CollectionColumn2,
             CDSColumn3: CollectionColumn3,
             ... 
           }
  )
)

 

Best Regards,

Qi

Best Regards,
Qi

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Users online (4,317)