I'm working with a client that needs automatic reporting on per user licensing based on groups, this can be obtained manually but Automaticaly is causing me a head ache
So far I have designed a flow that pulls the users in a group from AAD and once its done that it checks each user against the MS graph https://graph.microsoft.com/v1.0/users/@{items('Apply_to_each')?['id']}/licenseDetails
this element works fine, and Almost gives me what I need, the problem is it response in a JSON format with firstly allot more info than is needed but also in information that needs correlating.. (license type would appear as the below), this is a snip from the response.
thanks. I got it. i did parse json but power automate automatically suggest you do something thats wrong.
iinstead of the correct:
@body('Parse_JSON')?['value']'
https://powerusers.microsoft.com/t5/General-Power-Automate/Problem-with-Parse-JSON-is-of-type-Null-The-result-must-be-a/m-p/1590157#M92212
figured it out thanks to @vivekpande18
i cant loop over body parse json as its type object, and when i try to loop over body parse json [value] i get that its null
i cant get that to work. any tips
Parsing the JSON is your only way.
messages?$filter=flag/flagStatus eq 'Complete' this works in send an http request
this does NOT work in the get emails v3 search query/search filter property
the problem is i do not know how to work with the 'send an http request' from outlook activity as the body is not iterable as its an object not an array and parsing the json is too complicated from the schema.
Could you share the request?
how do i use apply to each from the body payload of outlook send an http request. parse json too complicated. i pasted in the schema and i get schema validation failed and when i try to loop over the body of send an http request for outlook emails i get its an object and not an array so i cant apply to each it.
please help
i want to fetch/get all emails in outlook that have flag status eq is completed (green checkmark)
Unfortunately that didnt work, MS graph refused the body request
I managed to get a workaround though
WarrenBelz
146,765
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional