cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver II
Resolver II

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
Dual Super User
Dual 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
Dual Super User
Dual 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

Highlighted
Resolver II
Resolver II

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
Dual Super User
Dual 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

Highlighted
Resolver II
Resolver II

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 Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (3,034)