Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

The request is invalid

(0) ShareShare
ReportReport
Posted on by 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

 

s44_0-1658769209209.png

 

 

Can you help me please ? 😞 Thanks in advance, I've been trying to solve this problem for 3 hours!

  • s44 Profile Picture
    s44 691 on at
    Re: The request is invalid

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

    s44_1-1658830813072.png

     

  • s44 Profile Picture
    s44 691 on at
    Re: The request is invalid

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

    s44_0-1658830749666.png

     @RandyHayes 

     

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: The request is invalid

    @s44 

    Take a look at this part of the event:

    RandyHayes_0-1658783942325.png

     

    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.

  • s44 Profile Picture
    s44 691 on at
    Re: The request is invalid

    I will try it thanks !

     

    In the monitor, I have this ! :

    s44_0-1658778947575.png

     

    I have error 400 :0  @RandyHayes 

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: The request is invalid

    @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
     }
    )
  • s44 Profile Picture
    s44 691 on at
    Re: The request is invalid

    I already tried but it didn't change anything 😞

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: The request is invalid

    @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.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard