SOLVED

"Get items" columns not available for use in a Expression

MVP

Hello All,

 

Can anyone tell me why my "Get items" columns are not available for use in a Expression within a "Increment variable" action?

 

Image 1 - pre-Expression note columns "Quantity" and "Unit Cost"

1.png

 

Image 2 - Expression no "Quantity" and "Unit Cost" columns

2.png

 

SharePoint List definition:

3.PNG

 

Thanks all!

 

Norm

1 Reply
best response confirmed by Norman Young (MVP)
Solution

I didn't find a definitive answer and can only assume its by design when using "Apply to each" with "Get items".

 

I did create a workaround by creating additional variables that could store the value of the "Get items" columns that could not be used within the "Apply to each" loop.

 

Image attached hoping that it serve as an example to others.

 

Capture.PNG

1 best response

Accepted Solutions
best response confirmed by Norman Young (MVP)
Solution

I didn't find a definitive answer and can only assume its by design when using "Apply to each" with "Get items".

 

I did create a workaround by creating additional variables that could store the value of the "Get items" columns that could not be used within the "Apply to each" loop.

 

Image attached hoping that it serve as an example to others.

 

Capture.PNG

View solution in original post