Answered

Want a flow to grab attachments from one list and populate another list if columns match

(0) Share

Report

Posted on by derekkruzicki

I am working on a requisition list of orders and a second list for delivery list. I want the delivery list to pull from multiple items in the requisition list and just pull the attachments over to the delivery list. I have a column in the delivery list that says which requisition items are included in that delivery item. So it may include one to 5 different requisition items and I want it to only grab the attachments of each of those requisition list items.

I've made a few flows, but pretty new still and I can't get this one to continually work and get errors.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @derekkruzicki

Could you pls confirm the columns in two lists that makes up the mapping? I mean column 'Req number' belongs to list "Packing list" or "Requisition".

Thanks

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

Report

Hi @derekkruzicki ,

Is the 'Req Number' column a lookup column for the ID column? I recommend that you create two flows to increase the speed of the flow, and the first flow runs only once, getting attachments to tables that are not currently modified. The second flow is triggered when the SP's item is modified, and only the currently modified Item is updated.
My test:
"test0927" is equal to delivery list which has a look up column.
"test08188" is equal to requisition list which has attachment.
The first flow: Get items connects to delivery list which has a look up column.
Get items 2 connects to requisition list.
1)

2)The value is about the Get items 2.
"lokupID" is the look up column in "test0927".

3)

The second flow:
1)

2)

Hope this helps you!
-----------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
derekkruzicki 4 on at

Like (0)

Report

Rimmon, Thanks for helping. I'm pretty new to everything; I can't find that lookup column in the get attachments step on the first flow. See below. I am trying to recreate your example. Is there a way to get that column option to show up in my Dynamic Content? From your original question, My Req Number is a column in Delivery list that looks up the ID column on Requisition List and can have multiple Requisition List IDs in it like a one to many relationship.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @derekkruzicki ,

Please use the 'Search dynamic content':

Best regards,
Rimmon Li

Was this reply helpful? Yes No
derekkruzicki 4 on at

Like (0)

Report

If found the dynamic content to add that. After adding it, i run into issues in creating this flow when i put in "get attachment content, Flow want to add another loop and then this doesn't match your example and doesn't work. See below:

Since I was struggling with the above, I thought I would just keep it similar and start with just running it at the point of just get the attachment.

- I get a 400 error:

Do you have any other thoughts on how to get this going?
Thanks!

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Hi @derekkruzicki ,

Please try to delete the 'Current item' in Apply to each 2 and update the following expression:
items('Apply_to_each_6')?['LookUpColumnName']

Was this reply helpful? Yes No