Currently have a flow that creates a CSV table from a SP list and sends it to the Created By users. How can I use the filter array action to send each Created By user only the items they entered into the SP list? I don't want them seeing everyone else's items, just the ones they created in SP

(0) Share

Report

Posted on by me95

109

Below is my current flow with pictures at the bottom

1. Recurrence

2. Getting items from a SP list that are labeled a certain status

3. Creating a CSV table

4. Initializing Variable - I used this as a workaround because when sending the email, it would immediately Apply to Each so I did this to ensure only one CSV file was sent per input and it wasn't applying to each when sending the email

5. This is part of my work around from above

6. Send the email with the CSV output as an attachment

I was told a filter array could help with my issue - but how / where would it go in my current flow?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Manish Solanki 15,109 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @me95

If you are looking to send csv table to all the created by users in a single email then pls replace 'Set variable' action with 'Append to string variable' action as shown below. In 'Append to string variable', we will select Created by Email property from dynamic contents and append with ';' (semicolon):

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
me95 109 on at

Like (0)

Report
Copy link

Link copied!

@ManishSolanki thanks for the input. Currently, I am indeed able to send a single CSV to all the Created By users with all the inputs. However, what I want to do is only send each person the inputs they made in a single CSV. For example, if Amy created 5 inputs, Bob created 2, and Mark created 3, I want Amy to receive her 5, Bob to only receive his 2, and Mark to only receive his 3. I don't want each user to receive all 10 inputs in the CSV

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,109 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @me95

Here is my accepted solution on one of the similar previous posts:
Solved: Merging Excel Rows Into Single Email - Power Platform Community (microsoft.com)

The only difference is that there data has been pulled from excel sheet instead of SharePoint list, rest the logic of sending emails is same. I hope you will able to resolve your problem by referring the above link.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
me95 109 on at

Like (0)

Report
Copy link

Link copied!

hi @ManishSolanki Im not trying to merge Excel rows into a single email. I'm trying to only send emails to the created by users with just their items and no one elses items

Was this reply helpful? Yes No
Matthy79 4,186 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @me95

Have you even read the solution provided in the other thread or did you stop reading at the subject? The provided answer is correct and can be used for your flow perfectly.

Was this reply helpful? Yes No
Manish Solanki 15,109 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @me95

The title of the post was misleading, so it created confusion, I apologies for that.

Here is the complete flow:
1. The first two actions are correct and do not require any modification, those are 'Recurrence' & 'Get items' actions.

2. Next, we will create an array of created by emails using 'Select' action. You need to click on the button to switch map to key value mode and write a formula in the expression window:
Expression used in the above screenshot:
item()?['Author/Email']

3. Now, we will remove the duplicate email addresses obtained in 'Select' action using union() formula and start iterating them using 'Apply to each' action:
Expression used for 'Apply to each' action:
union(body('Select'),body('Select'))
Expression used for 'Compose' action:
item()

4. Continue inside 'Apply to each' action, add an action to filter the records based on the current item in the iteration:

5. Next, create a csv table using 'Create a CSV table' action, this step will also be added inside 'Apply to each' action:
Here, I have used only Title column but may add more columns as per your need.

6. Finally, continue in 'Apply to each' action, send an email with the required attachment:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No