cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TimBourguignon
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
ScottShearer
Super User
Super User

@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

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,966)