cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrewCarter
Level 8

For Each Error Null Type

I might of added this in the wrong forum : -) 

 

https://powerusers.microsoft.com/t5/General-Discussion/For-Each-Area-failed/m-p/332212#M95444

 

but I have a For Each block which is erroring with Null Type even though there is a valid value in the column.

Please see link above for details and screen shots of error

 

Regards

 

Andrew

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: For Each Error Null Type

@AndrewCarter 

 

Check the internal name of the column affected areas

 

Post screenshot of output from getfileproperties action 

 

Also show screenshot of the expression used to get affected areas

View solution in original post

4 REPLIES 4
Super User
Super User

Re: For Each Error Null Type

@AndrewCarter 

 

can you post screenshot of the actual Flow with the error and showing outputs from all steps

AndrewCarter
Level 8

Re: For Each Error Null Type

@RezaDorrani,

 

I have attached some photos ..

 

Request Approval Flow.PNG

Request Approval Flow 2.PNG

 

Request Approval Flow 3.PNG

 

 

Request Approval Flow Error.PNG

Affected Area - Get File Properties Output

Affected Area not NULL.PNG

 

I don't think it is overly complicated and I am not too sure why it got a bug up it .. but maybe because I copied / saved as from another Flow and re-mapped the libraries - but I don't know why that would be a problem.

 

Regards,

 

Andrew

Highlighted
Super User
Super User

Re: For Each Error Null Type

@AndrewCarter 

 

Check the internal name of the column affected areas

 

Post screenshot of output from getfileproperties action 

 

Also show screenshot of the expression used to get affected areas

View solution in original post

AndrewCarter
Level 8

Re: For Each Error Null Type

@RezaDorrani,

You nailed it.. The column had been created with a slightly different internal name.. so deleted this part and re-added it .. all looks good to go

 

Cheers

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 71 members 3,335 guests
Please welcome our newest community members: