Hi. This is a simple problem but I can't seem to figure it out. I am trying to patch my collection to an excel file. The formula I'm
using is
Patch(UploadData,AppData2)
UploadData - Name of the Excel table, all my headers match up
AppData2 - Name of the collection
Error Message:
"Invalid Argument Type (Table), expecting records instead"
Using Patch:
If your Source and Destination have the same column names, you can use a simple Patch statement. ChecklistItemsSource and the CheckedItems collections, have the same column names. Hence you can use the below formula to update the source at once with all the changes.
Patch(ChecklistItemsSource , CheckedItems)
https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/
