Hi Anirudha. Great video. Thanks for sharing this. Could you kindly explain how we can go for a third level? I am unable to reuse the term with another term that is already reused.
Hello Aniruddha, I am working on cascading meta data, i followed your video but i only get first two options and sub only few options not all sometimes its blank can you help
Great video. I'm not sure I understand the managed metadata, reuse term. I'm doing it within the Admin portal and I get an message when I select reuse on Model to my Brand. It works fine for the first, but when I do a second one it says...."Terms can not be shared multiple times in the same term set". What am I doing wrong?
Hi Kim, thanks that you like it. Here is my repository where both the .msapp file and .zip file available. You need to create the SharePoint list looking at my video. github.com/Antibiswas/myapps If you need more help please share few screenshot at aniruddhab@outlook.com
@@AniruddhaBiswasChannel Thank you for responding :) I downloaded the zip file and got it working. I just had a little issue with creating the Term Store and using the "Reuse Term", but instead I did "Pin term to Child" and that is working. Thanks again for you video, it is a big help.
Thanks for the demo and video.... There is a HUGE limitation in SharePoint with Choice fields and managed metadata when using Filter. You can only return the first 20 items. Do you have a way of working around this?
Hi Alan, I agree about the limit is 20 for choice column and managed metadata column but I am not agree that there is any problem because of that in Power Apps. I can tell you that I worked in few apps in the past where 16k+ Project information was there in Managed metadata column. There is no problem to retrive or filter. In the New form or edit form you can placed those columns, there is a option for dropdown "Allow Searching" you need to enable. Then your need to provide what they want based on that first 20 suggestion will appear. Google work in same way, for one keyword there is billion result but it shows page by page because no one can handle all the resut in single page and the performance will not be optimise. Please let me know your scanrio then it will be more helpful to understand the problem.
@@gantulgatulgaa6344 When you're in the edit-mode in Power Automate, select the dropdown field (MMD Field) directly and check the properties. The toggle you're looking for should be somewhere near the bottom. In my case, level 1 has 3 options, level 2 has 20, level 3 800, level 4 +500, and level 5 +3000 entries. So even if i were to suggest options for level 1 and two, level 3 with its +800 items would not be able to display more than 20 😕
Hi Aniruddha, thank you for this brilliant bit of functionality. I am applying it in a power app custom form linked to a SharePoint list and it works perfectly apart from the form does not show the selected model. I've tried default values as thisitem."field" and parent.default but it continues to be blank in the form whilst present in the SharePoint list. Any help would be much appreciated.
Hi Mark, thanks that you like it. Here is my repository where both the .msapp file and .zip file available. You need to create the SharePoint list looking at my video. github.com/Antibiswas/myapps
Hi @@AniruddhaBiswasChannel , thank you again for your time. I have followed the video using your app and find myself with the same problem, all the functions work perfectly other than the form does not display the model when you view or edit it in the SharePoint List. The main difference I see between your app and mine appears to be that I see SharePoint integration and Form Screen in Power Apps Screens instead of the Browse, Detail and Edit in your video. If you can help it would much appreciate but completely understand if I am asking too much. Thanks again Mark.
@@markburrage8973 After following the steps as shown in the video, I had the same result as you. However, once I changed the Model SharePoint Column to point to the Brand Term, I was able to see filtered results in the Power App. That said, I am now working with a Term Set that is 3 layers deep, and my filter only works properly for layers 1 and 3. Layer 2 (correctly per the filter) shows items from Layer 2 AND Layer 3 as they all have the Layer 1 selection "in Path". Hopefully this will help someone who watches this video and runs into the same issue.
That is bloody brilliant.
Hi Anirudha.
Great video. Thanks for sharing this. Could you kindly explain how we can go for a third level? I am unable to reuse the term with another term that is already reused.
Thanks for sharing, very useful.
Hello Aniruddha, I am working on cascading meta data, i followed your video but i only get first two options and sub only few options not all sometimes its blank can you help
Great video. I'm not sure I understand the managed metadata, reuse term. I'm doing it within the Admin portal and I get an message when I select reuse on Model to my Brand. It works fine for the first, but when I do a second one it says...."Terms can not be shared multiple times in the same term set". What am I doing wrong?
Hi Kim, thanks that you like it. Here is my repository where both the .msapp file and .zip file available. You need to create the SharePoint list looking at my video. github.com/Antibiswas/myapps
If you need more help please share few screenshot at aniruddhab@outlook.com
@@AniruddhaBiswasChannel Thank you for responding :) I downloaded the zip file and got it working. I just had a little issue with creating the Term Store and using the "Reuse Term", but instead I did "Pin term to Child" and that is working. Thanks again for you video, it is a big help.
My first dropdown is only 5 items, which I see them in my Term Store, but when I filter the dropdown only 3 show up. Why is that?
Thanks for the demo and video.... There is a HUGE limitation in SharePoint with Choice fields and managed metadata when using Filter. You can only return the first 20 items. Do you have a way of working around this?
Hi Alan, I agree about the limit is 20 for choice column and managed metadata column but I am not agree that there is any problem because of that in Power Apps. I can tell you that I worked in few apps in the past where 16k+ Project information was there in Managed metadata column. There is no problem to retrive or filter. In the New form or edit form you can placed those columns, there is a option for dropdown "Allow Searching" you need to enable. Then your need to provide what they want based on that first 20 suggestion will appear. Google work in same way, for one keyword there is billion result but it shows page by page because no one can handle all the resut in single page and the performance will not be optimise.
Please let me know your scanrio then it will be more helpful to understand the problem.
@@AniruddhaBiswasChannel Great video. i can't enable option for dropdown "Allow Searching". where is it
@@gantulgatulgaa6344 When you're in the edit-mode in Power Automate, select the dropdown field (MMD Field) directly and check the properties. The toggle you're looking for should be somewhere near the bottom.
In my case, level 1 has 3 options, level 2 has 20, level 3 800, level 4 +500, and level 5 +3000 entries. So even if i were to suggest options for level 1 and two, level 3 with its +800 items would not be able to display more than 20 😕
Hi Aniruddha, thank you for this brilliant bit of functionality. I am applying it in a power app custom form linked to a SharePoint list and it works perfectly apart from the form does not show the selected model. I've tried default values as thisitem."field" and parent.default but it continues to be blank in the form whilst present in the SharePoint list. Any help would be much appreciated.
Hi Mark, thanks that you like it. Here is my repository where both the .msapp file and .zip file available. You need to create the SharePoint list looking at my video. github.com/Antibiswas/myapps
Hi @@AniruddhaBiswasChannel , thank you again for your time. I have followed the video using your app and find myself with the same problem, all the functions work perfectly other than the form does not display the model when you view or edit it in the SharePoint List. The main difference I see between your app and mine appears to be that I see SharePoint integration and Form Screen in Power Apps Screens instead of the Browse, Detail and Edit in your video. If you can help it would much appreciate but completely understand if I am asking too much. Thanks again Mark.
Sorry Mark, I have missed your comments. If you have not solved already thne please share some screenshots at: aniruddhab@outlook.com
@@markburrage8973 After following the steps as shown in the video, I had the same result as you. However, once I changed the Model SharePoint Column to point to the Brand Term, I was able to see filtered results in the Power App.
That said, I am now working with a Term Set that is 3 layers deep, and my filter only works properly for layers 1 and 3. Layer 2 (correctly per the filter) shows items from Layer 2 AND Layer 3 as they all have the Layer 1 selection "in Path".
Hopefully this will help someone who watches this video and runs into the same issue.
It was a very useful video, helped a lot. Only issue I faced is my drop down onchange is triggered while form loading itself, how to tackle that ? TIA
thanks
Many thanks Sundra!