Filter Query Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1867406%22%20slang%3D%22en-US%22%3EFilter%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1867406%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20I%20am%20a%20newbie%20at%20Power%20Automate%20and%20am%20looking%20for%20some%20help%20on%20an%20error%20I%20am%20getting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20GetItems%20to%20pull%20data%20from%20a%20Sharepoint%20List.%26nbsp%3B%20This%20is%20a%20list%20of%20client%20contacts%20which%20includes%20a%20field%20called%20'Last%20Contact'%20which%20is%20simply%20the%20date%20we%20last%20had%20contact%20with%20the%20client.%26nbsp%3B%20I%20would%20like%20to%20filter%20only%20for%20'Last%20Contact'%20dates%20older%20than%2030%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20look%20at%20the%20url%20for%20this%20particular%20field%20in%20my%20list%2C%20I%20can%20see%20that%20the%20field%20name%20is%20actually%20'_x0067_rv7'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wrote%20my%20query%20like%20this%3A%26nbsp%3B_x0067_rv7%20ge%20sub(today()%2C30)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20get%20an%20error%20which%20says%20%22Column%20'_x0067_rv7'%20does%20not%20exist.%20It%20may%20have%20been%20deleted%20by%20another%20user.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1867406%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1867900%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1867900%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F172123%22%20target%3D%22_blank%22%3E%40Daniel%20Bonner%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EConfirm%20the%20column%20name%20by%20going%20into%20List%20settings%20%26gt%3B%20column%20%26gt%3B%20check%20the%20URL%20path%20for%20the%20internal%20column%20name%20(%22Field%3D%22).%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stormin_30_0-1604944053517.png%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232355i1621D03BB4F193B6%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%22stormin_30_0-1604944053517.png%22%20alt%3D%22stormin_30_0-1604944053517.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESet%20the%20%22Get%20items%22%20action%20OData%20filter%20query%20to%3A%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CYOUR%20column%3D%22%22%20name%3D%22%22%3E%20ge%20%3CSTRONG%3E'%3C%2FSTRONG%3EaddDays(utcNow()%2C%2030%2C%20'yyyy-MM-dd')%3CSTRONG%3E'%3C%2FSTRONG%3E%3C%2FYOUR%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stormin_30_3-1604944385387.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232358iBBA71D0F20F35305%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22stormin_30_3-1604944385387.png%22%20alt%3D%22stormin_30_3-1604944385387.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThere%20are%20single%20quotes%20around%20the%20expression!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1868137%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1868137%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you.%26nbsp%3B%20I%20am%20still%20getting%20an%20error%20message%20saying%20the%20column%20name%20doesn't%20exist.%26nbsp%3B%20Here%20is%20the%20url%20for%20the%20column%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22column%20url.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232368iA3AB258C9AEFB395%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22column%20url.jpg%22%20alt%3D%22column%20url.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EI%20am%20using%20'_x0067_rv7'%20as%20my%20field%20name.%26nbsp%3B%20Wondering%20if%20it's%20having%20trouble%20with%20the%20%22_%22%20as%20the%20first%20character%20in%20the%20field%20name%20perhaps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20flow%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22flow%20shot.jpg%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232374i2790222BECB42461%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22flow%20shot.jpg%22%20alt%3D%22flow%20shot.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1868194%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1868194%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F172123%22%20target%3D%22_blank%22%3E%40Daniel%20Bonner%3C%2FA%3E%26nbsp%3Bin%20your%20filter%20query%20you%20don't%20type%20in%20the%20addDays%20expression%2C%20you%20go%20to%20the%20Expression%20tab%20of%20the%20dynamic%20content%20and%20add%20it%20there%20and%20click%20OK%20and%20it%20will%20add%20it%20to%20the%20filter%20query%20as%20a%20pink%20expression%20like%20the%20one%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22filterQuery3.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232375i1F11186D817E894F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22filterQuery3.png%22%20alt%3D%22filterQuery3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1868343%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Query%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1868343%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGetting%20closer%20I%20think%20but%20still%20getting%20this%20error%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22err%20message.jpg%22%20style%3D%22width%3A%20286px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232389i7817B3CD0E769E4E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22err%20message.jpg%22%20alt%3D%22err%20message.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHere%20is%20how%20I%20currently%20have%20things%20laid%20out%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22flow%20shot.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232390iD3E80B805D5A128C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22flow%20shot.jpg%22%20alt%3D%22flow%20shot.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EMaybe%20something%20with%20the%20date%20formatting%3F%26nbsp%3B%20Or%20maybe%20due%20to%20some%20blank%20entries%20in%20my%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello I am a newbie at Power Automate and am looking for some help on an error I am getting.

 

I am using GetItems to pull data from a Sharepoint List.  This is a list of client contacts which includes a field called 'Last Contact' which is simply the date we last had contact with the client.  I would like to filter only for 'Last Contact' dates older than 30 days.

 

When I look at the url for this particular field in my list, I can see that the field name is actually '_x0067_rv7'

 

I wrote my query like this: _x0067_rv7 ge sub(today(),30)

 

I get an error which says "Column '_x0067_rv7' does not exist. It may have been deleted by another user."

 

Any help would be greatly appreciated.

7 Replies

Hi @Daniel Bonner,

 

Confirm the column name by going into List settings > column > check the URL path for the internal column name ("Field=").

stormin_30_0-1604944053517.png

 

Set the "Get items" action OData filter query to: 

<your column name> ge 'addDays(utcNow(), 30, 'yyyy-MM-dd')'

stormin_30_3-1604944385387.png

There are single quotes around the expression!

 

I hope this helps.

 

Norm

 

 

Thank you.  I am still getting an error message saying the column name doesn't exist.  Here is the url for the column:column url.jpg

 

I am using '_x0067_rv7' as my field name.  Wondering if it's having trouble with the "_" as the first character in the field name perhaps?

 

Here is the flow:flow shot.jpg

@Daniel Bonner in your filter query you don't type in the addDays expression, you go to the Expression tab of the dynamic content and add it there and click OK and it will add it to the filter query as a pink expression like the one below:

filterQuery3.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott 

 

Getting closer I think but still getting this error:

err message.jpg

Here is how I currently have things laid out:

flow shot.jpg

Maybe something with the date formatting?  Or maybe due to some blank entries in my list?

Hi @Daniel Bonner,

 

Put your expression in single quotes and try again.

 

Norm

@stormin_30 

 

Thank you!  That was the last piece I needed.

 

Thanks again everyone for your help!

The single quotes were shown in my previous image but I should have explicitly told you to add them.

Rob
Los Gallardos