CODEWITHSUNDEEP
excelrestsharepointpower-automate
Harindu Lakshan
Harindu Lakshan

Reputation: 25

how to get modified rows of a SharePoint Excel file to Power Automate Cloud Flow using the Excel Rest API or any other method other than macro files?

I want to get modified rows from sharepoint excel to my power automate cloud flow. If we can get data of excel catch up events from a Rest API, That will easily solve my problem.(Please Refer the image attached for more info.) But I was unable to find a Rest API or Proper documentation for Excel File Rest APIs. Requirement: I want to show the modified rows for approval.

enter image description here

Sharepoint Excel Rest APIs and version history.

Upvotes: 0

Views: 568

Answers (1)

Tyler Kolota
Tyler Kolota

Reputation: 51

If you just want to trigger a flow when a table is edited in Excel, & get those table edits, then this workaround may help: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/When-an-Excel-row-is-created-modified-or-deleted-workaround/td-p/2264670

Upvotes: 0

Related Questions