Hello,
I'm trying to query my SharePoint list to retrieve items and display them in my gallery. But I got the following error message:
The requested operation is invalid.
Server Response: Failure from Provider: The request is invalid.
clientRequestId: a12a3fdb-9b7b-43a5-bb28-66b5422ecb20
serviceRequestId: a12a3fdb-9b7b-43a5-bb28-66b5422ecb20
Can you help me please ? 😞 Thanks in advance, I've been trying to solve this problem for 3 hours!
I have this : @RandyHayes
{
"duration": 410.1,
"size": 181,
"status": 400,
"headers": {
"Cache-Control": "private, max-age=0",
"Content-Length": 181,
"content-security-policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com;",
"Content-Type": "application/json",
"dataserviceversion": 3,
"Date": "Tue, 26 Jul 2022 09:27:14 GMT",
"expires": "Mon, 11 Jul 2022 09:27:15 GMT",
"last-modified": "Tue, 26 Jul 2022 09:27:15 GMT",
"microsoftsharepointteamservices": "16.0.0.22706",
"ms-cv": "I8JFBCClhkazl2h5RNgCNA.0",
"nel": {
"report_to": "network-errors",
"max_age": 7200,
"success_fraction": 0.001,
"failure_fraction": 1
},
"p3p": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
"report-to": {
"group": "network-errors",
"max_age": 7200,
"endpoints": [
{
"url": "https://spo.nel.measure.office.net/api/report?tenantId=120fb2eb-a059-42e9-8a2e-aa546a49cdd0&destinationEndpoint=190019&frontEnd=FarmDirect"
}
]
},
"Request-Id": "0445c223-a520-4686-b397-687944d80234",
"spclientservicerequestduration": 111,
"SPRequestGuid": "0445c223-a520-4686-b397-687944d80234",
"strict-transport-security": "max-age=31536000",
"timing-allow-origin": "*",
"vary": "Origin",
"x-1dscollectorurl": "https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/",
"x-ariacollectorurl": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
"x-aspnet-version": "4.0.30319",
"x-content-type-options": "nosniff",
"x-databoundary": "None",
"x-frame-options": "SAMEORIGIN",
"x-ms-apihub-cached-response": true,
"x-ms-apihub-obo": true,
"x-ms-invokeapp": "1; RequireReadOnly",
"x-ms-spconnector": 1,
"x-powered-by": "ASP.NET",
"x-sharepointhealthscore": 0,
"x-sp-serverstate": "ReadOnly=0",
"x-ms-client-request-id": "0445c223-a520-4686-b397-687944d80234"
},
"body": {
"status": 400,
"message": "La requête est incorrecte.\r\nclientRequestId: 0445c223-a520-4686-b397-687944d80234\r\nserviceRequestId: 0445c223-a520-4686-b397-687944d80234"
}
}
Take a look at this part of the event:
If there are sections that are collapsed, then expand them.
If the response shows sensitive data, don't snap shot it and post here, instead take the snapshot and send to me as a private message.
Ideally, looking at the Monitor tool would be the first place to diagnose the issue.
But, you can also break your formula down to isolate the issue.
For example, change your formula to:
ForAll(
Sequence(If(DateDiff(varVideoFirstDayView; DateAdd(varVideoMonth; 1; Months); Days)>35; 42; 35));
With({_date: DateAdd(varVideoFirstDayView; Value; Days)};
{Value: Value;
Items: Filter(Fournisseur; DateArrivee <= Today());
_date: _date
}
)
This will "hard code" a test for just today on the DateArrivee column.
Then switch to the EndTime column to test as well:
ForAll(
Sequence(If(DateDiff(varVideoFirstDayView; DateAdd(varVideoMonth; 1; Months); Days)>35; 42; 35));
With({_date: DateAdd(varVideoFirstDayView; Value; Days)};
{Value: Value;
Items: Filter(Fournisseur; EndTime >= Today());
_date: _date
}
)
I already tried but it didn't change anything 😞
Maybe you've already tried this, but exit the app designer and then go back in and see if the error continues. Sometimes the "error" gets stuck and it appears there is an error when there is not. Resetting the designer does the trick in some cases.
I hope this is helpful for you.