Simply incredible 👏🏻 🥇 Each of those tips would’ve been a worthwhile watch by themselves. Your crystal clear explanation finally made the immense value of ‘With’ click for me. Now wondering how we lived without it!!
Great video Scott. When adding the clone child records part I am always getting an error with the ForAll saying "Invalid argument type (Table). Expecting a Record value instead". It appears to be the "As LineItem" part that it's not liking. Is anyone else getting this or have the fundamentals shifted recently?
As usual, a really good video. 😀👍 I am impressed with how fast your app runs in the browser. Which browser are you using? Did you do anything special to optimize the speed?
Great video Scott. Really loved the "fast" approach to Patching multiple items. The "Confirm" function was also something new to me. One question though, can you run instant flows using buttons the command bar. I know there is a default flow dropdown, but I was thinking of an issue where you can just use powerfx to run a flow
Thank you and thanks for watching - glad you found it helpful ☺️ You can trigger a flow using a number of different approaches - check out this video for some ideas! ua-cam.com/video/U9AThfx8ZQE/v-deo.html
Thanks! This is wonderful 😊 Had a query though, in tip no 4, if I only want to update a part of the selected records based on a condition, how can we do the same? Appreciate your response.
I love this feature, so easy to use! Would be great to have the ability to navigate to custom pages using powerFX only some day, I wonder if it's on the roadmap
Hi Scott, In case you wanted the selected items in a subgrid to be patched with the Parent ID of the Main Form record using an fx Command Bar expression, is that something possible? Can the fx Command Bar expression retrieve the Main Form record? Thank you for any hints
Hi Scott, is there a way to prevent user from saving on the editable subgrid? Wanting to add some validation on the data entry on the subgrid and if validation fails, then don't let the user save. Wondering how can this possibly dealt with classic or modern? thanks a lot!
Thank you for the Tipps! I am encountering a bizarre problem. I added a drop-down button to a form using the modern commanding. When I open the MDA using my browser the whole command bar disappears and takes around 20 seconds to appear. Standard buttons like “save” work. My custom ones don’t. If use the Power Apps Desktop Client or a MDA embedded as Teams App the command bar appears immediately and the buttons work. Any idea?
Hey Scott, this is a great tutorial, but I'm running the fast Update method against my account view and it gives me an error that nested patches are not allowed!
Great content! Microsoft needs to do something about the poor performance around publishing in general. For this type of publish event, the delay is somewhat understandable. But publishing a new version of a Form, for example, many times takes 15-20 minutes for the new Form to appear. And don’t get me started with the ever-devolving performance of Classic mode for performing any admin/dev work…
Hi - thank you and thanks for watching and subscribing ☺️ It always seems to take longer when I watch the spinning wheel - but if I go and do something else I get distracted!
Hi Scott. For the "update records fast part". Is there a way to do this for bulk deletion of records using Remove or RemoveIf for a parallel call to the DB rather than a sequential loop of calls
Thx, Scott, for this interesting overview. If I may give a suggestions for a 6th tip: how to (if possible) migrate commands from one app to the other. I encountered issues when reusing a customized form with form command buttons from app A (e.g. sales app) in app B (e.g. customer service), because commands are linked per App. So, in app B, you can perfectly reuse the customized form but none of the commands on the form are available anymore. I tried different solutions (e.g. reimporting the commands in Solution B) , but at the end I had to manually recreate every command and underlying code in App B... So, if there would be a quick fix for this issue, I would like to get that "6th tip" 😉
Thank you and thanks for watching - That is a great idea - ALM is an important topic for sure. Currently by default when you add a button to an app, it will only be added to that app and not appear in any others. There is a way to convert a button into a 'table' scoped command so that it will appear in all apps - you can learn more here - learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/commanding-scopes I'll definitely add this to my list for future videos! Thank you again 😊
I am facing a weird problem. On form edit when user edit and immediately click any custom command bar button, the notification and navigation are not working But when user click save and then custom command button, navigation and notification works fine. Any reason why notifications and navigation didn’t work on unsaved form I have autosave turned on by the way.
@Scott: Thanks for the tips. wanted to check if have you faced any issues in setting the command visibility based on the lookup field. I feel that the New command bar's visibility functionality is not stable. - Maniraj
You can turn off auto save - but this would apply to normal form loads and navigating as well. learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/manage-auto-save
At this time modern commanding does not allow you to do this - you will need to use the Ribbon Workbench - d365demystified.com/2020/02/19/hide-custom-ribbon-button-easy-way-ribbon-workbench/
Am I the only one who can't edit the FX for a custom button? I create a button and the FX-command is disabled. What I find in the browser console: error: { code: "0x80040217" message: "Entity 'appaction' With Id = 0f25xxxx-7773-xxxx-a256-737644d795b6 Does Not Exist"} For me it looks like a developer misspelled "application" and now the GUI breaks.
Hi Thank you for watching! Yes- the component library and the buttons are separate solution components - they will automatically get added into the solution that contains the app you are working on. 👍
Really useful one. It reduces the effort. The documentation says User() is not supported. Is there any alternate way of getting this? Really don't want to use JS just for this :(
Hi! Thank you so much and thanks for watching. I hope User() will be supported in the future too - today it depends on what you need to do - you can use RecordInfo() and DataSourceInfo() to use permissions for visibility rules.
@@ScottDurow : I need to set the lookup with a current user after confirmation on button click. So getting the userid or emailid of the currrent user is the challenge here.
How do I prompt the user for a number if I would like to update several records, instead of using a random numbers. And especially if I would like the user to select something from a lookup. Lets say update "customer" for a number of opportunities. Would that be possible?
There is no question that RWB is best among all the tools I used to work with Ribbon/Command Bar. But when the Guru himself show us the way to transition into Power FX slowly how can we not follow. Power FX is the future :)
Why this wont work for me?? i try it with Opportunities. i wanna Copy a Opportunity with Opportunityproducts. i just get Errors in my PowerFX Action, it wont work.. With({ opportunity: Patch('Opportunities', Defaults('Opportunites'), { Name: Self.Selected.Item.Betreff & " (copy)" } ) }, // Clone child records );
Very likely you don't have all conditions for creating an opportunity record in place. Sometimes missing mandatory fields prevent record creation without any warning.
Hey Scott, I am a citizen developer and learned a lot from your videos. Many things successfully adopted for my own app. Thanks a lot for sharing.
Simply incredible 👏🏻 🥇 Each of those tips would’ve been a worthwhile watch by themselves. Your crystal clear explanation finally made the immense value of ‘With’ click for me. Now wondering how we lived without it!!
Really glad you found it helpful! Thanks for those kind works and thanks for watching ☺️
Great video again. Thank you Scott for sharing!
My pleasure! Thank you for watching ☺️
As usual very useful, thanks Scott
Thank you so much - glad it was helpful - and thank you for watching and subscribing 😊
Great video Scott. When adding the clone child records part I am always getting an error with the ForAll saying "Invalid argument type (Table). Expecting a Record value instead". It appears to be the "As LineItem" part that it's not liking. Is anyone else getting this or have the fundamentals shifted recently?
As usual, a really good video. 😀👍
I am impressed with how fast your app runs in the browser. Which browser are you using? Did you do anything special to optimize the speed?
Thank you so much and thanks for watching! 😊Nothing special - just Edge!
Great video Scott. Really loved the "fast" approach to Patching multiple items. The "Confirm" function was also something new to me.
One question though, can you run instant flows using buttons the command bar. I know there is a default flow dropdown, but I was thinking of an issue where you can just use powerfx to run a flow
Thank you and thanks for watching - glad you found it helpful ☺️ You can trigger a flow using a number of different approaches - check out this video for some ideas!
ua-cam.com/video/U9AThfx8ZQE/v-deo.html
Thanks! This is wonderful 😊 Had a query though, in tip no 4, if I only want to update a part of the selected records based on a condition, how can we do the same? Appreciate your response.
I love this feature, so easy to use! Would be great to have the ability to navigate to custom pages using powerFX only some day, I wonder if it's on the roadmap
I hope so - being able to show custom pages as dialogs from Power Fx would be amazing! Thank you for watching 😊
What an informative video. Keep it up mate! ❤
Thank you so much for watching ☺️
Hi Scott,
In case you wanted the selected items in a subgrid to be patched with the Parent ID of the Main Form record using an fx Command Bar expression, is that something possible? Can the fx Command Bar expression retrieve the Main Form record?
Thank you for any hints
Thanks Scott, top stuff as ever!
Thank you 😊 and thanks for watching and your support.
Great tips thanks Scott. Btw, do you know of a good OBS annotation tool? (free) or what do you use to draw those red boxes?
Hi Scott, is there a way to prevent user from saving on the editable subgrid? Wanting to add some validation on the data entry on the subgrid and if validation fails, then don't let the user save. Wondering how can this possibly dealt with classic or modern? thanks a lot!
Thank you for the Tipps!
I am encountering a bizarre problem. I added a drop-down button to a form using the modern commanding.
When I open the MDA using my browser the whole command bar disappears and takes around 20 seconds to appear. Standard buttons like “save” work. My custom ones don’t.
If use the Power Apps Desktop Client or a MDA embedded as Teams App the command bar appears immediately and the buttons work.
Any idea?
Hey Scott, this is a great tutorial, but I'm running the fast Update method against my account view and it gives me an error that nested patches are not allowed!
Great content! Microsoft needs to do something about the poor performance around publishing in general. For this type of publish event, the delay is somewhat understandable. But publishing a new version of a Form, for example, many times takes 15-20 minutes for the new Form to appear.
And don’t get me started with the ever-devolving performance of Classic mode for performing any admin/dev work…
Hi - thank you and thanks for watching and subscribing ☺️ It always seems to take longer when I watch the spinning wheel - but if I go and do something else I get distracted!
The With is really cool. Almost like a CTE in T-Sql right?
Hi Scott. For the "update records fast part". Is there a way to do this for bulk deletion of records using Remove or RemoveIf for a parallel call to the DB rather than a sequential loop of calls
Thx, Scott, for this interesting overview.
If I may give a suggestions for a 6th tip: how to (if possible) migrate commands from one app to the other. I encountered issues when reusing a customized form with form command buttons from app A (e.g. sales app) in app B (e.g. customer service), because commands are linked per App. So, in app B, you can perfectly reuse the customized form but none of the commands on the form are available anymore. I tried different solutions (e.g. reimporting the commands in Solution B) , but at the end I had to manually recreate every command and underlying code in App B...
So, if there would be a quick fix for this issue, I would like to get that "6th tip" 😉
Thank you and thanks for watching - That is a great idea - ALM is an important topic for sure. Currently by default when you add a button to an app, it will only be added to that app and not appear in any others. There is a way to convert a button into a 'table' scoped command so that it will appear in all apps - you can learn more here - learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/commanding-scopes
I'll definitely add this to my list for future videos! Thank you again 😊
@Scott Durow I knew you still had a sixth tip up your sleeve 😀 I highly appreciate the tip and looks like it'll solve my problem. Huge thanks!
Tip No. 4 🔥🔥🔥
I am facing a weird problem. On form edit when user edit and immediately click any custom command bar button, the notification and navigation are not working
But when user click save and then custom command button, navigation and notification works fine.
Any reason why notifications and navigation didn’t work on unsaved form
I have autosave turned on by the way.
Do you know how to hide some of the existing buttons easily without using workbench tool or complex java?
@Scott: Thanks for the tips. wanted to check if have you faced any issues in setting the command visibility based on the lookup field. I feel that the New command bar's visibility functionality is not stable.
- Maniraj
Hi Maniraj - thank you and thanks for watching 😊What is the Power Fx visibility expression you are using?
You should be refunded by social security !! Love your content !! 😇
My Data is not getting updated from Main Grid.. I tried with both fast and slow method
Nice video Scott in my senario I just want to update all child records of one of my parent record can you help me with that power fx formula thanks.
Hi Scott thanks , how do we export this in a solution. Seems cant find even in default solution
Can you hide an button based on users security roles?
Hi Scott, thanks for the tips! One question, is there any way to cancel the 'autosave' that is done before the commands are initiated?
You can turn off auto save - but this would apply to normal form loads and navigating as well. learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/manage-auto-save
Scott this is great but when i apply it to a Main Grid not a form the button disappears, have you seen this before?
Hi! On a grid - you would need to add a Visibility expression such as CountRows(Self.Selected.AllItems)>0
Hi Scott, my requirement is to remove certain buttons from the classic commanding experience. How can I do that? Thank you.
At this time modern commanding does not allow you to do this - you will need to use the Ribbon Workbench - d365demystified.com/2020/02/19/hide-custom-ribbon-button-easy-way-ribbon-workbench/
Am I the only one who can't edit the FX for a custom button?
I create a button and the FX-command is disabled.
What I find in the browser console:
error: {
code: "0x80040217"
message: "Entity 'appaction' With Id = 0f25xxxx-7773-xxxx-a256-737644d795b6 Does Not Exist"}
For me it looks like a developer misspelled "application" and now the GUI breaks.
Ribbon workbench is dead, long live Ribbon workbench! Great video.
Hehe - thank you for watching ☺️ it does seem the RWB is going to be around for a while yet!
Is that component library a separate component required to be included in the solution for export , import ?
Hi Thank you for watching! Yes- the component library and the buttons are separate solution components - they will automatically get added into the solution that contains the app you are working on. 👍
Really useful one. It reduces the effort. The documentation says User() is not supported. Is there any alternate way of getting this? Really don't want to use JS just for this :(
Hi! Thank you so much and thanks for watching. I hope User() will be supported in the future too - today it depends on what you need to do - you can use RecordInfo() and DataSourceInfo() to use permissions for visibility rules.
Thank you Scott.
@@ScottDurow : I need to set the lookup with a current user after confirmation on button click. So getting the userid or emailid of the currrent user is the challenge here.
How do I prompt the user for a number if I would like to update several records, instead of using a random numbers. And especially if I would like the user to select something from a lookup. Lets say update "customer" for a number of opportunities. Would that be possible?
Yes you could do this by displaying a custom page from the command bar and performing the update there.
You are a god
Your ribbon workbench is still the best. Nothing can replace it.. nice try power fx.
Awww thank you for saying so! 🤩And thanks for watching and your support ☺️
There is no question that RWB is best among all the tools I used to work with Ribbon/Command Bar. But when the Guru himself show us the way to transition into Power FX slowly how can we not follow. Power FX is the future :)
Why this wont work for me?? i try it with Opportunities. i wanna Copy a Opportunity with Opportunityproducts. i just get Errors in my PowerFX Action, it wont work..
With({
opportunity:
Patch('Opportunities',
Defaults('Opportunites'),
{
Name: Self.Selected.Item.Betreff & " (copy)"
}
)
},
// Clone child records
);
Very likely you don't have all conditions for creating an opportunity record in place. Sometimes missing mandatory fields prevent record creation without any warning.