Microsoft
MicrosoftZogler2235 I got mine to work, excluding expired apps.
I created a new variable called expirydate and also added a new action called current time
Then in the "foreach - passwordCreds" & "foreach - keyCreds" loops, I Parse JSON "Body endDateTime"
And finally added a new Parameter into the "Future time is greater than endDate - passwordCreds" & "Future time is greater than endDate - keyCreds" parallel branch, current time is less or equal to expirydate
There is probably a better/cleaner way of doing this, but this is my solution.
Hi RickyG-86 thank you for sharing, but could you explain in more details what you did for this step "Then in the "foreach - passwordCreds" & "foreach - keyCreds" loops, I Parse JSON "Body endDateTime" " when I ran mt test it was running for hours. Thanks
bril1598
In the "foreach - apps" loop there are 2 variables, "Set variable - passwordCredentials" & "Set variable - keyCredentials" which are needed in the "foreach - passwordCreds" & "foreach - keyCreds" loops.
This is the code of the "Set variable - passwordCredentials"
eg. for every AzureAD Application populate the variable
{
"type": "SetVariable",
"inputs": {
"name": "passwordCredentials",
"value": "@items('foreach_-_apps')['passwordCredentials']"
},
"runAfter": {
"Set_variable_-_displayName": [
"Succeeded"
]
}
}
Then, if the variable has a value, run the loop.
Next I have a "Set variable - password expirydate", which gets the expiry date from the current AzureAD Application in the loop
{
"type": "SetVariable",
"inputs": {
"name": "expirydate",
"value": "@item()?['endDateTime']"
}
}Which goes into a condition expression.
"type": "If",
"expression": {
"and": [
{
"greaterOrEquals": [
"@body('Get_future_time')",
"@item()?['endDateTime']"
]
},
{
"and": [
{
"lessOrEquals": [
"@body('Current_time')",
"@variables('expirydate')"
]
}
]
}
]
}This is what it looks like