Saving files coming from Forms in Sharepoint list

Hedvall, Lina 1 Reputation point
2021-03-09T09:09:18.55+00:00

Hi!
I have created a Microsoft Forms. That is linked to a SharePoint list by Power Automate. It works very well with the written answers. But I have issues with the uploaded files.
The files are saved to my OneDrive and I do not know how to get them into the right list object.

Is there any one who has a tip for how I either
could save the files directly into my list object or
match the right list object with the right file

The list is visualised in Microsoft Teams if that matter.

I would be so greatful for any advice.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,615 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mahyar Kamalinafar 76 Reputation points
    2021-03-09T17:49:10.62+00:00

    Hi,

    If you create a msft teams group and create the form under there it will save the files in a sharepoint library rather than your onedrive (longevity of the form).

    For the file you will need to use the Get file content connector first then the add attachment connector after your line item is already created.

    So: Get Response Details > Create Item > Get File Content > Add Attachment

    Looking at my flow there is a parse json after get response details, but i think it auto did that for me like it does the apply to each that exists in my flow as well.

    0 comments
  2. Jerry Xu-MSFT 7,921 Reputation points
    2021-03-10T02:27:52.153+00:00

    Hi, @Hedvall, Lina ,

    If the solution below not work well for you, please provide more information about your current setup. How do you set the flow, forms and list?

    As you are using Power Automate to link the response to SharePoint list, I assume you use the Create Item action to add a new SharePoint list item with the information. I will not suggest using attachments. It is not quite convenient for future use. As you only want to have a connection between the item and the file, just add a new column called item location to store the URL of the file in OneDrive. We can create a hyperlink column, or a single text column to hold the URL. For hyperlink column, just fill in the link when you create the item. The only possible issue is that, if you want to use a description text, it will be needed to send a Http Request instead of filling the value directly.

    If you want to add a description text while not willing to use a http request, using a single text column is also a choice. JSON formatting will help to convert the text to link.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments