cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Update Single Cell in Excel File

I am looking into migrating a workflow from on-premesis SharePoint to SharePoint Online. One critical workflow manages Excel Files in a SharePoint Document Library. I need the workflow to update individual Cells in the files. (Not a Table.) I cannot find a flow connector realated to Excel that offers this function.

 

Am I missing something? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Update Single Cell in Excel File

Hi @MatthewMcDMVP,

 

I would look at using the Graph API. That way you don't need tables.

 

https://veenstra.me.uk/2018/10/17/microsoft-flow-read-large-excel-files-within-seconds-without-creat...

 

You could use the method in the above post to read the Excel file. Then update the file using the Graph API in a similar way.

 

 

 

 

 

View solution in original post

2 REPLIES 2
Highlighted

Re: Update Single Cell in Excel File

Hi @MatthewMcDMVP,

 

I would look at using the Graph API. That way you don't need tables.

 

https://veenstra.me.uk/2018/10/17/microsoft-flow-read-large-excel-files-within-seconds-without-creat...

 

You could use the method in the above post to read the Excel file. Then update the file using the Graph API in a similar way.

 

 

 

 

 

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Update Single Cell in Excel File

Excellent, thanks! Here is the Graph API Doc for the Patch Update Range doc: https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/api/range_update 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,474)