How to add an excel attachment to a list item

%3CLINGO-SUB%20id%3D%22lingo-sub-2579816%22%20slang%3D%22en-US%22%3EHow%20to%20add%20an%20excel%20attachment%20to%20a%20list%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2579816%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20upload%20an%20excel%20file%20to%20all%20the%20items%20on%20my%20sharepoint%20list%20all%20at%20once%20if%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2579816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2580059%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20an%20excel%20attachment%20to%20a%20list%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580059%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1080367%22%20target%3D%22_blank%22%3E%40jcurrie94%3C%2FA%3E%26nbsp%3Bto%20add%20an%20excel%20file%20to%20all%20items%20in%20a%20list%20at%20the%20same%20time%20you%20would%20be%20best%20to%20use%20a%20simple%20flow%20in%20Power%20Automate.%20The%20overall%20flow%20looks%20like%20this%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220-Flow.png%22%20style%3D%22width%3A%20587px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298044i955090FE2A546F82%2Fimage-dimensions%2F587x417%3Fv%3Dv2%22%20width%3D%22587%22%20height%3D%22417%22%20role%3D%22button%22%20title%3D%220-Flow.png%22%20alt%3D%220-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20get%20items%20action%2C%20if%20you%20have%20more%20than%20100%20items%20in%20your%20list%20you%20will%20need%20to%20click%20the%203%20dots%20at%20the%20top%20right%20of%20the%20action%2C%20and%20select%20settings%3CSPAN%3E.%20In%20the%20screen%20that%20opens%20turn%20on%20the%20pagination%20toggle%20and%20set%20the%20threshold%20to%20more%20than%20the%20number%20of%20items%20in%20your%20list.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20get%20file%20content%20using%20path%20actin%20is%20the%20location%20in%20OneDrive%20for%20Business%20where%20your%20excel%20spreadsheet%20is%20stored.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Flow.png%22%20style%3D%22width%3A%20710px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298046i5710BE09B9ED4701%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-Flow.png%22%20alt%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20add%20an%20apply%20to%20each%2C%20select%20value%20from%20the%20dynamic%20content%20box%20then%20add%20an%20add%20attachment%20action%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Flow.png%22%20style%3D%22width%3A%20738px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298045i0986E4DF32FD8ABE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-Flow.png%22%20alt%3D%222-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am looking to upload an excel file to all the items on my sharepoint list all at once if possible.

1 Reply

@jcurrie94 to add an excel file to all items in a list at the same time you would be best to use a simple flow in Power Automate. The overall flow looks like this:

0-Flow.png

 

In the get items action, if you have more than 100 items in your list you will need to click the 3 dots at the top right of the action, and select settings. In the screen that opens turn on the pagination toggle and set the threshold to more than the number of items in your list.

 

The get file content using path actin is the location in OneDrive for Business where your excel spreadsheet is stored.

1-Flow.png

 

Then add an apply to each, select value from the dynamic content box then add an add attachment action:

2-Flow.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User