Automating Email from Excel Report

(1) Share

Report

Posted on by BB-03031942-0

Hi,

I'm trying to use Power Automate to send emails from an excel report, rather than having to use mail merge. The report contains a ticket number, ticket subject, ticket owner, owner email address, and ticket due date. The idea being that Power Automate will take each record in the spreadsheet, and send the ticket owner a email with the due date.

Using Power Automate, I was able to get this successfully working, if I manually modify the excel spreadsheet, first creating the table in excel, then saving the spreadsheet to a folder on my OneDrive.

However, I wanted to take this to the next logical step, and remove any manual intervention. The excel report is generated in ServiceNow, which emails either myself, or to a Team's channel, and power automate should pick up the excel file, then run the workflow and email each ticket owner. However, ServiceNow just creates a 'flat' excel file, it doesn't set tables. So I tried to use "when a file is created" > "create a table" to dynamically create the table. However this seems to fail with the below error, and I can't see why. The file exists, I even used the file selector to pick the file from the folder.

The resource could not be found.
clientRequestId: 12256cc0-bcf2-4946-81ac-95e16c48034e
serviceRequestId: 32157d18-7851-4268-88b3-bf492f33eb3e

Any help or advice would be greatly appreciated!

Categories:

Building flows

PowerAutomate-Wor...

PowerAutomate-Err...

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Silly question but in the pictures you have a file listed, but how did you get the file name, when you didn't grab it from the Trigger?

Did you simply type something in so we could see it? Did you do a Folder / Browse / Select?

Because you should be grabbing the File location etc from the Dynamic Outputs of the Trigger.

Was this reply helpful? Yes No
BB-03031942-0 4 on at

Like (0)

Report

Thanks for the reply!

I was reading an online guide (Reddit or stackoverflow I think), that showed how to use the 'When file is created' action, and this was how it was setup. The location and Document Libruary, only have fixed options, so I assumed OneDrive for Business, and OneDrive were correct. The File, I'd tried the dynamic content of 'Name' but it didn't seem to work. I'm open to modifying it, if there's a better way?

This way did work, when I was saving the file locally, setting the table, then copying over to the OneDrive PowerAutomate folder. it just doesn't seem to want to work with Get Table or Create Table.

FileLocation.png

Was this reply helpful? Yes No