Home

MS Flow - Get items from SharePoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-291154%22%20slang%3D%22en-US%22%3EMS%20Flow%20-%20Get%20items%20from%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291154%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20successfully%20created%20a%20flow%20to%20count%20the%20number%20of%20items%20in%20a%20SharePoint%20list%26nbsp%3Band%20filtered%20it%20by%20one%20of%20the%20columns%20-%20shown%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60670iBBA48A78597490D3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22success%20flow.jpg%22%20title%3D%22success%20flow.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20would%20like%20the%20flow%20to%20look%20at%20a%20date%20column%20and%20only%20include%20records%20when%20this%20column%20has%20no%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20changing%20the%20filter%20query%20to%3A%20%3CSTRONG%3E%3CFONT%3EProgress%20ne%20'Completed'%20and%20Reminder%255Fx0020%255FDate%20eq%20null%2C%26nbsp%3B%3C%2FFONT%3E%3C%2FSTRONG%3E%3CFONT%3Ebut%20get%20an%20error%20message%20saying%20the%20error%20message%20is%20invalid.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-291154%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Sam Greatorex
Occasional Contributor

I have successfully created a flow to count the number of items in a SharePoint list and filtered it by one of the columns - shown below.

success flow.jpg

I would like the flow to look at a date column and only include records when this column has no date.

 

I have tried changing the filter query to: Progress ne 'Completed' and Reminder%5Fx0020%5FDate eq null, but get an error message saying the error message is invalid.

 

Any help would be greatly appreciated.

 

 

Related Conversations
Office 365 Outlook accounts for Partners
opendesign in Microsoft 365 on
2 Replies
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
9 Replies
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
Sharing an excel sheet public link
shunde3 in Microsoft Teams on
6 Replies