topic Re: Power automate fetch updates is not creating a valid input? in ArcGIS Connectors for Power Automate Questions

Power automate fetch updates is not creating a valid input?

MonikaWheat88 — Thu, 31 Aug 2023 14:35:08 GMT

Okay so I am trying hard to understand why some of my flows are working and others are not. I have a few flows that I am trying to post a message in teams for PM's to know when data is being collected.

this first image of my workflow is posting correctly

this second flow is not working - like will not collect or get a trigger

and finally this next one give an error saying The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@outputs('Fetch_updates,_changes,_or_deletions_from_feature_layer')?['body/items']' is of type 'Null'. The result must be a valid array.

any thoughts?

Re: Power automate fetch updates is not creating a valid input?

SarahRijneke — Fri, 01 Sep 2023 13:14:19 GMT

I'm also struggling to understand why some of my flows work and then stop working out of no where. My flow should trigger anytime a change is made to a feature service but I've noticed that it doesn't always run when an update is made. In my example below, someone added a bunch of new features to the assignments feature service on Aug. 30th but the flow didn't trigger at all that day.

Re: Power automate fetch updates is not creating a valid input?

LaraJuliussonUSFS — Wed, 04 Oct 2023 22:22:43 GMT

I am having the same issue with intermittent success of the Power Automate ArcGIS connector. I am running the same trigger and action as shown above and it works much of the time, but I sometimes receive the error The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@outputs('Fetch_updates,_changes,_or_deletions_from_feature_layer')?['body/items']' is of type 'Null'. The result must be a valid array.

ESRI, can you help please!?

Re: Power automate fetch updates is not creating a valid input?

NataliyaLys — Fri, 06 Oct 2023 14:32:05 GMT

I'm experiencing a similar issue. I have a number of flows set up in Power Automate. The flows are listening for feature updates, and when updates are made (and conditions are met) an email get sent and email status is updated.

However, I have been noticing that the flows not always work as expected. I can see that flow is being triggered, but the 'fetch updates' output is empty?

I was told that there is a bug, it doesn't apper to capture the first update that is made.

But in this specific case i have issue with subsequent updates just not being fetched randomly. At least I don't see any patterns. I also openned a ticket with ESRI to see if someone can assist.

Thank you,

Nataliya

Re: Power automate fetch updates is not creating a valid input?

ZacharyHart — Tue, 31 Oct 2023 20:22:23 GMT

@NataliyaLys @LaraJuliussonUSFS

I'm having the exact same issue as well. The flow as built fresh today, working fine, and then suddenly started failing without warning.

Re: Power automate fetch updates is not creating a valid input?

ZacharyHart — Wed, 01 Nov 2023 13:19:50 GMT

@MonikaWheat88 Did you ever figure this out? I have spent a while diagnosing this here at the Esri forums as well as MS PowerAutomate forums. I'm not saying this your exact problem, but here's an observation I had. I had a flow working perfectly fine, I hadn't modified save for a few things in the message being put into the Teams channel.

The error is misleading (well at least in this case) as it lead me to believe that the input from the Fetch Updates step based on the same error you received:

The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@{outputs('Fetch_updates,_changes,_or_deletions_from_feature_layer')?['body/items']}@{body('Fetch_updates,_changes,_or_deletions_from_feature_layer')}' is of type 'String'. The result must be a valid array.

So I went back to my Team channel and looked for the last valid response to make it through. I then attempted to reformat the message output in PA and then the flow suddenly started working again. I don't have an exact before and after but I cleaned some things up and added spaces between each insert parameter in the message. I also didn't change out any of the parameters, like i kept the same editor tracking fields I wanted to see in the message.

~~This is a complete mystery to me, and since looking at your screen shots, it appears what I have discovered may not help you at all.~~ But there are numerous, unsolved posts about this!

This was a false positive. It now appears that there is no discernable correlation between success & failure.

@SarahRijneke I reviewed your post as well; i'm trying a mix of edits/updates: add new text to string field, modify text in a string field, change the attributed on a coded domain field etc. No pattern has arisen yet.

EDIT!: The same flow which I modified and had working fine immediately failed the second time using the exact same test (change to a record).

@AnthonyLatiniHave you seen this thread yet?

Re: Power automate fetch updates is not creating a valid input?

AnthonyLatini — Thu, 09 Nov 2023 23:28:29 GMT

@ZacharyHart @MonikaWheat88 @NataliyaLys @LaraJuliussonUSFS @SarahRijneke
Hello to everyone in this thread! 😀

I am catching up on this and wanted to provide feedback. At the moment, there is a known issue with the Fetch updates, changes, or deletions action. In the issue, the changes that are captured can come back as [ ]. Meaning, there weren't any changes captured even though there might have been a new record created, updated, deleted.

Both @Pavel148 and I have been attempting to track this issue down and are working with the ArcGIS Online team to determine the best way to reliably reproduce the issue and the determine a fix. This issue does not appear to be stemming from Power Automate or the ArcGIS Connector inside of Power Automate, but rather from the layers themselves.

In my experience, when testing this issue, I was able to reliably reproduce it on one feature layer, but then not reproduce it in another.

As a note, everyone appears to have their flows set up properly and you are working through it in the correct manner.

Please sit tight with us as we work to resolve this issue. Thank you all for your patience!

Re: Power automate fetch updates is not creating a valid input?

ssweat — Thu, 30 Nov 2023 15:21:31 GMT

Hi @AnthonyLatini ,

I am having a similar issue. Are there any updates for the Fetch updates feature in Power Automate?

Thanks!

Re: Power automate fetch updates is not creating a valid input?

AnthonyLatini — Thu, 30 Nov 2023 17:16:17 GMT

@ssweat - Hi there! As mentioned in previous posts, we are working to resolve this issue. At the moment, there isn't an ETA, however, this is the top priority on the team to resolve issues surrounding Fetch Updates.

Thank you for your patience on this issue!

Re: Power automate fetch updates is not creating a valid input?

NataliyaLys — Fri, 01 Dec 2023 17:25:37 GMT

@AnthonyLatini

I don't want to get too excited, but I noticed that starting November 30th, around 11am - 12 pm ALL my flows started running successfully.

I believe that there has been update to AGO, is the last day or so. Does that have anything to do with this change?

And here is a screen shot from before Nov 30 (11am-12pm).

Thank you,

Nataliya

Re: Power automate fetch updates is not creating a valid input?

AnthonyLatini — Fri, 01 Dec 2023 19:01:41 GMT

Hi @NataliyaLys -

We have pushed an update (around that time yesterday) to the ArcGIS Connector in Power Automate to fix one of the two issues that have been reported in multiple areas (and thought it would be good to post in this thread). I will be making a larger post about this shortly for the whole board to see. 😀

When the Fetch updates action is called, it returns an empty response

This issue has been tested extensively and appears to be resolved. This issue has been deployed to production.

NOTE: The issue with empty arrays is still under investigation and has not been resolved in this push.

Please let me know if you have any questions or if you see any other additional unwanted behavior.

Re: Power automate fetch updates is not creating a valid input?

NataliyaLys — Mon, 04 Dec 2023 15:29:29 GMT

@AnthonyLatini Thank you for the updates. I just checked all my flows from the weekend, and since the update on the Nov 30th, everything has been running as expected!!! Thank you again for fixing!

Re: Power automate fetch updates is not creating a valid input?

Tiff — Mon, 25 Mar 2024 13:10:57 GMT

Hello @AnthonyLatini, is this workflow still working properly or are there any reported issues? I am using the ArcGIS connector for the first time and setting it up similarly to this post, except using Outlook email instead of Teams. For example, I have the flow set up as when record is updated -> apply to each fetch updates -> another apply to each send email.

It is not working where I test the flow and make a change to the layer, nothing triggers and the flow does not even trigger the first step (where record is updated).

Re: Power automate fetch updates is not creating a valid input?

LeviCecil — Wed, 03 Apr 2024 15:34:33 GMT

I'm having the exact same issue with this flow using Gmail. It's not getting past the first "apply to each" before I get the array vs string error.

Re: Power automate fetch updates is not creating a valid input?

DominicRobergeIADOT — Tue, 02 Apr 2024 13:22:43 GMT

Have you tried to run your flow by NOT using the new Designer? Last month at the ESRI Dev Summit it was strongly suggested to keep using the "old" designer.

It might not change anything for you, but it doesn't cost anything to try it.

Re: Power automate fetch updates is not creating a valid input?

LeviCecil — Tue, 02 Apr 2024 15:37:28 GMT

I just tried switching to the old designer and got the exact same error

The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@{triggerBody()}@{body('Fetch_updates,_changes,_or_deletions_from_feature_layer')?['items']}' is of type 'String'. The result must be a valid array.

Re: Power automate fetch updates is not creating a valid input?

Aymen_Farhat — Thu, 01 May 2025 14:18:26 GMT

I am having a similar issue. Are there any updates for the Fetch updates feature in Power Automate?