Answered

Different behaviour between tenants? Apply to each issue with forms data

Like (0) Share

Report

Posted on 14 Jun 2023 14:51:00 by rosseli

My employer was acquired in the last year and as such we've moved across to their O365 tenant. I've recreated a flow that was working perfectly on the old tenant (put form responses into html tables and email them), but now seems to be causing issues.

I have an 'apply to each' step that, in the old flow, used 'outputs('Get_response_details')?['body/value'] as its output from a previous step. In the new tenant, my only options seem to be body, body/resourceData, and body/resourceData/responseId, and manually inputting body/value gives the following error:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Get_response_details')?['body/value']' is of type 'Null'. The result must be a valid array.

All other options are of Object type, and similarly do not work.

Has anyone experienced (and hopefully resolved) this before? Any help is appreciated.

I have the same question (0)

All responses (5)

Answers (1)

rosseli 9 on 16 Jun 2023 at 11:22:46

Like (0)

Report

Re: Different behaviour between tenants? Apply to each issue with forms data

I removed the 'apply to all' section and it's working now. I think I'd followed a tutorial a couple years ago and they'd included that step. Thanks for your help!

Was this reply helpful? Yes No
Verified answer

fchopo 7,972 Moderator on 16 Jun 2023 at 06:44:07

Like (1)

Report

Re: Different behaviour between tenants? Apply to each issue with forms data

Honestly, I don't know why you need the "apply to each". When working with Forms whenever someone submits a new response, you would normally do the following:

Hope that helps!

Ferran

Was this reply helpful? Yes No
rosseli 9 on 15 Jun 2023 at 13:08:35

Like (0)

Report

Re: Different behaviour between tenants? Apply to each issue with forms data

The 'List of response notifications' does not appear as an option for dynamic content in the new tenant. I can see that there is a deprecated version of 'When a new response is submitted' which has this option but I can't tell if the current version should have it too. The flow on the old tenant was written in 2021 so this might be the issue but I'm not sure.

Was this reply helpful? Yes No
rosseli 9 on 15 Jun 2023 at 12:59:10

Like (0)

Report

Re: Different behaviour between tenants? Apply to each issue with forms data

Hi,
I've created a test flow that only has the 'When a new response is created' trigger' and an 'apply to each' step. In the settings of the trigger, it gives "@triggerOutputs()?['body/value']" as its array value, which is the value I was able to use under my previous tenant in the apply to each step, but that no longer seems to work. It's the same form as before, I'd duplicated it using a share link to the form on the old tenant, and the forms connection seems to be set up properly. I've also created a basic test form from scratch and the same issue persists.

Any clue why it doesn't work?

Was this reply helpful? Yes No
fchopo 7,972 Moderator on 14 Jun 2023 at 15:21:22

Like (0)

Report

Re: Different behaviour between tenants? Apply to each issue with forms data

Hi @rosseli

Are all the connections in your workflow properly configured? Besides that, could you check you have the same actions in the workflow? It seems in the new one the "get response details" (forms) is missing.

Hope it helps!

Ferran

Was this reply helpful? Yes No

Community site session details

Different behaviour between tenants? Apply to each issue with forms data

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Different behaviour between tenants? Apply to each issue with forms data

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates