cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

"Request approval in Microsoft Teams when a SharePoint item is created" template - Null expression error when flow hits Teams part

Hi,

 

I'm new to power automate/flows and I'm using the "Request approval in Microsoft Teams when a SharePoint item is created".


However, it seems to be getting an error when it hits the Teams "apply to each" portion of the flow where it gets the body dynamic content from the approval and I'm getting the below error during a test:

 

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


flow test capture.JPG

 

I'm not sure why it is Null, considering there is content in the approval portion of the flow that is entered correctly from a powerapps edit form to sharepoint list - maybe there is something else I've configured incorrectly?

 

flow capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: "Request approval in Microsoft Teams when a SharePoint item is created" template - Null expression error when flow hits Teams part

I think I resolved this.

 

I redid the flow template again and it seems I had some issues with a connection not being authorized that made me fiddle too much with the setup.

 

I redid it all and the template is working as originally designed 

View solution in original post

2 REPLIES 2
Highlighted
Helper I
Helper I

Re: "Request approval in Microsoft Teams when a SharePoint item is created" template - Null expression error when flow hits Teams part

I think I resolved this.

 

I redid the flow template again and it seems I had some issues with a connection not being authorized that made me fiddle too much with the setup.

 

I redid it all and the template is working as originally designed 

View solution in original post

Highlighted
Microsoft
Microsoft

Re: "Request approval in Microsoft Teams when a SharePoint item is created" template - Null expression error when flow hits Teams part

@virakones  I have a test using the template and working fine from my side. Feel free to let me know if the issue happens again.

 

Best Regards,

 

Jessie Chen

 

Support Engineer

Asia Dynamics 365 Support

Customer Services and Support

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,273)