Power Automate - Filter Query by a Field that is blank

%3CLINGO-SUB%20id%3D%22lingo-sub-2485467%22%20slang%3D%22en-US%22%3EPower%20Automate%20-%20Filter%20Query%20by%20a%20Field%20that%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2485467%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20currently%20building%20a%20flow%20for%20my%20institution's%20waste%20pickup%20program%20where%20an%20email%20is%20sent%20out%20that%20accumulates%20a%20table%20of%20any%20requests%20(from%20Sharepoint)%20that%20have%20not%20yet%20been%20completed.%20There%20is%20a%20field%20in%20my%20Sharepoint%20list%20called%20'Date%20Completed'.%20In%20the%20'Get%20Item'%20step%20of%20my%20flow%20I%20want%20to%20Filter%20Query%20'Date%20Completed'%20eq%20'Null'%2C%20but%20I%20keep%20getting%20an%20error%20message.%20See%20flow%20and%20error%20message%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22petertheo89_4-1624628811707.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F291355i949879012E046884%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22petertheo89_4-1624628811707.png%22%20alt%3D%22petertheo89_4-1624628811707.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22String%20was%20not%20recognized%20as%20a%20valid%20DateTime.%20Creating%20query%20failed.%3CBR%20%2F%3EclientRequestId%3A%20c33d3be3-bf61-41b8-ab1b-b508a7b0317c%3CBR%20%2F%3EserviceRequestId%3A%20c33d3be3-bf61-41b8-ab1b-b508a7b0317c%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2485467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello,

 

I am currently building a flow for my institution's waste pickup program where an email is sent out that accumulates a table of any requests (from Sharepoint) that have not yet been completed. There is a field in my Sharepoint list called 'Date Completed'. In the 'Get Item' step of my flow I want to Filter Query 'Date Completed' eq 'Null', but I keep getting an error message. See flow and error message below:

petertheo89_4-1624628811707.png

 

"String was not recognized as a valid DateTime. Creating query failed.
clientRequestId: c33d3be3-bf61-41b8-ab1b-b508a7b0317c
serviceRequestId: c33d3be3-bf61-41b8-ab1b-b508a7b0317c"

0 Replies
www.000webhost.com