You’re offline. This is a read only version of the page.
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.
Hi @derekkruzicki ,
Please try to delete the 'Current item' in Apply to each 2 and update the following expression:
Share
Report
All responses (
Answers (items('Apply_to_each_6')?['LookUpColumnName']
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!
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.
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
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
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
