Question on keeping a file type when transferring to one drive

[IU_1]

Hi all,

My team was recently attempting to pull excel files from a reoccurring email release to a onedrive folder. Some of our teammates would then reference these folders through power bi for our reporting. I've set up workflow that moves a file from outlook using "when a new email arrives v3", "Get Attachment V2", and "create file"; however, when the file is moved to one drive it is in a general "file" format and no longer an excel.

Does anyone know of a method to perform this while still ensuring the onedrive transfer remains as an excel instead of a generalized "file" version? 

Thanks for any assistance and direction that can be provided! 

[ekarim2020]

See: How to save PDF email attachments to OneDrive for Business using Power Automate but change the file extension to xlsx.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[amitlalms]

Thanks! @ekarim2020 appreciate your inputs and blog link. Actually, I'm looking to Upload directly to OneDrive, not via email attachment.

[ekarim2020]

Are you able to share the flow?  I dont think I have understood the problem.

Ellis

[amitlalms]

Here is the flow I'm building...Need a file in OneDrive to load to trigger, if not uploaded in 10min. it will terminate.  

[ekarim2020]

---

@IU_1 wrote:

Hi all,

My team was recently attempting to pull excel files from a reoccurring email release to a onedrive folder. Some of our teammates would then reference these folders through power bi for our reporting. I've set up workflow that moves a file from outlook using "when a new email arrives v3", "Get Attachment V2", and "create file"; however, when the file is moved to one drive it is in a general "file" format and no longer an excel.

Does anyone know of a method to perform this while still ensuring the onedrive transfer remains as an excel instead of a generalized "file" version? 

Thanks for any assistance and direction that can be provided! 

---

@amitlalms  I'm still none the wiser about the issue. Is your issue relate to the initial post above?

@amitlalms  Is your Power Apps running a flow to create a file in OneDrive? Some thing like:

Or, perhaps you need a flow that is triggered when a new file is created in OneDrive?

Ellis

[IU_1]

Thank you for the assistance! However, I still seem to be running into the issue where what is actually being uploaded into onedrive is just an item listed as file instead of an xlsx version. Is there a way for the uploaded version to be in the from of the original attachment (in this case an xlsx) or will power automate always default to the generic "file" file type? 

Image below shows how these arrive in onedrive:

[ekarim2020 · Accepted solution]

It seems that the filename is missing the file extension (such as .xlsx, docx and pdf etc), hence the generic file type you are seeing in OneDrive. You are probably saving the file with Filename only - without the file extension.

Can you share screenshots of the flow? The flow would resemble something like this:

 

Just change the condition to check for xlsx file type:

 

 

Ellis

[IU_1]

Thank you for the above solution!

You were correct and it looks like the issue was that I was missing the "attachment name" field at the end of "file name" section on the "create file" step. 

Everything seems to be working now, thanks!