Power Automate

Unanswered

Get specific items to users from json results

(0) Share

Report

Posted on by _sourcecod3_

407

Hi,

I have a flow which queries a list with the items that were created in the last 7 days. In the results I have entries submitted by users with their corresponding data and supervisors. I need to be able to send an email to their supervisors with the items submitted by the users for these last 7 days. Where i'm getting stuck is where some users have multiple items submitted. The emails to these supervisors should only have the data that corresponds to their employee.

This is what i have so far:

Any help is appreciated.

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@_sourcecod3_
I Suggest you add a compose data operation after the Get Items to get the first record record only first(getitems) and then you can get the user data from there.

Was this reply helpful? Yes No
_sourcecod3_ 407 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly I am getting the data back from the 'Filter array'. the problem is that this data has entries from the same user multiple times. I need to grab all the entries from each user and send those to their supervisors. Any other ideas?

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@_sourcecod3_
Please try the Action Create HTML Table and add the filtered array as an input and then pass the outputs of the Create HTML Table to the Email you are creating.
Sample for Create HTML Table but in your case the From will be the Filter Array and you can choose to generate columns automatically or Create Custom.

Was this reply helpful? Yes No
_sourcecod3_ 407 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly thanks for you responses, but i think we might be misunderstanding the issue. I can get the information once it's parsed from the filter in the array, what i'm trying to do is filter the data retrieved.

sample of data:
user1 activity1 supervisor1
user1 activity2 supervisor1
user1 activity3 supervisor1
user1 activity4 supervisor1
user2 activity1 supervisor2
user2 activity2 supervisor2
user3 activity1 supervisor3

I need to send an email to each employees supervisor with the activities entered by their employee. So i need to grab the empname, their activities and email it to their sup.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@_sourcecod3_
Can you please check my reply on this topic it has similar approach for grouping the data per user.
https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-to-send-digest-emails-to-amp-quot-assigned-user-amp-quot/m-p/683315#M57158

Hope this gives you an idea!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Get specific items to users from json results

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the December Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

user1	activity1	supervisor1
user1	activity2	supervisor1
user1	activity3	supervisor1
user1	activity4	supervisor1
user2	activity1	supervisor2
user2	activity2	supervisor2
user3	activity1	supervisor3

Community site session details

Get specific items to users from json results

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the December Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates