Flow to check when a new app is created in the Default Environment

[hfdigital]

Hi there,

I've created a flow using the Get Apps as Admin Action where I can specify the environment I want to target.

I want to send an email when a new app is created in that environment.

My flow steps are:

However, the condition doesn't trigger when a new app has been created.  
In the condition statement I have: createdTime is greater than 

addDays(utcNow(),-1,'yyyy-MM-ddTHH:mm:ss.fff')

As I've created an app to test, it should fire the email advising the Admin that a new app was created.  However, the condition is always resulting in false and not firing the email.

Any ideas?

TIA

[Matthy79]

Hello @hfdigital 

what is the apply to each and the variable for. What do you compare to inside your condition? Have you checked the output of your „get apps as admin“ action. Do you find your app there? What creation date does it have?

[hfdigital]

Apply to each will check all the applications from the previous step and if the condition (

createdTime is greater than 

addDays(utcNow(),-1,'yyyy-MM-ddTHH:mm:ss.fff') is met then the email is fired.

Yes,  I checked the output and I didn't find the app.  I also did a search for the creation date and it didn't return any values.

I'm beginning to think that the Get Apps for Admin is for apps created by Admin?

[Matthy79]

Are you admin on the platform. Did you see any apps in the output. I am admin and tested it and found a lot of apps and viewed the properties and they look good. Also the lastModifiedTime and createdTime look good.

I still don't get what your condition does and the apply to each. What is inside apply to each? How do you check the createdTime? createdTime for example is not in the root, so you have to look under properties.

[hfdigital]

I am an Admin of platform; the flow has been created using the Admin account.

The Apply to each has a value from the output of the Ge tApps as Admin function (outputs('Get_Apps_as_Admin')?['body/value']

The condition applied is:

items('Apply_to_each')?['properties/createdTime']is greater than 

addDays(utcNow(),-1,'yyyy-MM-ddTHH:mm:ss.fff')

which I assume will be reading values from the outputs.

If this condition is true, the Send email will fire.

[Matthy79]

So you have a condition inside the apply to each that we don't see on the screenshot, correct? And inside this condition you set a variable that says true or something like that and in the second condition you check the variable? Is this correct? If so I would really think about a redesign, but first of all we should take a look at the output of the "Get Apps as Admin"-Action, because if you don't find the apps there the best flow design won't work.

Do you see any apps from the output? What are those apps? Can you see a logic why you see some of them and others not?

[hfdigital]

I'm inspecting the outputs.  What is strange is that when I set the Page size to 250,  I need to download the outputs. I can see the createdTime values albeit none for today

When I set the page size to 10 the outputs are shown onscreen.  HOWEVER, when I inspect the data, there is no TimeCreated property.

Why would the Get Apps as Admin produce different resultsets based on the Page Size?  Surely the structure of each app is the same?

[Matthy79]

I can't confirm what you just described. If I change the Page size it gets less items (10 in my case) but the properties for those 10 items are the same. Because the data is not as much it is visible directly in the output. If it is too large you have to download it. This is also a normal behaviour. But I always see the field "properties/createdTime". So what you say is that if you copy all the data and search for "createdTime" you won't find it?

[hfdigital]

Yes.  That's exactly what I'm saying. 

I'm going to run the flow again with the different page sizes back to back and inspect them carefully again - just to make sure.

This seems like such a simple thing to do and it's proving to be not so simple after all.

[Matthy79]

I would suggest you create a ticket. I can say, that I do not have the same behaviour but of course there can be so many things that happen here. Sometimes it is really frustrating to waste so much time on little things.

[hfdigital]

Hi,

I have changed the order of the steps to:

The output now shows the createdTime regardless of the page size.  However, still not triggering the email.
You mentioned that it is working for you.  Are you using the same Actions?

[Matthy79]

I still don’t get the variable, loop and condition part. How many mails do you want to send? For each app? What should be the content of all those mails?

[hfdigital]

Basically, I want to loop through and check for any new apps in a specific environment on a daily basis.

If any new apps have been created an email for each new app is sent detailing the app name, app owner, etc. If no apps have been created then a standard email with the message 'No new apps created today' is sent.   
The latter email is always triggered even though I've manually created an app in my target environment.

[Matthy79]

OK, this should work for you.

[hfdigital]

Thanks.  However, I'm not seeing the 'Filter New Apps' or 'New Apps found' actions.  I'm logged in as the Admin user....

Any ideas?

[hfdigital]

These are the only Data Operations that are exposed:

I've used  Filter Array:

The following are the Controls that are exposed in our environment.  

I'll play around with the Do Until and/or Apply to Each action to see if I can achieve the result I'm after.
Thanks for your help

[Matthy79]

I just renamed the actions for better readability. This is the first thing everybody should do when adding an action. Since Power Automate has problems doing this afterward, I always do that automatically when creating new flows.

"Filter New Apps" is "Filter array"

"New Apps found" is "Condition"

"Apply to each new app" is "Apply to each"

Since you are an admin, I thought this is clear.

[hfdigital]

Nearly there:

NB I have access to the Admin Account in order to create this flow.  I'm not an Administrator per se.
Thanks for your help.

[Matthy79]

Does the flow look like my flow? Did you name all the actions the same and are they in the same order? Please expand all actions and make a screenshot like I did.

[hfdigital]

Yes.  

By adding the Body to the New Apps Found action, the flow saves. Not sure if it works - will check later.