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

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?

 

Thanks,

Tim

2 REPLIES 2
Super User
Super User

Re: Working with Excel Cells instead of with Tables?

@TimBourguignon-

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.

 

Scott

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

Scott

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

Announcements
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!

firstImage

Incoming: New and improved badges!

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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 (Last 30 Days)
Users online (5,795)