Noted, thanks :)

I would expect it to take over 10 minutes for that many, the for-each loops take a long time. You might try setting the degrees of parallelism to 1 in the settings on the loops - slowing it down actually speeds it up because it keeps you from getting throttled. Are you looking for the append to members array text? That one is this: { "upn": "@{items('Apply_to_each_group_member')?['userPrincipalName']}", "userId": "@{items('Apply_to_each_group_member')?['id']}", "groupId": "@{items('Apply_to_each')?['id']}", "userRole": "Member" } Append to owners array is this: { "upn": "@{items('Get_owners_for_each_group')?['userPrincipalName']}", "userId": "@{items('Get_owners_for_each_group')?['id']}", "groupId": "@{items('Apply_to_each')?['id']}", "userRole": "Owner" } The compose step after that is this: [ @{variables('groupMembers')}, @{variables('groupOwners')} ]

🤣

It's always the typos with the hand-typing JSON! :)

I would just drop the modified date into the filter pane or a slicer - there's a relative date option there that will let you do last x days/months/years. You'd only need DAX if you were trying to measure something related to the modified date (like counting stale groups).

There’s not a direct query source for this that I’m aware of. You could schedule this for once a day though, I can’t see a reason that you’d need it fresher than that in normal use.

I don't think you can query the timestamp that a user was added to a group with this - I think you'd have to get that from the audit log activity data. My guess is the created datetime for a user is the date the user was created. If you're trying to get group membership though, I would query to get the group ID with the "starts with" first, then do a second query to get the members of that group ID instead of trying to do both in the same query.

If you're in modern UI, switch to classic. It's not in modern yet. Also make sure to search for it, it's not there unless you search. Lol.

Oh totally, there’s a separate action for that - I think it’s called “list group members” and it has you select a specific group. If you search for “Groups” there’s a whole set of actions to do things with specific groups. :)

User permissions are in the Power BI Admin API: learn.microsoft.com/en-us/rest/api/power-bi/admin/users-get-user-artifact-access-as-admin The PBI admin API is on my to-do list for sure, it’s just a matter of time - been short on that lately. 😅

Are you in the new UI? Try toggling it off if you are, it's missing a lot of the dynamic content cards.

@@bi-ome Christine, thank you for you response. No, I am using the old UI. Is there any additional step I need to do before create this flow?

Querying APIs directly in PBI is a pain, particularly when you get into pagination… if I were to do it anywhere serious it’d be a real ETL tool to put it in a database table, but this isn’t a data engineering channel. SharePoint is as secure as the site you store it in… I would not put this in a public site obviously, but I think it’d be fine in an IT team site or similar. In the grand scheme of things user and group membership is not particularly sensitive in comparison to what is regularly stored in SP in everyday use.

Yes, you can either just put a list of the group IDs in an array and loop over those if you know which you want, or you can use filters on a Graph API query to get a list of specific groups on some criteria: learn.microsoft.com/en-us/graph/filter-query-parameter?tabs=http (then use the resulting group IDs in your loop).

@@bi-ome thank you! And do you know maybe a way to get a date of when user was added to the group?

I think you'd have to query the audit logs for that. I found a thread on it here but there's not a ton of info on this. The audit log history only goes back so far, too, so you'd have to store it when you query to build a history: stackoverflow.com/questions/76235207/how-can-i-find-when-a-user-was-added-to-an-azure-ad-group-using-the-microsoft-g

@@bi-ome and do you know maybe how to query GRAPH API through “run query against a dataset” with just one column with emails?

I think you could probably use the HTTP action to call the Graph API to get this. I can't find an example in the documentation, but this thread has an example where they get groups for a specific user that would probably work. You'd use this on the MS Forms trigger for when a response is created and pull the submitter's username from the trigger (you might need to get their user ID from the "get user profile" first, I can't recall if the email will work directly). edit - forgot the link: stackoverflow.com/questions/73048102/how-to-receive-list-of-groups-that-user-is-member-of-in-powerapp

Hmm, I'm not sure offhand why that would be. I vaguely recall testing this with a non-privileged test account so I don't think it's permissions. Is the HTTP connector blocked perhaps? Or double check the code, usually when I get internal errors with these it's because I forgot a comma or a bracket or something.

@@bi-ome appreciate your reply to my comment. I figured out I had enclosed Group ID in the graph query within curly braces, after hours of trial removing those worked. Wish the error was more meaningful! In my case I'm fetching Group IDs from SPO list as I need to only report on a handful of Team members. I liked the way you're reporting the result of flow in P BI, really cool :)

Usually this means you have a typo somewhere in there - extra or missing comma, curly bracket, or quotation

Sorry, I've started using UI zoom the last couple months for that reason! 😅 { "userId": "@{items('Apply_to_each')?['Id']}", "upn": "@{items('Apply_to_each')?['UserPrincipalName']}", "managerUpn": "@{outputs('Get_manager_(V2)')?['body/userPrincipalName']}", "displayName": "@{items('Apply_to_each')?['DisplayName']}", "department": "@{items('Apply_to_each')?['Department']}" }

Here you go, this is to get owners - replace the bracket bit with your dynamic content: graph.microsoft.com/v1.0/groups//owners edit... KZfaq does not like the hyperlink formatting, but you get the idea 🤨

Great, thank you!

It helps if you set the video quality, sometimes it will default to low. I have since started using UI scaling but I can’t retroactively fix without re-recording

@@bi-ome It's set to 1080p but still can't make out a lot of the text

From the Apply to each List Group members it seems as though the first Group Id is blank, would this cause the HTTP request to return only the odata.context and value?

Did you possible paste in the content as the example and not the body output? There are a couple of boxes in the flow history for the step, make sure to copy the right one. The schema I used was this, in case you want to just roll with that: { "type": "object", "properties": { "value": { "type": "array", "items": { "type": "object", "properties": { "id": { "type": "string" }, "displayName": { "type": [ "string", "null" ] }, "givenName": { "type": "string" }, "surname": { "type": "string" }, "userPrincipalName": { "type": "string" }, "@odata.type": { "type": "string" } }, "required": [ "@odata.type", "id", "displayName", "givenName", "mail", "surname", "userPrincipalName" ] } }, "@odata.context": { "type": "string" } } }

@@evealsdorf7402 Possibly - definitely feed it an example with data in it! I am not sure how it could have a blank group id, that's strange.