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! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-U9AThfx8ZQE.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.