Reza, you keep raising the bar for what PowerApps can achieve and it's impressive. Thanks again for your time....oh...and my guess for structure was almost on point..😄.
Thank you so much man, I was looking for a good explanation about it and finally found a good content to consume, you do it astonishingly well. Keep doin' it, God bless you!
Thank you so much. I watched and liked your video when it was released. Today I have implemented Kanban board view in my app. You are always helpful sir.
Amazing ❤...Great video... I am learning a lot from your videos. Can you please share the List template with content and do some videos on PowerApps as well? At least can you tell me how can I get dummy data instead of manually adding items?
Template is a standard list template "Work progress tracker". Image was shown in video. This video is a Power Apps video. I have over 100+ Power Apps videos. Check ruclips.net/p/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR I cannot share dummy data as no easy way to do so with SharePoint. I only had 5-10 items which you can easily recreate.
Stellar work as always, Reza. One minor thing: swim lanes in Kanban mean something different. Swim lanes are different work streams. The number and types of statuses will typically differ from swim lane to swim lane. The swim lanes are horizontal, not the vertical columns.
Thanks Andreas. A week ago I did not even know what Kanban meant. Read a lot about it. Swim lanes was my take :) I should have known more. Thanks for pointing that out.
@@RezaDorrani Week after week, I'm just floored watching the first rate content that you put out with no end in sight. If on top of that you were an expert in every single area that you build solutions for, I'd probably quit my job.
Excellent, the Kanban Boards is something that we are looking for to implement in our PowerApps. I know you keep referring to SharePoint but we are not using SharePoint we are using Dataverse. I would like to share the PowerApps application with you once we are done. Please keep up the excellent work.
Thanks George. Glad to hear that this video is useful. The Board will work with any data source of your choice. I choose SharePoint because it is a standard connector and used by many.
Hi Reza, once again a great piece of work!! Kudos! I'm a beginner and have learned most of the Power Apps watching your videos, you're like my "GURU"! Hats Off! Now I'm eager to use this Kanban board and have imported your file, but have many errors, I guess because of the data source, please suggest me how to fix it and use the app. Should I create my own SharePoint list with columns you've used and link with the app? Please help!
Thanks so much! Yes, you would need to create your own data source and add columns. There is no easy way for me to share the SharePoint list template in modern SharePoint. Better option is to create it from scratch. Create a simple list with 1-2 columns and build the board. Then grow on it.
this is a great video. is there any documentation non how to achieve something like board style 3 that you mentioned (specifically on how to get the count of items for that group )
Thank you for the tutorial! This is great and something I would like to implement in Power Apps. My question is, using the Power Apps solution, would it be possible to write-back information to the Sharepoint list? For example, if I move an item from 'In progress' to 'Completed', will these updates be automatically written to my Sharepoint list as well? Many thanks!!
There is no collection for the gallery items. It is a direct filter query against data source. This technique supports delegation. I covered same concept in GroupBy video. Check ruclips.net/video/57ADxeo_13k/видео.html
I love this video and love the board examples you've designed. I just hate that I'm watching it a year later. I'm unable to utilize the designs that you posted. Do you have any videos showing how to make the design of a thumbtack and sticky note?
Yes, I did downloaded the entire App and managed to customise to my type List. But those sticky notes from the media are still something that I don't know how I could make them in any other App 😢. are they just an individual pictures in PNG format?
I seem to get a division by zero error at startup when I size the gallery columns based on the number of rows. Is this normal or might I have made a mistake? The error appears to resolve after the data loads.
@@TheRemyRomano It assumes list has data. The logic in App where template size is calculated based on countrows. You can first do a check if countrows is empty.
Nice video and +1 new subscriber. Just a question Reza. I've created this similar kanban board like yours according to my needs. I pretend to use Combobox and Textbox controls to filter the Gallery Results but I'm having some issues changing the Items Property on each gallery, How can i fix it? Thans in advance and greetings from Mexico ☝️🇲🇽
Thanks for the sub. I would have to look at your app and scenario in action to know more about your issue. It would be best to post your issue with screenshots on forums (many experts on forums assist in their free time) powerusers.microsoft.com
This is purely a Power Apps video. I am not aware of the possibilities with Power BI. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reza, I'd like to drag and drop style, as a packing list where the container of items are a box, container, pallet. And look and field is a drag and drop.... Do you have a video about it ?
I do not have a video on gantt chart. Possible for sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, another great video. Thank you. I have learned a lot from watching your videos. I have a question about Power Apps that I can't seem to find the answer to online, and if it is possible, it might make a good video idea. In almost all instances, the Power Apps being shown are linked back to a fixed data source (by that I mean the data source itself doesn't change, even though the data within it obvioulsy can be updated). Is it possible to build an app that has the ability to modify the datasource that it is connected to? For example, lets say each team, or each project, used a SharePoint list. The list columns are exactly the same, but the actual list items would vary from team to team (or project to project). Is it possible to build one app, which has the ability to 'work with' all of these different datasources (lists). I am envisaging some kind of dropdown select box on the home screen where you would select the list/source, and then click a button, and the app would refresh with the chosen data source. Hopefully this request makes sense. I have a use case where we have a SharePoint list 'template' (fixed column names/column types and initial list item descriptions) that is used for each new project. Once created, the new list (based on the template) is then used to track the project, so depending on the project (list), each list item might have different meta data - eg assigned to, progress, priority, etc.
Thanks for watching and liking my videos. Dynamic data source linking is currently not a feature with Power Apps and that's probably the reason why there is no solution online. You can use apps that modify a data source, but that would have to be done via flow and would be a challenge to design the App. I did make a video on dynamic forms in power apps wherein the form changes based on backend configuration - ruclips.net/video/wQqetH2QLyk/видео.html
Thank you for the video Reza, we were able to implement a similarly constructed board based on your video. If we want to hide one tray, ex. Hide completed items gallery - what would be a route we could take to do that without hiding the other galleries?
The top gallery (board list) is loading from the choices from the sharepoint list. That you can apply a filter function and remove the tray you do not need.
Thank you, Reza once again! Could you tell me, how can I download all images in bulk from your solution? I don't see a way. I just wanted to copy it into my app.
@@RezaDorrani thank you for reply! I did it earlier, but there are no images inside. Just json file, another nested folder with another nested folder with another json and few png images and msapp which I cannot open even with Visual Studio
Hello Sir,With reference to your video was able to create kannan board style 3,do we have an option to add columns dynamically as per user requirements for the status in power apps.can we create user stories (agile)and jira type ui in kanban board.Any help very much appreciated.Thank you for your guidance ,with your videos i have been learning many things begin a new beginner.Appreciate it.
Dynamically adding columns behavior is not a feature (yet) in power apps. You could build dynamic schema like experiences but it requires more customizations. Example: ruclips.net/video/wQqetH2QLyk/видео.html
Nice work again Reza, where do you get the time to make all this again. 🙏 I note that drag and drop is not yet possible in Power Apps. Is that correct? I made an attempt myself to make a drag and drop feature with a slider. But I am missing the right events for the slider.
There's an interesting code component created by Scott Durow that allows drag and drop but it may not be as fully featured as you need - ruclips.net/video/tF0yJHX2L0Y/видео.html
hello sir, i am thouraya an engineer student in tunisia. I'm really fascinated by your work on the kanban board and I'm really excited to do this model again, please, if you don't mind, send me one of the kanbon board models. THANKS IN ADVANCE FOR YOUR HELP.
Hi Reza Dorrani, First of all, thanks for the videos! I need help creating filters in this model, how do I filter the ID or Card Name in this type of structure?
@@RezaDorrani Thank you for your help, unfortunately I couldn't find the link, if you could share the written code of the application I would appreciate it (sorry for the inconvenience and congratulations on the work)
As usal awsome video. Thanks Reza. I downloaded your app and trying to use the Filter and form section with multiple screen with each having different datasource and forms. Everything works fine for the first screen. However from 2nd screen onwards the edit icon on the gallery is not responding. All other functions are working fine. Any thoughts?
You need to ensure you delete connected data source in app and add your connection + your columns in list should match the columns needed by App (which are from MS List template)
@@RezaDorrani Yeah, i did that. i deleted the original datasource and connected to 5 new lists with appropriate collections for each. All the list have same no. of columns and column types. i am using the same global variables for each screen with each galleries and forms connected to respective lists. I am really sorry to bother you but is it possible for you to please duplicate your form and filter screen and add the duplicated screen another datasource to see if the edit icon works in that case? if Yes, is there any twig that needs to be done.
@@kanjyoklama4651 I will not be able to do that since Im working on other things now. You must be getting some error message in App. I would recommend posting that error and screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani No, i am not getting any errors. Everything looks fine and works great expect the edit icon on 2nd screen onwards. I will use the forum for further support. Thanks again for your reponse and awesome vidoes.
I am just curious to know, Ive we move an item from one status to another , Does it also gets updated in the list?? . Also in the requirement that i am working i need to add few more portlets below, I have used a scrollable page and added visuals but they seem to overlap, Can you help with this please
Yes, it does get updated in list. You could use responsive containers to have scrolls that dont overlap. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Should be possible but this is not something I have tried and I do not have a video reference for. Idea would be to to calculate last modified time with current time whenever user initiates a status change.
Great Content Reza, actually that helped a lot, but the problem is I cant select items in my gallery to redirect it to an Edit Form, Any possible way to do that ?
Video description has link to download sample app. Give that a try. If issue persists, I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani We can create drag and drop using slider and based on its value we can patch the item with updated status, if we want to drag and drop almost anywhere in screen we can use timer auto turn on , repeat on, where duration is 0 seconds and change layout of slider horizontal and vertical based on timer and then we can achieve desired result , I have created it for my company.
@@RezaDorrani yes, I kept two galleries side by side, I know the x axis of both gallery, horizontal slider is made invisible and on the handle I bring a label or icon value passed by variable from left gallery selected item, user moves handle actually but only label or icon moves and cross a certain x axis value of second gallery and release the handle at that moment on change of slider default value ,I know that user has reached on top of second gallery and hence I immediately patch selected item value present in label from gallery 1 to 2
@@vaishakr3403 Probably possible but not sure what that logic would be as I would have to try it out. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Every App has OnStart. Might be some bug on your end. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani How much effort would it take on your part to do a follow-up video showing how to add multiple persons "Resources" to a task on the Kandan Board's? Please
@@georgegualda4262 You can store user emails semicolon separated in a column and work with that. I do not have a video reference on this though. I will recommend posting your query on the forums at powerusers.microsoft.com
How can I create kanban board view for two column its just a show for progress board how can i create for priority board, anyone can help me in formula
I would have to try it out to provide the formula. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Attachments not supported in Patch function. But the form control dialog that opens (its in video demo), it can have attachments control. I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
HI Reza, I tried to build the same kind of board using Dataverse connector and Using Optionset field. ON App start : ClearCollect( WICOL, Filter( Choices('Work items (Accounts)'), Text(Value) "Inprogress" ) ); Clear(COLWISeq); ForAll( Sequence(CountRows(WICOL)), Collect( COLWISeq, { Value: Last( FirstN( WICOL, ThisRecord.Value ) ).Value, RowNo: Value } ) ); But Value is not showing for me. Instead of that, "This data type is unsupported for evaluation" displaying as value. Displaying the data in Text field and in Cards is working. Value is not able to fetch When I use the formula for arrow icons. where I did the mistake? RowNo_LBL = ThisItem.RowNo For left and Right arrows functionality: Patch( Accounts, ThisItem, {'Work items': {Value:LookUp(COLWISeq,RowNo = Value(RowNo_LBL.Text)+1).Value}} ); Can you help me on this please?
Thanks for the reply! Posted a question on last Thursday with heading "This data type is unsupported for evaluation in powerapps while retrieving Option set value." One guy responded, But not given any answer for the on this issue.
@@user-qg7tp7xh1j I have no plans to investigate on this issue as I did not experience it. Im working on other video ideas. Forums will be your best bet.
Reza, you keep raising the bar for what PowerApps can achieve and it's impressive. Thanks again for your time....oh...and my guess for structure was almost on point..😄.
Thanks Cris. Your guess was close :)
This is what I wanted to do in PowerApps from the very beginning but didn't think I would ever find out how. Thank you!!
You are most welcome.
Thank you so much man, I was looking for a good explanation about it and finally found a good content to consume, you do it astonishingly well. Keep doin' it, God bless you!
Glad to hear it!
Look and feel of board is really amazing and would love to implement it for the upcoming project. Thanks for the design idea.
Glad to hear that! Thanks Manoj.
Nice to wake up to this training. Very cool. As always, providing us what we need for day to day business. Thank you.
Glad you enjoyed it! Thanks for watching Chantel.
Thank you so much. I watched and liked your video when it was released. Today I have implemented Kanban board view in my app. You are always helpful sir.
Great to hear!
Amazing ❤...Great video... I am learning a lot from your videos.
Can you please share the List template with content and do some videos on PowerApps as well?
At least can you tell me how can I get dummy data instead of manually adding items?
Template is a standard list template "Work progress tracker". Image was shown in video.
This video is a Power Apps video. I have over 100+ Power Apps videos. Check ruclips.net/p/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR
I cannot share dummy data as no easy way to do so with SharePoint. I only had 5-10 items which you can easily recreate.
Stellar work as always, Reza.
One minor thing: swim lanes in Kanban mean something different. Swim lanes are different work streams. The number and types of statuses will typically differ from swim lane to swim lane. The swim lanes are horizontal, not the vertical columns.
Thanks Andreas.
A week ago I did not even know what Kanban meant. Read a lot about it. Swim lanes was my take :) I should have known more. Thanks for pointing that out.
@@RezaDorrani Week after week, I'm just floored watching the first rate content that you put out with no end in sight. If on top of that you were an expert in every single area that you build solutions for, I'd probably quit my job.
@@microfuel :)
@@microfuel hahahahah very well said. That's why should keep Reza busy in youtube videos :)
Excellent, the Kanban Boards is something that we are looking for to implement in our PowerApps. I know you keep referring to SharePoint but we are not using SharePoint we are using Dataverse. I would like to share the PowerApps application with you once we are done. Please keep up the excellent work.
Thanks George. Glad to hear that this video is useful.
The Board will work with any data source of your choice.
I choose SharePoint because it is a standard connector and used by many.
Awesome video Reza... I am working on this with your references. Thank you
👍
Loved it! thank you so much! This is amazing!
You're so welcome!
Guru Gee
Great video.
Thanks for such a wonderful experience.
Thanks Ali
Amazing video Reza.
Thank you for this artwork!!!
My pleasure!
Thank you Reza. Another knowledge gained
Glad to hear it
So amazing🤩🤩🤩 Love this!!
I had a feeling you would be the first one to comment on this 😊
Thank You for watching & liking the video.
wow... your the best!!!!!!!!
thanks for all!!!!
Wow! Thank You.
Amazing Reza... Only last week made Kangan dashboard but had used BI. But would use your logic in something different. As always 👍
Great 👍
Brilliant (as usual) 👍👍👊👊💥💥 Thanks Reza
My pleasure!
Great Reza, brilliant and useful ideas 💡
Thanks
Great job
Thanks
👏👏👏well done Reza. This is so helpfull
Glad it was helpful!
Amazing Reza. I'm learning a lot from your videos. Thanks !!!
Glad to hear that! Thanks for watching
Amazing work as always! 💯 Do you think you'll ever teach extracting data from email to SharePoint list?
Never say never. If I get a lot of folks requesting this topic, then Yes.
Hi Reza, once again a great piece of work!! Kudos! I'm a beginner and have learned most of the Power Apps watching your videos, you're like my "GURU"! Hats Off! Now I'm eager to use this Kanban board and have imported your file, but have many errors, I guess because of the data source, please suggest me how to fix it and use the app. Should I create my own SharePoint list with columns you've used and link with the app? Please help!
Thanks so much!
Yes, you would need to create your own data source and add columns. There is no easy way for me to share the SharePoint list template in modern SharePoint.
Better option is to create it from scratch. Create a simple list with 1-2 columns and build the board. Then grow on it.
As usual Reza, impressive
Thanks Ammar
this is a great video. is there any documentation non how to achieve something like board style 3 that you mentioned (specifically on how to get the count of items for that group )
I believe video description has link to download sample app which includes all styles showcased in video
Beautiful. Working well
Thanks
Do you have a Tutorial Series on Better UI/UX Design for Canvas Apps ? Really Liking your Design Choices :D
Keep the good work up my friend :)
Thanks! Most of my videos are in my Power Apps playlist. Some of them include design logic. Example: ruclips.net/video/bnC8u3gdWss/видео.html
Fantastic work as always
Thank you!
You are the GOAT....
Wow! Thanks for the compliment :)
thanks to much
Your most welcome
Thank you for the tutorial! This is great and something I would like to implement in Power Apps. My question is, using the Power Apps solution, would it be possible to write-back information to the Sharepoint list? For example, if I move an item from 'In progress' to 'Completed', will these updates be automatically written to my Sharepoint list as well? Many thanks!!
Yes, the updates do write back to SharePoint list.
Hi Reza, I had wondered about holding this might work. Thanks. But how does your collection for the gallery update after your patch?
There is no collection for the gallery items.
It is a direct filter query against data source. This technique supports delegation. I covered same concept in GroupBy video. Check ruclips.net/video/57ADxeo_13k/видео.html
This is amazing!
Thanks
Brilliant!
Thanks
Thank You Reza!!
Most welcome!
I love this video and love the board examples you've designed. I just hate that I'm watching it a year later. I'm unable to utilize the designs that you posted. Do you have any videos showing how to make the design of a thumbtack and sticky note?
Video description has link to download the app.
This is lovely! thank you... but I cannot get my head around how did you added PostIn(colour) sticky notes.... have you got a tutorial on this?
Most welcome!
Video description has link to download entire App showcased. I will recommend checking that.
Yes, I did downloaded the entire App and managed to customise to my type List. But those sticky notes from the media are still something that I don't know how I could make them in any other App 😢. are they just an individual pictures in PNG format?
@@karolinaunderwood1039 They are individual pictures uploaded in app
@@RezaDorrani thank you so much for everything. You're always my No.1 to go to YT for my projects
Nice job. Thank you!
Thanks for watching!
I seem to get a division by zero error at startup when I size the gallery columns based on the number of rows. Is this normal or might I have made a mistake? The error appears to resolve after the data loads.
@@TheRemyRomano It assumes list has data. The logic in App where template size is calculated based on countrows. You can first do a check if countrows is empty.
Awesome.
Thanks!
Nice video and +1 new subscriber.
Just a question Reza. I've created this similar kanban board like yours according to my needs. I pretend to use Combobox and Textbox controls to filter the Gallery Results but I'm having some issues changing the Items Property on each gallery, How can i fix it? Thans in advance and greetings from Mexico ☝️🇲🇽
Thanks for the sub.
I would have to look at your app and scenario in action to know more about your issue.
It would be best to post your issue with screenshots on forums (many experts on forums assist in their free time)
powerusers.microsoft.com
Very nice work! Can we create this Kanban board on Power BI Desktop?
This is purely a Power Apps video. I am not aware of the possibilities with Power BI. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks you, one more time.
You are most welcome!
Thanks Reza, I'd like to drag and drop style, as a packing list where the container of items are a box, container, pallet. And look and field is a drag and drop.... Do you have a video about it ?
Check ruclips.net/video/mlrg0OfF4e8/видео.html
Hi Reza, Love this got it working, is there a way to do Assigned to Sort with a button? Thanks 🙂
Check my sorting video ruclips.net/video/6KlI1iZ_KD0/видео.html
Hi Reza, thanks for the video which clearly explains about the Kanban chart. Is there anyway to achieve even the gantt chart.
I do not have a video on gantt chart. Possible for sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thank you . I shall will look at it.
Hi Reza, another great video. Thank you. I have learned a lot from watching your videos.
I have a question about Power Apps that I can't seem to find the answer to online, and if it is possible, it might make a good video idea. In almost all instances, the Power Apps being shown are linked back to a fixed data source (by that I mean the data source itself doesn't change, even though the data within it obvioulsy can be updated).
Is it possible to build an app that has the ability to modify the datasource that it is connected to?
For example, lets say each team, or each project, used a SharePoint list. The list columns are exactly the same, but the actual list items would vary from team to team (or project to project). Is it possible to build one app, which has the ability to 'work with' all of these different datasources (lists). I am envisaging some kind of dropdown select box on the home screen where you would select the list/source, and then click a button, and the app would refresh with the chosen data source.
Hopefully this request makes sense. I have a use case where we have a SharePoint list 'template' (fixed column names/column types and initial list item descriptions) that is used for each new project. Once created, the new list (based on the template) is then used to track the project, so depending on the project (list), each list item might have different meta data - eg assigned to, progress, priority, etc.
Thanks for watching and liking my videos.
Dynamic data source linking is currently not a feature with Power Apps and that's probably the reason why there is no solution online.
You can use apps that modify a data source, but that would have to be done via flow and would be a challenge to design the App.
I did make a video on dynamic forms in power apps wherein the form changes based on backend configuration - ruclips.net/video/wQqetH2QLyk/видео.html
Thank you for the video Reza, we were able to implement a similarly constructed board based on your video.
If we want to hide one tray, ex. Hide completed items gallery - what would be a route we could take to do that without hiding the other galleries?
The top gallery (board list) is loading from the choices from the sharepoint list. That you can apply a filter function and remove the tray you do not need.
Thank you, Reza once again!
Could you tell me, how can I download all images in bulk from your solution? I don't see a way. I just wanted to copy it into my app.
You mean images within the app?
You would need to download zip file for app. Unzip and within the folder structure there would be all the images.
@@RezaDorrani thank you for reply!
I did it earlier, but there are no images inside. Just json file, another nested folder with another nested folder with another json and few png images and msapp which I cannot open even with Visual Studio
@@denisskorikov6234 I believe there is way. I do not have this documented or in a video reference though. Check on forums powerusers.microsoft.com
Hello Sir,With reference to your video was able to create kannan board style 3,do we have an option to add columns dynamically as per user requirements for the status in power apps.can we create user stories (agile)and jira type ui in kanban board.Any help very much appreciated.Thank you for your guidance ,with your videos i have been learning many things begin a new beginner.Appreciate it.
Dynamically adding columns behavior is not a feature (yet) in power apps. You could build dynamic schema like experiences but it requires more customizations. Example: ruclips.net/video/wQqetH2QLyk/видео.html
Nice work again Reza, where do you get the time to make all this again. 🙏
I note that drag and drop is not yet possible in Power Apps. Is that correct?
I made an attempt myself to make a drag and drop feature with a slider. But I am missing the right events for the slider.
Thank You!
Drage and drop is not supported. You can use slider but it becomes complex and is a clunky experience.
There's an interesting code component created by Scott Durow that allows drag and drop but it may not be as fully featured as you need - ruclips.net/video/tF0yJHX2L0Y/видео.html
hello sir, i am thouraya an engineer student in tunisia. I'm really fascinated by your work on the kanban board and I'm really excited to do this model again, please, if you don't mind, send me one of the kanbon board models.
THANKS IN ADVANCE FOR YOUR HELP.
Thank You Thouraya.
Video description has link to download the sample App.
Hi Reza Dorrani,
First of all, thanks for the videos!
I need help creating filters in this model, how do I filter the ID or Card Name in this type of structure?
Welcome!
Video description has link to download the app showcased in video which includes filters.
@@RezaDorrani Thank you for your help, unfortunately I couldn't find the link, if you could share the written code of the application I would appreciate it (sorry for the inconvenience and congratulations on the work)
@@lelgs Link is in video description. Description is open for all. I have done this video months ago and hence don't have access to the code anymore.
@@RezaDorrani Thank you very much and much success!
Great idea, thanks.
Is it possible to make it by drag and drop?
There is a pcf component available for that.
thx
👍
As usal awsome video. Thanks Reza. I downloaded your app and trying to use the Filter and form section with multiple screen with each having different datasource and forms. Everything works fine for the first screen. However from 2nd screen onwards the edit icon on the gallery is not responding. All other functions are working fine. Any thoughts?
You need to ensure you delete connected data source in app and add your connection + your columns in list should match the columns needed by App (which are from MS List template)
@@RezaDorrani Yeah, i did that. i deleted the original datasource and connected to 5 new lists with appropriate collections for each. All the list have same no. of columns and column types. i am using the same global variables for each screen with each galleries and forms connected to respective lists. I am really sorry to bother you but is it possible for you to please duplicate your form and filter screen and add the duplicated screen another datasource to see if the edit icon works in that case? if Yes, is there any twig that needs to be done.
@@kanjyoklama4651 I will not be able to do that since Im working on other things now.
You must be getting some error message in App. I would recommend posting that error and screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani No, i am not getting any errors. Everything looks fine and works great expect the edit icon on 2nd screen onwards. I will use the forum for further support. Thanks again for your reponse and awesome vidoes.
@@kanjyoklama4651 Must be some issue somewhere. I did deploy this in a different tenant and it worked fine.
I am just curious to know, Ive we move an item from one status to another , Does it also gets updated in the list?? . Also in the requirement that i am working i need to add few more portlets below, I have used a scrollable page and added visuals but they seem to overlap, Can you help with this please
Yes, it does get updated in list.
You could use responsive containers to have scrolls that dont overlap.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, thank you for your help! How would I be able to track how long each item spent in each status?
Should be possible but this is not something I have tried and I do not have a video reference for. Idea would be to to calculate last modified time with current time whenever user initiates a status change.
Great Content Reza, actually that helped a lot, but the problem is I cant select items in my gallery to redirect it to an Edit Form, Any possible way to do that ?
Video description has link to download sample app. Give that a try.
If issue persists, I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Just curious if you do coding and whats your fav programming language
I come from a Java background then moved over to .NET.
C# I would say would be my favorite.
woudlnt it be easier to have the values look up to a table that has a column for ordering by, instead of manually adding the row number?
The table would need to have the order column values preset. If you can set that up, then use it.
Thanks Reza, Amazing content!!
Is it possible to implement drag and drop functionality instead of arrows to move across different statuses??
Drag and drop is not an inbuilt feature.
You may have to look at creating a PCF Control to implement that.
@@RezaDorrani We can create drag and drop using slider and based on its value we can patch the item with updated status, if we want to drag and drop almost anywhere in screen we can use timer auto turn on , repeat on, where duration is 0 seconds and change layout of slider horizontal and vertical based on timer and then we can achieve desired result , I have created it for my company.
@@Saif_Ali_Khan_1301 Have u built it where you can drag from one gallery to another?
@@RezaDorrani yes, I kept two galleries side by side, I know the x axis of both gallery, horizontal slider is made invisible and on the handle I bring a label or icon value passed by variable from left gallery selected item, user moves handle actually but only label or icon moves and cross a certain x axis value of second gallery and release the handle at that moment on change of slider default value ,I know that user has reached on top of second gallery and hence I immediately patch selected item value present in label from gallery 1 to 2
@@Saif_Ali_Khan_1301 You should share it with community. I think folks need something like that.
Rezza i am unable to get the datasource file when i'm imported that app. Let me know how to get that list
You cannot get the data source file as part of import in power apps.
My data source is a SharePoint list.
The problem with powerapp screens is you can’t create horizontal scrolling. With if you need like 8 tiles how do you scroll
I have done grid based videos where I have shown horizontal scrolling. You can check those.
HI. Will the sharepoint list also be updated when we move things in the App?
Yes
@@RezaDorrani thank you. Is there a way where the Status -Done or completed items just stay for a day and then be hidden or deleted?
@@vaishakr3403 Probably possible but not sure what that logic would be as I would have to try it out. I recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
How do we filter the Kanban board with dates?
ruclips.net/video/5dSk5iOgT68/видео.html
Does patching work with SQL tables?
Yes
@@RezaDorrani Thank you! Great video!
Hi Reza, coded this in my app, Is it possible to do responsive for an iphone?
Possible, but would require work
@@RezaDorrani Thanks for you reply, Is it worth it, or should I consider any way?
It is worth
@@RezaDorrani I was think of using 3 list in containers for each status, then do patch for one list to the other ?
@@jamescalvin2626 I have not tried with multiple lists
Reza Sir, OnStart option missing for App, how to embed code then
Every App has OnStart. Might be some bug on your end. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani posted a reply on similar issue and tagged you. Please revert
Thanks in advance :)
@@rahulshaw2979 I only go to forums in my free time. There are many other experts on the forums.
Reza, question. How do you assign a task to multiple persons? Thanks.
For that you would need a multi select person field.
@@RezaDorrani We tried the multi select field, but it will not save the selection(s) to the table. We are using Dataverse not SharePoint. Thanks.
@@RezaDorrani How much effort would it take on your part to do a follow-up video showing how to add multiple persons "Resources" to a task on the Kandan Board's? Please
@@georgegualda4262 I would not want to repeat the same topic with a different data source. I have plenty of other topics lined up.
@@georgegualda4262 You can store user emails semicolon separated in a column and work with that. I do not have a video reference on this though. I will recommend posting your query on the forums at powerusers.microsoft.com
Hello Mr. Reza, it's possible to create Kanban view on Model driven app ?
You can add a custom page to a model app.
With PCF component ? @@RezaDorrani
@@RezaDorrani With PCF component ?
@@jeanpascal553 May be. Ive not used pcf to build this though.
@@RezaDorrani Okay. I will try. Thanks a lot !
How can I create kanban board view for two column its just a show for progress board how can i create for priority board, anyone can help me in formula
I would have to try it out to provide the formula. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I don't have the words to comment on this.
Thanks for watching!
Hi Reza,
Great video. Question. How can I add an attachment to the kanban board? Is there a specific code? @rezadorrani
Attachments not supported in Patch function. But the form control dialog that opens (its in video demo), it can have attachments control.
I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you!
HI Reza, I tried to build the same kind of board using Dataverse connector and Using Optionset field.
ON App start :
ClearCollect(
WICOL,
Filter(
Choices('Work items (Accounts)'),
Text(Value) "Inprogress"
)
);
Clear(COLWISeq);
ForAll(
Sequence(CountRows(WICOL)),
Collect(
COLWISeq,
{
Value: Last(
FirstN(
WICOL,
ThisRecord.Value
)
).Value,
RowNo: Value
}
)
);
But Value is not showing for me. Instead of that, "This data type is unsupported for evaluation" displaying as value.
Displaying the data in Text field and in Cards is working. Value is not able to fetch When I use the formula for arrow icons. where I did the mistake?
RowNo_LBL = ThisItem.RowNo
For left and Right arrows functionality:
Patch(
Accounts,
ThisItem,
{'Work items': {Value:LookUp(COLWISeq,RowNo = Value(RowNo_LBL.Text)+1).Value}}
);
Can you help me on this please?
I recommend posting your issue with screenshots on forums at powerusers.microsoft.com
Thanks for the reply!
Posted a question on last Thursday with heading "This data type is unsupported for evaluation in powerapps while retrieving Option set value."
One guy responded, But not given any answer for the on this issue.
@@David-mw6ge Forums is a free platform where you may get a timely response. If urgent, then I would recommend getting consulting help
@David-mw6ge @@RezaDorrani Please let me know if you find a solution! Im struggling with same issue
@@user-qg7tp7xh1j I have no plans to investigate on this issue as I did not experience it. Im working on other video ideas. Forums will be your best bet.