cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LeoApril
Frequent Visitor

How to save MS Form attachment to Sharepoint directly?

HI there

Previously i have created a flow that save MS Form attachment into Sharepoint directly without going through OneDrive. But now i looked back at the code, there isnt anything that change the attachment directory to Sharepoint. 

 

To be frank, i also dont know how i do it... So now i want to create a new flow that do the same thing without going through OneDrive but i cant seems to do that and i did some research, the attachment will always go to OneDrive and we need to use certain flow function to pick that up and put it in Sharepoint.

 

1) Is there anyone that can help to guide a way for me to save my attachment to Sharepoint directly without going through OneDrive?

2) If there's no way to do it then can share how to get the MS Form attachment and send it out using email without busting my OneDrive space (if i not wrong, there shld be a limit to the space)?

3) Also, i always cant get the file extension in my email attachment. Is there a site where i can see how to get the extension for my email attachment?

 

This is the Flow for my previous Flow which can save to Sharepoint directly (in condition 2, its just email without attachment) but i used first(body('Parse_JSON'))?['link'] for a link in email to substitute my deficiency in attachment with extension)

:

LeoApril_0-1621772351546.png

 

Sorry for the long post but its really baffling me for a long time.. Also thanks in advanced for any reply. 

1 REPLY 1
Pstork1
Dual Super User
Dual Super User

1) MS Forms saves the attachment files to OneDrive, so there is no way for Power Automate to get the files without going through OneDrive.

 

2) First, can we clarify are you on OneDrive or OneDrive for Business?  Normally this would be OneDrive for Business and that has 1TB of space by default so space won't be an issue.  Also if you don't need the file after emailing it you can have the flow delete it and free up the space.

 

3) The name of the file in OneDrive will include the extension.  You can retrieve it by using a split on '.' and then retrieving the Last() entry of the array.

 

You might find the blog post I did on creating approvals for files submitted through MS Forms would be useful.

What Me Pa..Panic? – A BLOG about SharePoint & O365 Administration, Design, Development, and Customi...



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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,233)