cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sven_Burkhardt
Level: Powered On

Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi everybody,

 

here is my problem:

 

I run an reccurance on all appointments inside our CRM instance. I filter all of them in an array to identify all records where "scheduledend" is lessorequal today.

After that I want to update all results and set the status to "completed".Anmerkung 2019-06-04 090540.pngAnmerkung 2019-06-04 090631.png

The filter delivers the correct results set of appointments.

 

I want to accomplish that appointments does not need to get manually marked as completed by the users.

 

The error-message delivers this body:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd"> <HTML><HEAD><TITLE>Bad Request</TITLE> <META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD> <BODY><h2>Bad Request - Invalid URL</h2> <hr><p>HTTP Error 400. The request URL is invalid.</p> </BODY></HTML>

 

Hope you have an idea on this.

 

Cheers

Sven

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

Tap into the identifier field not the apply to each field. You will see options to select from the dynamic selector and from there you can select the Appointment ID. 

 

Please see a sample screenshot below

tete.png

Hope this Helps!

View solution in original post

10 REPLIES 10
Dual Super User
Dual Super User

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

 

Can you confirm if you have enabled access to set the values on those records in that entity?

 

Also, the environemnt in which you are creating the flow and the environement you are connecting to are those same?

 

Can you try logging out of the current session close the browser and start a fresh session and then retry again?

 

Also, you can try using the common data services (CDS) connector to achieve this (If your D365 instance is online and I am assuming it is)

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Sven_Burkhardt
Level: Powered On

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @yashag2255,

 

thanks for your reply.

I tried to switch to CDS connector but this delivers exactly the same error as using D365 connector.

Logging off and on from the session also does not solve the problem. I even deleted all-time cache from browser to be sure.

 

I am dealing with Dynamics CRM since 3.0 and wonder, what you mean with "...Can you confirm if you have enabled access to set the values on those records in that entity?..."

The Flow from PowerApps Page (!not Flow-Page from O365!) is created and running under D365-serviceaccount. There should be no limitation concerning access to the CRM.

 

Cheers

Sven

Dual Super User
Dual Super User

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

 

So after you run the flow, you get the error on which action? Can you please post a screenshot of that? 

Sven_Burkhardt
Level: Powered On

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @yashag2255,

 

the error occurs at the final stage where the records should get updated.

The record count is correct.

Here screens of the error from the last stage:

01.png02.png

 

Cheers

Sven

Dual Super User
Dual Super User

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

 

I am guessing that some data type mismatch might be causing this error. Can you please also add a screenshot of the flow of this particular acton where the recors is being updated? I want to see the identifier and the values you are updating. (barring any sensitive information)

Sven_Burkhardt
Level: Powered On

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @yashag2255,

 

here is the oDATA resukts for one record:
{"@odata.id":"https://XXXXXXX.crm4.dynamics.com/api/data/v9.0/appointments(249aa4c6-e485-e911-a836-000d3ab18325)",... inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte inhalte\r\n","createdon":"2019-06-03T09:48:47Z","statecode":3,"_statecode_label":"Scheduled","location":"Bei mir am Platz","subject":"Test Termin","_ownerid_value":"486e0273-c944-e911-a822-000d3ab18b39","_ownerid_type":"systemusers","isunsafe":0,"modifiedon":"2019-06-03T09:50:29Z","versionnumber":7039879,"prioritycode":1,"_prioritycode_label":"Normal","isdraft":false,"timezoneruleversionnumber":0,"isregularactivity":true,"isalldayevent":false,"ismapiprivate":false,"_modifiedby_value":"486e0273-c944-e911-a822-000d3ab18b39","_modifiedby_type":"systemusers","outlookownerapptid":-1201444893,"activitytypecode":"appointment","instancetypecode":0,"_instancetypecode_label":"Not Recurring","isworkflowcreated":false,"_createdby_value":"486e0273-c944-e911-a822-000d3ab18b39","_createdby_type":"systemusers","attachmenterrors":0,"_attachmenterrors_label":"None","_owningbusinessunit_value":"3659328c-3327-e911-a991-000d3ab20edc","_owningbusinessunit_type":"businessunits","activityid":"249aa4c6-e485-e911-a836-000d3ab18325","scheduledend":"2019-06-03T11:00:00Z","lastonholdtime":null,"_owningteam_value":null,"exchangeitemid":null,"seriesid":null,"deliverylastattemptedon":null,"_sendermailboxid_value":null,"onholdtime":null,"community":null,"sortdate":null,"_createdonbehalfby_value":null,"_transactioncurrencyid_value":null,"processid":null,"_serviceid_value":null,"_slaid_value":null,"stageid":null,"actualstart":null,"utcconversiontimezonecode":null,"exchangeweblink":null,"senton":null,"_slainvokedid_value":null,"postponeactivityprocessinguntil":null,"_modifiedonbehalfby_value":null,"exchangerate":null,"deliveryprioritycode":null,"actualdurationminutes":null,"traversedpath":null,"activityadditionalparams":null,"leftvoicemail":null,"actualend":null,"subscriptionid":null,"category":null,"originalstartdate":null,"subcategory":null,"importsequencenumber":null,"modifiedfieldsmask":null,"overriddencreatedon":null}

 

And here are screens from the update-action:

01.png02.png03.png

 

Sven

Dual Super User
Dual Super User

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

HI @Sven_Burkhardt 

 

The error is coming in because of the identifier. Yo are using the entire value set over there. Instead, please tap into the identifier and from the dynamic content selector, select the ID of the particular value in the loop. 

 

Hope this Helps!

Sven_Burkhardt
Level: Powered On

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @yashag2255,

 

There is no option for the ID:

04.png

Dual Super User
Dual Super User

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @Sven_Burkhardt 

Tap into the identifier field not the apply to each field. You will see options to select from the dynamic selector and from there you can select the Appointment ID. 

 

Please see a sample screenshot below

tete.png

Hope this Helps!

View solution in original post

Sven_Burkhardt
Level: Powered On

Re: Update D365CE record throws "HTTP Error 400. The request URL is invalid."

Hi @yashag2255,

 

this works. Awesome!

Thanks a lot for your help.

 

Cheers

Sven

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,784)