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

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

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
Highlighted
Resolver I
Resolver I

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

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 (6,892)