question

HedvallLina-8737 avatar image
0 Votes"
HedvallLina-8737 asked ·

Saving files coming from Forms in Sharepoint list

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.

office-sharepoint-online
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @HedvallLina-8737 ,

Does the reply help? Is there any update about your issue?

0 Votes 0 ·

Hi, @HedvallLina-8737 ,

I am checking how things are going here. Feel free to reply with any update. And please accept the reply as answer if it helps. This will help other community members with similar question to find the solution easily.

0 Votes 0 ·
MahyarKamalinafar-3943 avatar image
0 Votes"
MahyarKamalinafar-3943 answered ·

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.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JerryXu-MSFT avatar image
0 Votes"
JerryXu-MSFT answered ·

Hi, @HedvallLina-8737 ,

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.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.