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

When a file is uploaded, create new item list with the file as an attach

I want to do the following:

1. Upload multiple files in a folder

2. For each file, a new list item is created and its attachment is that file

3. This means each file will have corresponding list

 

I tried doing the following workflow but it does not seem to work:

 

1. When a file is created in folder

2. Create item

3. Get file content

4. Add attachment

 

What is the correct/better way to do this?

1 ACCEPTED SOLUTION

Accepted Solutions

@rinamonash 

 

Created a sample to address your requirement:

7.JPG

 

Note: In the above screen shot, I am filtering the file with column named ItemCreateFlag eq 'No'. This will return only files whose ItemCreateFlag column marked as No.

 

Here is the rest of the flow:

8.JPG

9.JPG

 

Please review the above flow and let me know if you have any questions.

 

If my reply helped, please mark it as Accepted Solution.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

View solution in original post

3 REPLIES 3
rsaikrishna
Dual Super User
Dual Super User

@rinamonash 

 

The steps you mentioned will work. I gave a try and it is working.

 

1.JPG

 

Important Note: If you upload lot of files (may be 100 or 200 or more) at time, you may observe that some items may not be created due to flow throttling. Each action in the flow is an API call. 

 

I recommend following approach:

1. Create document library with a column ItemCreationFlag.

2. Create a flow with Instant or Scheduled

3. Get files from the document library whose ItemCreateFlag = No

4. Create item and attach the file to the item.

5. Update the file's column ItemCreationFlag column to Yes.

 

The above approach will avoid Flow Throttling issue and you can also track which items are created with flag ItemCreationFlag column value.

 

Please let me know if you have any questions.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

How can I do steps 3 and 5?

@rinamonash 

 

Created a sample to address your requirement:

7.JPG

 

Note: In the above screen shot, I am filtering the file with column named ItemCreateFlag eq 'No'. This will return only files whose ItemCreateFlag column marked as No.

 

Here is the rest of the flow:

8.JPG

9.JPG

 

Please review the above flow and let me know if you have any questions.

 

If my reply helped, please mark it as Accepted Solution.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (2,145)