Unanswered

Building workflow to consolidate all records from Doc Lib and send consolidated records to each user

(0) Share

Report

Posted on by domingsun1

Hi All,

I want to build a power automate workflow to check on a document library, each records will have different creator, but I do not have a list of all user, so I need power automate to "Get Items" from doc library and loop thru the records, and consolidate all records belongs to User A then send all the records created by User A via email, then continue loop thru records created by User B, and send the email again.

Currently I not sure how to start with this, please give some suggestion.

Screenshot 2024-01-24 143602.png

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Building workflow to consolidate all records from Doc Lib and send consolidated records to each user

Hi @domingsun1 ,

I've made a test for your reference:

Best Regards,

Bof

Was this reply helpful? Yes No
royg on at

Like (0)

Report

Re: Building workflow to consolidate all records from Doc Lib and send consolidated records to each user

Hi,
you'll need to implement some kind of grouping. To get this done you can do the following:
1. After the Get Files (properties only) action, add a Select action to collect only the Owner Emails into an array
1.1. To get the array of emails simply toggle the Map to Text and select the "Owner Email" field from the dynamic values
2. After the Select action add a Compose action, set it's Inputs to the expression: union(body('Select'), body('Select')). That gets the distinct emails list
3. Add Apply to each action to iterate the Compose outputs (the distinct emails list). Inside the loop, add a Filter Array action filtering the Get Files (properties only) Value (all the document library items) by "Owner Email" equals Current Item (from the dynamic values list).
4. Following that Filter Array action add a Create HTML Table action and set its From field to the outputs of the Filter.
5. Add a Send an Email action and set its To field to the Current Item (again from dynamic values list) and in the email body add the outputs of the Create HTML Table action.

Hope this helps

Was this reply helpful? Yes No