cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MatthewMcDMVP
Level: Powered On

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
Super User
Super User

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
Super User
Super User

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

MatthewMcDMVP
Level: Powered On

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

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,317)