Patching to onedrive taking more time

[vgudipati]

Patching to one drive excel is taking more time.
In app i used gallery and a button to patch all items.
I used updateif function to patch. 

[Mr-Dang-MSFT · Accepted solution]

Hi @vgudipati, 

Both Patch and UpdateIf will be slow with OneDrive since Excel on OneDrive itself is not as robust a data source as Common Data Service, SQL, and SharePoint.

Excel is a quick solution for prototyping, but for your production needs, I suggest moving your data to a more appropriate location.

[vgudipati]

Agreed and understood. 

Would like to confirm with the experts so posted this. 

Thank you