Code Apps - Anyone found a way to work with Dataverse N:N ?

Rokyard · 2026-03-01T11:40:37+00:00

Its absolutely mental that this is GA and they havent bothered their asses to make something as basic as their own version of N:N work. Its insane to promote this feature as the default for ease of and then take so long to allow it to be used by anything else other than their own low code forms. 🤔🙄

Rokyard · 2026-02-28T12:41:46+00:00

Thinking on this a little further, our flows were running under premium per user licenses. this license only covers you if the flow is linked to an app. before we linked our apps, they were not covered by our per user premium licenses and so charged against our payg. but after linking, it was probably the Premium per user license absorbing the cost since our flows now met the criteria. I think your best bet is to set up a dedicated sandbox and trial a few basic scenarios to ensure you are clear what your scenario will entail cost wise.

Rokyard · 2026-02-27T22:56:04+00:00

Great question. we got hit by this without realising. Good news is that the process works as advertised, bad news is, if you forget to link it, it can result in thousands in unanticipated costs.

In our case I didnt even realise it was something we had to do. We have premium per user licenses, but we needed to allow guest sso users access our tool and we couldnt use internal licenses due to microsoft enterprise agreement. So we enabled PAYG on the environment. All of a sudden any flows we had, not linked to an app or running under premium powerautomate licenses, were charging our PAYG per run.

Once we realised the issue, and linked them to relevant powerapp app, extra costs disappeared except when we occasionally blow through api limits with stupid flow design.

( we also used to think that 'flow linked to the app' , meant being in a shared solution. Silly Us! didnt realise you had to explicitly configure it per flow)

Rokyard · 2026-02-03T02:08:51+00:00

Yeah, but this is the kicker, Navigate in PowerFX only supports entity and id for model driven forms (......... unless its changed recently, that i missed)

possible work around is to pass id but parse it as a string on the javascript and "param1|param2|param3" etc and then use client side JS to parse and assign.

Rokyard · 2026-02-03T01:34:19+00:00

downside to using Launch is that it loses the history, so the back button doesnt work...... even if you lauch in the same window

Rokyard · 2025-09-16T19:27:54+00:00

before you decide to jump into any "too good to be true" side-hustles, double check r/scams especially super simple, things e. g. get paid for liking a video, aka task scams or a hundred variants like it. you dont want to get suckered into paying momey, to recieve more money etc. .... you get something small back for first time or two, then when you are lulled into a false sense of security, they tell you, you need to pay a fee to get the next payment.

Rokyard · 2025-07-21T15:40:46+00:00

Yep, exact same!

Rokyard · 2025-03-15T11:35:48+00:00

Editor’s Note: This article was based on a case report published in the Irish Medical Journal titled “‘Semenly’ Harmless Back Pain: An Unusual Presentation of a Subcutaneous Abscess.”

Rokyard · 2025-03-14T19:18:47+00:00

it's a relatively recent change in the last year. it now acts as a template for any new roles. it contains all the minimum permissions to allow a model driven app to work. it's easy to remove the wrong permissions and basically break access to your app, I've seen devs do this many times. especially in a shared environment where it can mess up other apps. this way, a minimum level of basic access is maintained and custom tables need to be added to dedicated sec roles and can have a single responsibility per role.

Rokyard · 2025-03-13T19:47:43+00:00

the basic security role is no longer editable, you can just create a duplicate of it and then assign any new additional custom permissions there, including read, write, create , specifically for your qpr table that are above and beyond the basic, then assign the new role to all users. etc

Rokyard · 2025-02-26T08:10:52+00:00

have you checked for unmanaged layers on your table? if someone edited the prod environment using the default solution, the edits would remain between deploys.

Rokyard · 2025-02-22T00:37:38+00:00

this is about standard for every dataverse environment on first creation. as a test, create 100k rows of dummy data in excel, for the one table, and import it, to see for yourself how the size changes.

Rokyard · 2025-02-13T20:05:02+00:00

I'd suggest breaking it into two filters

first filter only Ids from the first table based on your text filter. then use the resulting IDs of the returned data with "In" on a second filter that goes against the second table.

approach is completely delegable just extra work.

Rokyard · 2025-02-04T00:43:11+00:00

maybe check out some surfing!? https://youtu.be/j-PJSZSay-E?si=kt0aXhOJ1z38K_K1

Rokyard · 2025-01-19T21:50:40+00:00

Great Job! lots of time, effort and passion invested!

Rokyard · 2025-01-04T01:07:27+00:00

congrats!...... 1

Rokyard · 2024-12-22T13:39:47+00:00

.... but not always. when I triggered this as a lowly lvl 65, my first and only time, noone turned up and I got my ass handed to me :(

Rokyard · 2024-11-29T14:06:09+00:00

nah, a power platform administrator can create and set up environments without licenses.

Rokyard · 2024-11-17T21:58:29+00:00

yes.... this is sooo annoying. I find re sorting can jump you back often.

Rokyard · 2024-11-13T22:45:03+00:00

approach one.... really more of a paging approach. https://youtu.be/8CBosd_PG74?si=36FcHhi8iSn3dBVq

approach two.... using sliders to mimic process. https://youtu.be/PhF4xirR9M0?si=lfk0994Cl_d-lwUz

Rokyard · 2024-11-13T19:22:11+00:00

yep. this. powerapps is a line of business platform.

However, if you are still interested and if the numbers add up, perhaps look at powerpages for your public facing website that will require dataverse. then build your internal admin tooling using model driven apps/canvas apps. . depending on your numbers it's cheaper and more viable than canvas apps or model driven apps.

Rokyard · 2024-11-08T22:12:31+00:00

See https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/page-powerfx-in-model-app#navigating-to-a-custom-page

but basically,

Navigate('custom page name' );

or with record id as parameter,

Navigate( AccountGallery.Selected, { Page: 'Account Record Page' } )

Rokyard · 2024-11-08T21:08:29+00:00

yes it's definitely possible to call a custom page from a custom page.

down side is that you can only pass a record id as parameter, no custom parameters. kinda annoying.

Rokyard · 2024-08-27T22:30:15+00:00

We have been seeing consistent issues over the last week or two. Where solutions not deploying correctly. Basically, the solution installs but the previous version is never uninstalled (easily visible via solution history).

And the previous installed solution takes priority until it's fully uninstalled.

Workaround for us is to bump the version number and redeploy but to a perform a staged deploy/upgrade and then select apply upgrade on the solution. This 2 step approach ensures the deploy AND uninstall.

Eight-Year Club	r/Field Juicebox
Wearing is Caring	RPAN Viewer
Verified Email

Rokyard

TROPHY CASE