I have a specific requirement and need some guidance. I'd like to set up a flow in Power Automate that does the following:
Has anyone implemented something similar or can provide steps or resources that can guide me in setting this up?.
Thanks in advance for your help!
Okay so I managed to get the flow to run successfully. For the action "Create file" I set the following settings:
File Name: Attachments Name
File Content: Attachments Content
Sure. Hers is the output from the "Create file":
Hi @HamidBee ,
Please look at your output of create file and look at the path. What does it say?
2)
3)
Sorry, I've been unable to duplicate to error.
Here are the screenshots:
Hi @HamidBee ,
I didn't get any errors. Can you please share your expanded flow actions? Here's my results (I've removed the Power BI refresh action for this test):
My hunch is your create file name dynamic content. Please share.
I will test over here.
Yeah sure. When I tested the flow I sent an email to myself with the document attached. The document name is called "SampleSalesData.xlsx" and the subject line is "Monthly Finance Data".
Hi @HamidBee ,
I don't think the folder name is the issue, I also created and saved here. The issue most likely is the file name length. Can you share what the file name is please? I'm guessing the file name is long?
Thanks for getting back to me. I have built the flow using your suggesting and tried testing it unfortunately I'm getting an error when trying to create a file in OneDrive. Here is the error message:
Request-URI Too Long - <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Request URL Too Long</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Request URL Too Long</h2>
<hr><p>HTTP Error 414. The request URL is too long.</p>
</BODY></HTML>
I am trying to save the Excel file in a OneDrive folder I have called "OneDriveFiles". So I set the folder path to:
/OneDriveFiles
Any advice would be greatly appreciated. Thanks in advance.
Hi @HamidBee ,
I think this will work for you, please let me know.
Next apply to each (in case there is more than one attachment). Dynamic content is attachment name and attachment content bytes - fyi
Last step, I refresh a desired dataset.
Here's the entire flow.