The request is invalid

(0) Share

Report

Posted on by Hii_iii

691

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@s44

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.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

I already tried but it didn't change anything 😞

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@s44

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 } )

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

I will try it thanks !

In the monitor, I have this ! :

I have error 400 :0 @RandyHayes

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@s44

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.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

When I hard code using your code I no longer have an error message !
@RandyHayes

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!
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" } }

Was this reply helpful? Yes No