web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Why do i get this erro...
Power Automate
Unanswered

Why do i get this error - get items query?

(0) ShareShare
ReportReport
Posted on by 1,097

I get this error.

screenshot: http://prntscr.com/ub2y6c

 

error looks like this:

InvalidPageResponse. The response is not a valid paginated response. The specified nextLink 'https://flow-apim-europe-001-francecentral-01.azure-apim.net/apim/sharepointonline/shared-sharepointonl-ed16a9af-3be1-4c22-ae5a-d057f93cef09/datasets/https%253A%252F%252Fekero.sharepoint.com%252Fsites%252FBUF%252Fkassa/tables/2fca579a-cfb1-4e49-9c59-be53013d8bbc/items?$filter=substringof(%27Swish%27%2cInTyp)+and+startswith(Orsak%2c%27Ins%c3%a4ttning%27)+and+Created+gt+%272020-08-16+T00%3a01%3a00Z%27+and+Created+lt+%272020-08-17+T23%3a59%3a59Z%27&$skiptoken=Paged%3dTRUE%26p_ID%3d26977%26RootFolder%3d%252fsites%252fBUF%252fkassa%252fLists%252fKop%255fLista' is not a well formed URI.

 

My query formula looks like this:

substringof('Swish',InTyp) and startswith(Orsak,'Insättning') and Created gt '2020-08-17 T00:01:00Z' and Created lt '2020-08-17 T23:59:59Z'

 

If i change my formula to this:

substringof('Swish',InTyp) and startswith(Orsak,'Insättning') and Created gt '2020-08-16 T00:01:00Z' and Created lt '2020-08-16 T23:59:59Z'

note i only changed the dates, from 17 to 16.

 

Now my querry works.

It also works if i change the dates to other dates like 2020-08-18 or 2020-08-22 or 2020-07-01 or 2020-07-15

 

why does it not work for 17?

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard