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

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

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

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

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

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