cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KarlheinzRettig
Level: Powered On

Upload file to SharePoint

The idea is to use a Form to collect Categories which are used in a Sharepoint list.

And then using flows to upload the document. In Forms the categories are defined 

Upload to Sharepoint Form.JPG

And these fields should be transfered to a Sharepointpage as below. 
As a final step the document should be uploaded to Sharepoint - with the title defined in Question 2

 

Upload to Sharepoint Form.JPGUpload to Sharepoint list.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

I found the solution outside Flow. It is basically using the Sharepoint functionality in the library and defining the entries there. The user can upload- will get a notification that some fields need to be filled and then the user can select as defined (dropdown, selection, 1 line text , all is possible)

 

View solution in original post

13 REPLIES 13
KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

 

 

 

Community Support Team
Community Support Team

Re: Upload file to SharePoint

Hi @KarlheinzRettig ,

 

Could you provide more explanation about your needs?

Where do the files you want to add in the attachment come from?

Obviously it is not feasible to use Current item to configure the two fields File Name and File Content.

Please provide more details and we would provide proper workaround for you.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

The file should be added from the user, after he filled the Forms. 

 

If this is not the right approach - I can also change the flow that

step 1 - is uploading a file to sharepoint

step 2 - filling the Forms

step 3 - The filled Forms fields is transfered to Sharepoint list fields

 

Community Support Team
Community Support Team

Re: Upload file to SharePoint

Hi @KarlheinzRettig ,

 

What I am struggling with is where does the user upload files? Upload files from Forms or in the SharePoint library?

I am afraid that the demand for me is still very confused.

As far as I know, MS Forms is unable to upload files.

Also, I don't know where the File in Add attachment action you configured should be obtained from.

Please provide more details or tell us what problems you have with Flow currently configured to help us understand your needs.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

Sorry for the confusion.

The file the user has to upload is either in Outlook in an email or on a local folder or on a shared drive. Hope this helps further. 

Community Support Team
Community Support Team

Re: Upload file to SharePoint

Hi @KarlheinzRettig ,

 

What does it have to do with the Flow you created?

Are you going to add the user-uploaded file to the attachment in the list item?

Please provide more details again.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

The Flow above is may be not the right solution. What we intended to do

 

1) The user has a pdf file on the Onedrive, Shared folders, Desktop or Outlook

2) This file is uploaded into  Sharepoint

3) During the upload Metadata have to be defined and updated in the sharepoint list

 

I thought starting from a Form would be a good solution.

Many thanks for your support

Community Support Team
Community Support Team

Re: Upload file to SharePoint

Hi @KarlheinzRettig ,

 

It seems that you don't need to use MS Forms, you could get the metadata of the file directly.

If the user is uploading the file to SharePoint library, you can configure your Flow directly like this:

34.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

The Flow does not start.

I upload a file to the Documents in Sharepoint and then I would expect to be asked to fill out the Year and the Category . But nothing happened.

 

 

Flow not working.JPGUpload of files.JPG

Community Support Team
Community Support Team

Re: Upload file to SharePoint

Hi @KarlheinzRettig ,

 

You don't need to specify Folder. If you specify a folder, you can only trigger the Flow if you create an upload file in the specified folder.

7.PNG

Did the Archive Subfolder you mentioned earlier be the location where the files were originally stored?

Uploaded contracts list is used to record the information of the uploaded file and the information of the uploader? ?

Why do you want to mention Year and Category now, which seems to be inconsistent with your original needs.

 

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

The year and 10 other fileds were coming from the Forms, originally.

But as it is not needed now,  I am looking for another way to to enter this information into the Metadatapart of the Sharepoint columns?

KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

I found the solution outside Flow. It is basically using the Sharepoint functionality in the library and defining the entries there. The user can upload- will get a notification that some fields need to be filled and then the user can select as defined (dropdown, selection, 1 line text , all is possible)

 

KarlheinzRettig
Level: Powered On

Re: Upload file to SharePoint

I found the solution outside Flow. It is basically using the Sharepoint functionality in the library and defining the entries there. The user can upload- will get a notification that some fields need to be filled and then the user can select as defined (dropdown, selection, 1 line text , all is possible)

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,075)