Sending an Excel file every day from OneDrive to a specific email

[Omer_K]

Hello friends,
I'm pretty new to the amazing Power Automate.
I'll be glad to receive your help,
I want every day (at a specific time) to send an email with an Excel file attachment that I have in the One Drive to a certain email - I tried to play with it a bit but unfortunately you got lost 😞
I'll be glad to receive your help
Thank you
Omer

[gabibalaban]

@Omer_K ,

it is a little bit unclear to me, is the same Excel file updated daily and need to be send or is a new file every day? 
If is the same file, the flow should be an easy one. 
Use the following actions:

1.Start with a recurrence trigger set in every day;

2. Use an OneDrive - Get file content action and set the id parameter to your OneDrive Excel file.

3. Use a Outlook - send an email action, set the To, Subject and Body parameters as you need and to attachment set a file name as you want and the file content - body(‘Get_file_content’) (like the name of the actions from step 2 but with _ instead of spaces)

[Omer_K]

Thank you so much Gabi for the quick reply 🙂
It's definitely the same file,
I do the same steps you recorded but when I run - the third step fails,
Just for the avoidance of doubt, the third step is to add File Content, right?
The following error message:

The request failed. Response content: '{"status":400,"message":"Number of options (460) exceeded the limit (100).\r\nclientRequestId: 26d940c4-4670-4f33-865d-88ddada21fc6\r\nserviceRequestId: 87a2ff5d-efe1-f92f-dc3e-9170eb5a1d71","source":"https://office365-we.azconn-we-01.p.azurewebsites.net/mailwithoptions/$subscriptions","errors":[]}'.

What I'm doing is wrong?