This channel presents my opinions on the direction the Power Platform is moving and provides in-depth how-to style videos to help you learn both low-code and pro-code. I cover Microsoft Power Apps, Power Automate, Power BI, Dataverse, Teams, Azure & Dynamics 365. I am a Microsoft MVP for Business Applications and I just love being part of this amazing community!
Some of my videos will make you laugh 😂, some will make you 'ahh' 💡, and some will make you cry 🥹, but I do hope you enjoy watching!
Awesome work Scott! this works great for daily tasks, but would be nice if it was one big zone where you could extend the taks for instance on a daily schedule you could extend it from 7:00am - 10:00am. almost like a Gantt chart but in-line. If someone has a solution for this please do share :)
@ScottDurow - any idea why, when adding the Drop Zone ID, the Drag and Drop Control is no longer visible, irrespective of whether or not it's defined as a master zone or not? There is data visible in the control without this id, but as soon as the id is entered, the control shows no data. Ideas? Thank you.
I've just recently started to make some apps, forms etc. simple stuff... Now I came across this video and I don't know how to process it. That is crazy.
This is most useful - thank you. Can I assign values to each item to be dragged? So use case - a drag 'n drop quiz and users get marked against what they correctly drag 'n drop and lose points if the drag an incorrect item?
Hi Scott, I get this error when trying to build out the automation connected to the status of a record selected: "Data events are not enabled for this virtual table. VirtualEntityMetadata configuration is missing." Do you know how I can solve this? Thanks!
Thanks very much for this, Scott! Just thinking about so many different ways this could be applied. One thing I'm thinking of is I have a use case whereby I need a "sticky notes" like functionality in my canvas app. Is there a way that we could drag and drop controls (as a whole) around the screen? And is there a way to store user preferences on where they have these controls/items next time they login? Potentially stored in SP list
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?
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!
There is an issue with the most recent version of Power Apps which means you cannot add fields to the component. Whilst this is being fixed, you can use the work around described here github.com/microsoft/powercat-creator-kit/issues/475#issuecomment-2164606080
Thank you for your advice. I was about to give up on the same issue, but with this method, it started working. I'll refer to this and give it a try right away.
It seems there is a bug in the most recent version of Power Apps that means that you can't add fields to PCF controls. It affects all PCF dataset controls. I'll post an update here when I have more information.
Whilst the issue is being fixed - you can use a work around described here github.com/microsoft/powercat-code-components/issues/349#issuecomment-2164610234
Hi Scott. I am building an app with your drag and drog component. This was working fine 2 days before. But now, the add filed property is not working for the component after we select the items. We can click on Add Filed and select the required columns but nothing gets added. I tried with different IDs and Different environments, but the issue is same. Also removed the solution and tried re importing the solution but nothing works. Could you please help.
It seems there is a bug in the most recent version of Power Apps that means that you can't add fields to PCF controls. It affects all PCF dataset controls. I'll post an update here when I have more information.
Whilst the issue is being fixed - you can use a work around described here github.com/microsoft/powercat-code-components/issues/349#issuecomment-2164610234
It looks like a bunch of users are having difficulty adding fields to the component. From the the GitHub issue page it seems as if it started with the new Powerapp version that just came out. Do you have a fix for this?
It seems there is a bug in the most recent version of Power Apps that means that you can't add fields to PCF controls. It affects all PCF dataset controls. I'll post an update here when I have more information.
Whilst the issue is being fixed - you can use a work around described here github.com/microsoft/powercat-code-components/issues/349#issuecomment-2164610234
I'm suddenly unable to edit the fields in the properties. Clearing the cache didn't help. If anyone has a suggestion please do tell! Thanks in advance.
It seems there is a bug in the most recent version of Power Apps that means that you can't add fields to PCF controls. It affects all PCF dataset controls. I'll post an update here when I have more information.
Whilst the issue is being fixed - you can use a work around described here github.com/microsoft/powercat-code-components/issues/349#issuecomment-2164610234
Great and brillant solution that you propose! In 2022, I have tested it and it worked perfectly. 2024, I have a projet and I want to use your component DragAndDrop, I have followed each step but I don't know why the colPeople doesn't show any data from the component DragAndDrop, cannot add field "fullName" anymore. Do I forget sth?
Hi Scott, I've been using this to create my own task scheduler and it is working very well - thank you! However, within the last few, I lost the ability to add new fields to a drag and drop component. The issue is occurring for every drag and drag component I have in my app, and I even tested with a new app. The existing fields are still there and are accessible, but if I remove them, I can't get them back. Are you aware of any recent issues of this nature and what can be done to resolve it?
I made it 12:00 minutes (selecting the column) and even the previous version doesn't show the column after selecting it. I think it is me because there are too many people giving praises here... (I have tried clearing the cache and running the app also)
It seems there is a bug in the most recent version of Power Apps that means that you can't add fields to PCF controls. It affects all PCF dataset controls. I'll post an update here when I have more information.
Whilst the issue is being fixed - you can use a work around described here github.com/microsoft/powercat-code-components/issues/349#issuecomment-2164610234
Would love to see how to transition and develop something new on top of existing design systems like Fluent 2. Like starting with it and then changing it with time. Any suggestions?
The Power Fx Modern Command Grid Button is not working for me. When i try to Patch a Date Column with your code nothing happens. Or it creats new items but not update the old ones. Maybe you have on answer. Thanks a lot!
How can you activate the OnSelect property of the drag and drop component? I am performing a notify in OnSelect but it is not activated when clicking on a record. Can somebody help me? Thanks
Thanks for including the demo of the way it sometimes glitches! On the plus side, I think that same effect helps to overlay the eyes on "top" of light reflections on eyeglasses, although that does not seem to be an issue in your set-up.
This is awesome! What if instead of days, it would be 12 months in a year, and 6 months in range? How could it be done if a task extends to one month, say 3 or 4 months? can the box be extended?
I think the only real "need" for a PCF is if you need something like an control, at least until Microsoft includes one in canvas apps. Great argument against them for basic use cases!
Thank you for the excellent videos, Scott! I have a requirement to be able to schedule the same task multiple times over different days. Do you have any suggestions for how that could be achieved using your drag and drop interface?
I found a solution for this. After I drag the task onto the calendar, I patch a record into a different table, which for me is a task planning line. I then trigger the reset event to move the dropped task back to the task list so it's still visible. To have the dispatch line stay populated in the right cell, I calculate the Zone value when collecting the planning line records, by taking the dispatch date and resource and working backwards to determine the zone value (day value and resource id). It's a bit of a beast, but it works. Here's a snipped of my code which re-collects the planning lines: ClearCollect(colJobPlanningLines, AddColumns( colJobPlanningLinesPreload, Zone, // Calculate day number from dispatch date // Get Resource System Id from Resource No Lookup (Int(DateDiff(dp_Home_DatePicker.SelectedDate, LookUp(gal_DayHeader.AllItems, DateValue(gal_CalendarDays_CurrentDate.Text) = colJobPlanningLinesPreload[@'Dispatch Date'], gal_CalendarDays_CurrentDate.Text),TimeUnit.Days)) + 1) & "|" & Text(LookUp(kxdresource, 'No.' = colJobPlanningLinesPreload[@'No.'] , 'System Id')),
Can someone help. 1. My onDrop fn doesn't trigger when dropped, everything looks to be correct. The fnTaskOnDrop button works when pressed but just not automatically when dropped. 2. When the fnTaskOnDrop button is pressed, the text out of the item disappears. I have copied the Item Template from the unassigned but this behaviour still persists. Thanks in advance for your help.
Hi Scott, I am a little confusing with DropZoneID and OtherDropZoneIDs. I have 4 steps as a Kamban(To do, In progress, Blocked, and Done). At "To do" DropZoneID I set "To do" and in OtherDropZoneIDs I set (In progress, Blocked, Done). It is not working as you showed in the video when you can use drag drop in all "Steps". It is correct the form that I did the OtherDropZoneIDs with comma?
Very interesting innovation, although I suspect it is very much depends on the individual. For me, when I use this feature, I look like a stone cold serial killer.
Thanks Scott! This will improve the end user experience significantly. Could you please share the code for the app you displayed in 0:33 to 1:30. I have similar requirements for one of my apps. I appreciate your effort in taking this to next level. @ScottDurow if you could pls help.
I didn't want to be creepy when I was watching other videos, but now that you're mentioning 😅, your 'original' eyes are so cool, don't do that eye contact thing. It doesn't do justice to the color of your eyes.