ForAll in the middle of a patch statement! Wow, never would have imagined that. Thanks for explaining how it stops the blinking one experiences when using ForAll the other way. Thanks also for showing how to set the visibility of the button. Great video. Much appreciated.😊
Brian thanks for this. This may solve a problem I am having with using 2 sub-grids. Basically I need to patch one sub-grid from another. Wish Microsoft would let you do lookups cleanly with having to write so much code. Thanks again! Great video!
Great Video Brian Thank you for sharing, may I check with you if by any chance you know why the patch doesn't work with currency field although I made sure the patched value is of a type number. many thanks in advance
Make sure you're not patching into the currency field that has Base in the name. This is for multi-currency and should not be used. "It's not about that base, about that base, about that base" :). -Brian
If all you want to do is edit multiple items either in a view or subgrid form in a model-driven app. You can select all items you want to edit and click the edit button. This allows you to edit the fields that are present in all rows of data to match. This way any change made on the quick edit form thats made will change for all the selected items. You would need to give "Bulk Edit" permissions to the end users who need access to this feature. I believe this is easier for implementation in most use cases.
@@rodcris304 that’s assuming you have any related items yet in the sub grid ;). I never found a way using powerfx and asked Microsoft to enable the Param() function which would be the only way to do it. I had to use JavaScript for it to work properly in the end. The use case was for adding unrelated items or templates and patch them into the subgrid table but without being able to get the parentID when there was no relationship yet made it impossible using patch() on the command bar powerfx way.
Good video, but what you show isn't actually the subgrid, but the main grid aka view. I experience that the notification does only work for main grid and main form, not for subgrid. I guess it becomes "confused being a Table A subgrid under a Table B main form... Have you had the same experience Brian? Know of any workarounds?
Hi! For some reason it does patch them, but it doesn't refresh the grid and it doesn't show the notification. To test I added a test notification before the Patch-formula, and that does show. I'm going to try to find a workaround.
I want to add meta data to my already existing multiple to multiple relationships. Any help or guidance would be much appreciated. Like: multiple ingredients can be part of multiple recipes. And vice versa. I want to add information as to how much of the ingredients (g/ml) goes into each recipe When I’m working with command bar, I’m unable to find middle table in dataverse
You need to create your own custom table, and define 1-Many relationships to it, essentially creating your own many-many intersect table so that you can add more fields to it. You cannot do that to the automatic many-many tables that are created simply by defining a many-many relationship.
Hi Brian. How can I do a subgrid (OrderDetail) ie line items column total in a Model-Driven App using Dataverse Tables by using low-code/nocode methods? (I know there are ways with java script, but I am particularly looking for a solution to calculate the Parent Order $Total by looping through the OrderDetails (line items) for each order. I have already tried Rollup with recalculate and want a more near-real time experience. Ideally also without using Power Automate....Any tips? I want the Easy Button with a Power Fx Action if possible. I mean I find it surprising that that is no quick way to do this yet...at least not that I can find.
@@zack_anderson so there is a way with Flow via a custom page. Also I got a command button to also calculate and patch totals, but it requires a button press to "calculate totals". Custom Page Dialog popup would work, but that also requires javascript to open it in a dialog. So no easy way that I've found yet.
Hi, How to we implement? Dynamics CRM Filter SubGrid with related data from N:N relationship I have an entity called "Project", it's related to "Account" with N:1 relationship. I have a N:N relationship between "Project" and "Contact". So for every project I can add many contacts. Now I have a SubGrid that shows a list of contacts for the project and add existing one. The problem is: when I use the Search lookup to look for contacts, I get all contacts from the system What I need is: to get just the contacts from the Account related to the project. In other words: for every project I want to add many contacts from the account related to the project
ForAll in the middle of a patch statement! Wow, never would have imagined that. Thanks for explaining how it stops the blinking one experiences when using ForAll the other way. Thanks also for showing how to set the visibility of the button. Great video. Much appreciated.😊
This is so brilliant - the ability to use a custom button in this manner - Many thanks
Brian thanks for this. This may solve a problem I am having with using 2 sub-grids. Basically I need to patch one sub-grid from another. Wish Microsoft would let you do lookups cleanly with having to write so much code. Thanks again! Great video!
Great Video Brian Thank you for sharing, may I check with you if by any chance you know why the patch doesn't work with currency field although I made sure the patched value is of a type number. many thanks in advance
Make sure you're not patching into the currency field that has Base in the name. This is for multi-currency and should not be used. "It's not about that base, about that base, about that base" :). -Brian
If all you want to do is edit multiple items either in a view or subgrid form in a model-driven app. You can select all items you want to edit and click the edit button. This allows you to edit the fields that are present in all rows of data to match. This way any change made on the quick edit form thats made will change for all the selected items.
You would need to give "Bulk Edit" permissions to the end users who need access to this feature. I believe this is easier for implementation in most use cases.
Anyway to reference the Parent Item's ID when in a subgrid command bar?
I haven't tried it yet, but you could use LookUp command and take the first record of the subgrid as a reference.
@@rodcris304 that’s assuming you have any related items yet in the sub grid ;). I never found a way using powerfx and asked Microsoft to enable the Param() function which would be the only way to do it. I had to use JavaScript for it to work properly in the end. The use case was for adding unrelated items or templates and patch them into the subgrid table but without being able to get the parentID when there was no relationship yet made it impossible using patch() on the command bar powerfx way.
Good video, but what you show isn't actually the subgrid, but the main grid aka view. I experience that the notification does only work for main grid and main form, not for subgrid. I guess it becomes "confused being a Table A subgrid under a Table B main form... Have you had the same experience Brian? Know of any workarounds?
Hi! For some reason it does patch them, but it doesn't refresh the grid and it doesn't show the notification. To test I added a test notification before the Patch-formula, and that does show. I'm going to try to find a workaround.
I want to add meta data to my already existing multiple to multiple relationships. Any help or guidance would be much appreciated.
Like: multiple ingredients can be part of multiple recipes. And vice versa. I want to add information as to how much of the ingredients (g/ml) goes into each recipe
When I’m working with command bar, I’m unable to find middle table in dataverse
You need to create your own custom table, and define 1-Many relationships to it, essentially creating your own many-many intersect table so that you can add more fields to it. You cannot do that to the automatic many-many tables that are created simply by defining a many-many relationship.
@@davestorey2414 thank you for the reply.
Hi Brian. How can I do a subgrid (OrderDetail) ie line items column total in a Model-Driven App using Dataverse Tables by using low-code/nocode methods? (I know there are ways with java script, but I am particularly looking for a solution to calculate the Parent Order $Total by looping through the OrderDetails (line items) for each order. I have already tried Rollup with recalculate and want a more near-real time experience. Ideally also without using Power Automate....Any tips? I want the Easy Button with a Power Fx Action if possible. I mean I find it surprising that that is no quick way to do this yet...at least not that I can find.
I'm also looking for this
@@zack_anderson so there is a way with Flow via a custom page. Also I got a command button to also calculate and patch totals, but it requires a button press to "calculate totals". Custom Page Dialog popup would work, but that also requires javascript to open it in a dialog. So no easy way that I've found yet.
Is that possible to show subgrid values in column of table
To do this, you'd want to use some Liquid code to make the table feel like whatever you want.
Any video or suggestions created by you will be helpful for me
Hi, How to we implement?
Dynamics CRM Filter SubGrid with related data from N:N relationship
I have an entity called "Project", it's related to "Account" with N:1 relationship.
I have a N:N relationship between "Project" and "Contact". So for every project I can add many contacts.
Now I have a SubGrid that shows a list of contacts for the project and add existing one.
The problem is: when I use the Search lookup to look for contacts, I get all contacts from the system
What I need is: to get just the contacts from the Account related to the project.
In other words: for every project I want to add many contacts from the account related to the project
dind't work on subgrids
Typically the reason it won't work on a subgrid is the visible option. Pay special attnetion to that in the video as it nails me every time too.