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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

N:N Relationship to Virtual Entity: OData query fails with "Invalid URI: The Uri string is too long."

(0) ShareShare
ReportReport
Posted on by 5

Odata queries from our power app fails when listing related virtual entities with the message: "code":"0x80040224","message":"Invalid URI: The Uri string is too long.". 

We are using the Microsoft.XRM.DataProvider.OData.V4.Plugins so the virtual entities can be resolved and shown in the power app.

We have a table in the power app where each row is related to N Virtual entities in another system and there is a form that lists the N virtual entities for a given row. It work fine when there are a few virtual entities but it quickly falls apart as the number grows.

It makes sense that the Uri would become too long if it puts all the Uids from the N:N relation in the query string to enable the other system to filter and page the virtual entities. All that is needed is to POST the query instead. The Odata endpoint that is queried for the virtual entities supports POST as well as GET but I don't see how I can get my power app to POST it instead.

I have the same question (0)
  • Esteban Coto Alfaro Profile Picture
    Microsoft Employee on at

    Hello, you can check the URI because URI has a max length. For large chunks of data is recommended to send it in JSON format.

    Thanks!

    Community Support Team - Esteban

    If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

  • Kristian Dahl Profile Picture
    5 on at

    Yeah, I know the url gets too long but I didn't write the OData data provider plugin which is maknig the query, I just wrote the service it is trying to send the query to. And the query will become massive, there is no way around that, so putting it in the url makes no sense. I just want the plugin to POST the query instead.

    I really don't want to have to write my own OData dataprovider plugin.

  • Tech full Profile Picture
    5 on at

    HI I have also same issue how can be convert into query string to json format

    $filter=StatusName eq 'In FIU L1 Review' and WhereIn(WorkflowItemId,57122,57123,57125,57126,57127,57128,57129,57130,57131,57132,57133,57134,57135,57136,57137,57139,57140,57141,57142,57143,57144,57145,57146,57147,57148,57149,57150,57151,57152,57153,57154,57160,57163,57164,57165,57166,57171,57172,57174,57175,57178,57179,57180,57182,57183,57184,57185,57186,57193,57194,57196,57197,57198,57199,57200,57201,57202,57203,57204,57205,57206,57207,57208,57209,57210,57211,57212,57213,57214,57215,57216,57217,57218,57219,57220,57222,57223,57224,57225,57226,57227,57228,57229,57230,57232,57233,57234,57235,57236,57237,57238,57239,57240,57241,57243,57244,57245,57246,57247,57248,57249,57250,57252,57253,57254,57255,57256,57257,57258,57259,57260,57261,57262,57263,57264,57266,57268,57270,57271,57273,57274,57275,57278,57279,57280,57281,57282,57283,57284,57285,57286,57287,57289,57291,57292,57293,57294,57295,57296,57309,57311,57312,57313,57314,57315,57319,57320,57321,57322,57323,57325,57326,57327,57329,57330,57332,57333,57334,57335,57336,57337,57338,57339,57340,57343,57344,57345,57346,57350,57351,57352,57353,57354,57366,57369,57370,57371,57374,57375,57376,57377,57379,57385,57386,57387,57388,57389,57390,57391,57392,57393,57394,57395,58394,58396,58397,58399,58400,58402,58403,58404,58405,58408,58409,58423,58424,58425,58445,58447,58473,58511,58521,58529,58536,58541,58542,58543,58544,58557,58558,58559,58560,58561,58562,58563,58564,58565,58566,58567,58568,58570,58571,58572,58573,58574,58575,58601,58602,58603,58604,58605,58606,58607,58616,58639,58642,58643,58644,58645,58646,58647,58648,58649,58654,58655,58662,58663,58668,58669,58670,58673,58674,58675,58677,58681,58682,58683,58687,58688,58690,58691,58794,58795,58796,58797,58798,58799,58800,58801,58802,58803,58804,58806,58807,58808,58809,58810,58832,58833,58834,58835,58836,58837,58838,58839,58840,58841,58865,58867,58868,58869,58870,58871,58872,58873,58874,58881,58882,58883,58884,58885,58886,58887,58888,58889,58890,58891,58892,58893,58894,58895,58896,58897,58898,58899,58900,58901,58902,58903,58904,58905,58906,58907,58908,58909,58910,58911,58912,58913,58914,58915,58916,58917,58918,58920,58921,58922,58923,58926,58927,58928,58929,58930,58931,58932,58933,58934,58935,58936,58937,58938,58939,58940,58960,58961,58962,58963,58964,58965,58966,58967,58968,58969,58970,58971,58972,58973,58974,58977,58978,58979,58980,58981,58982,58985,58986,58987,58988,58989,58990,58991,58992,58993,58994,58995,58996,58997,58998,58999,59000,59001,59002,59003,59005,59006,59090,59091,59092,59093,59145,59146,59147,59148,59149,59150,59151,59152,59153,59154,59155,59156,59157,59158,59160,59162,59163,59164,59165,59166,59167,59168,59169,59170,59171,59172,59173,59174,59175,59177,59178,59179,59180,59185,59186,59187,59188,59189,59190,59191,59192,59193,59194,59196,59197,59198,59199,59200,59201,59202,59203,59204,59205,59206,59207,59208,59209,59210,59211,59212,59213,59221,59222,59223,59224,59225,59226,59227,59228,59229,59230,59231,59232,59233,59234,59236,59237,59238,59239,59240,59159,60352,60353,60354,60355,60356,60357,60358,60359,60360,60361,60362,60363,60364,60365,60366,60367,60368,60369,60370,60371,60372,60373,60374,60375,60376,60377,60378,60379,60380,60381,60382,60383,60384,60385,60386,60387,60388,60389,60390,60391,60392,60393,60394,60395,60396,60397,60398,60399,60400,60401,60402,60403,60404,60405,60406,60407,60408,60409,60410,60411,60412,60413,60414,60415,60416,60417,60418,60419,60420,60421,60422,60423,60424,60425,60426,60427,60428,60429,60430,60431,60432,60433,60434,60435,60436,60437,60438,60439,60440,60441,60442,60443,60444,60445,60446,60447,60448,60449,60450,60451,60452,60453,60454,60455,60456,60457,60490,60491,60492,60493,60494,60495,60496,60497,60498,60499,60500,60501,60502,59235,62656,62657,62658,62659,62660,62661,62662,62663,62664,62665,62666,62667,62668,62669,62670,62671,62672,62673) and REVIEWOPEN() and WhereIn(WorkflowTypeId,10)&$top=50&$skip=0&$orderby=QueueDate

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 98 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 72

#3
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 69 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans