cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Sharepoint Document List Loop

I'm stuck trying to figure out how this will work.

 

I have a document list (see picture below) that has the following columns with examples

Document NameBPEmailStatusSol_RFP_RFI_RFQ
Word Document.docUnprocessed001
Capture.imgUnprocessed001
Bring.pdfUnprocessed002
Kain.pdfEmailSent003

 

1) First the flow should only look at BPEmailStatus = Unprocessed

2) Then it should loop through based on Sol_RFP_RFI_RFQ

3) For each Sol_RFP it should send 1 email and attach all of the documents associated with those rows

 

Is this possible? Which actions do I use?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Sharepoint Document List Loop

Hi @TesDA 

 

You need to use union expression to get unique list items. Once you had the unique items then iterate in a loop to get all attachments.

 

https://powerusers.microsoft.com/t5/General-Power-Automate/microsoft-flow-get-all-items-with-distinc...

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

Re: Sharepoint Document List Loop

Hi @TesDA 

 

You need to use union expression to get unique list items. Once you had the unique items then iterate in a loop to get all attachments.

 

https://powerusers.microsoft.com/t5/General-Power-Automate/microsoft-flow-get-all-items-with-distinc...

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

Highlighted
Helper V
Helper V

Re: Sharepoint Document List Loop

@abm 

 

For some reason I'm not getting an option to select a list in "Get items."

 

I created my list originally by creating a Teams site, and then I have the documents saving to the teams site in a Library.  Do you know what I should put in that section?

 

teams.jpg

Highlighted
Helper V
Helper V

Re: Sharepoint Document List Loop

Fixed this by switching everything to a list. I'm still working through the post that @abm gave

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (3,323)