flow test on a sharepoint empty field

%3CLINGO-SUB%20id%3D%22lingo-sub-298281%22%20slang%3D%22en-US%22%3Eflow%20test%20on%20a%20sharepoint%20empty%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298281%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI've%20a%20list%20in%20SharePoint%20and%20when%20a%20line%20is%20add%20or%20modified%20I%20want%20to%20test%20if%20a%20specific%20field%20%5BTacheID%5D%26nbsp%3Bis%20empty%2C%20if%20true%20I%20want%20to%20create%20a%20planner%20task.%3C%2FP%3E%3CP%3EI've%20an%20error%3A%20%3CEM%3ECan't%20read%20property%20%22properties%22%20from%20null%20or%20not%20defined%20expression%20%3C%2FEM%3E(I%20translated%20from%20French).%3C%2FP%3E%3CP%3Eif%20I%20send%20this%20%22%40equals(length(string(triggerBody()%3F%5B'TacheID'%5D))%2C%200)%22%20by%20email%20I%20get%20True%20or%20False%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20831px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62307iC0621FCC78259CF4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22flow1.png%22%20title%3D%22flow1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-298281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-298422%22%20slang%3D%22en-US%22%3ERe%3A%20flow%20test%20on%20a%20sharepoint%20empty%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298422%22%20slang%3D%22en-US%22%3E%3CP%3EHey%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20will%20work%20if%20you%20compare%20field%20with%20null%20value%20from%20function%20set%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20622px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62328iAE4808B5D409C700%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello,
I've a list in SharePoint and when a line is add or modified I want to test if a specific field [TacheID] is empty, if true I want to create a planner task.

I've an error: Can't read property "properties" from null or not defined expression (I translated from French).

if I send this "@equals(length(string(triggerBody()?['TacheID'])), 0)" by email I get True or False

flow1.png

 

1 Reply
Highlighted

Hey,

 

It will work if you compare field with null value from function set

image.png