Showing results for 
Search instead for 
Did you mean: 

Working with Excel Cells instead of with Tables?

Hi there,


here's the scenario I am trying to automate:


  1. When the picture of a new receipt is found in a special folder on OneDrive
  2. Duplicate an expense report Excel Sheet that is saved on OneDrive
  3. Fill up the required cells (Date, ReasonForTheExpense and Amount)
  4. Export the file as a PDF
  5. Bundle it with the image of the receipt
  6. Email the bundle

The problem I currently have is the following: my Excel-sheet is pretty dumb, there is no Excel-Table to reference and add a row into. Is there a way to manipulate cells directly instead of rows with the Excel-Connector?




Super User
Super User

Re: Working with Excel Cells instead of with Tables?


The Excel connectors all require that you use a table.  If you are using a table, you can insert a new row and populate the cells as you desire.


The Excel Online (Business) connector and the Excel Online (OneDrive) connectors both have actions that allow you to create tables and insert rows into tables.


Let me know if you need an example.



If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


Re: Working with Excel Cells instead of with Tables?

Hi Scott, thanks, but unfortunately I cannot modify the base file to add tables.

Helpful resources


New & Improved Power Automate Community Cookbook

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


Power Automate Community User Group Member Badge

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


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,795)