Accepted Solutions
This is how the flow should be structured if you include 'Get items' and using the output from 'Get items' in the email.
Hello @Dorinda ,
maybe you could use a loop in the flow. I don't know what your flow looks like, but if you need to repeat the same set of actions, you can initialize an array variable with the input (I guess the SP groups in your case), and use 'Apply to each' to loop through the array with the SP groups and repeat the actions for each of them.
@Dorinda I think so it will work. I did not test this. Pass all group IDs in array as @tom_riha suggested. For each group ID make your HTTPS connection URI -->Parse JSON:
For each group ID it will add all emails in Group variable which you can use in email.
Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.
Hello @Dorinda ,
first step is to put all the Site Group IDs into an array variable. The input must consist of opening [ , closing ] and comma separated values in quotes. You must enter all the IDs manually.
[
"GroupID1",
"GroupID2",
"GroupID3"
]Once you have the IDs in the array, you can use 'Apply to each' to loop through that array. 'Apply to each' will take the GroupIDs from the array one by one and give you the value in the 'Current item' dynamic content. You should use the 'Current item' dynamic content as the group ID in the HTTP call.
And also the rest of the process you need to repeat for each of the groups must be inside that 'Apply to each'. 
- 'Apply to each' 1st loop: 'Current item' = GroupID1; HTTP request: '_api/Web/SiteGroups/GetByID(GroupID1)/users'
- 'Apply to each' 2nd loop: 'Current item' = GroupID2; HTTP request: '_api/Web/SiteGroups/GetByID(GroupID2)/users'
- 'Apply to each' 3rd loop: 'Current item' = GroupID3; HTTP request: '_api/Web/SiteGroups/GetByID(GroupID3)/users'
So I have not errors and it appears to be working to send emails to me but the other members of the groups didnt get anything. It is showing that it is going through the different groups, but I am the only one getting emails.
I have more groups just didnt want to run them all at once until i knew it was working.
I'd say your flow is more complicated than it needs to be, you're combining both of the approaches mentioned in this thread and I'm a bit lost in it. 🙂 I'd do it as on the screenshots below:
If you need to repeat the same process for multiple items (I see you're using 'Get items' in the flow), then the whole 'Apply to each' part on the screenshot above must be inside another 'Apply to each' where you'll process the items one by one.
I sorta started over as you instructed.
I am getting the following error
The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['properties']?['properties']?['properties']?['d']?['properties']?['properties']?['properties']?['results']' is of type 'Null'. The result must be a valid array.
Something is probably looping too many times. 🙂
To run the flow only on 10th and 15th each month I'd use a trigger condition (3 dots on the action -> settings). Schedule the flow to run daily with a trigger condition that will check if the 'days' part from today's date is 10 or 15. If true, run the flow, otherwise don't do anything.
@or(equals(int(utcNow('dd')),10),equals(int(utcNow('dd')),15))
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
