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
Highlighted
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

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

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
Users online (7,670)