Feedback RE: Power CAT Security Management App

[geoff-lennon]

Hi Power CAT Team,

First time commenting, so apologies if this isn't the best avenue for sharing an idea RE: the Dataverse Security Management App.

Not an issue per se, more of a question / idea.

From the User Profile Page, would be great if there was a + button to add security roles directly from that screen. Also, would be helpful if the business unit of the security role was shown in the security role section...

We're currently testing Modern Business Units, and the user in the above image has a role from two Business Units, so it would be helpful to see that in the app + it would be a great feature to be able to assign security roles from one / multiple business units from this terrific UI that you've created.

Happy to provide any further context, etc.

Appreciate you sharing this great app with the community!

Thanks,

Geoff

[Ravi-Chada]

@geoff-lennon - Thank you for the feedback and sorry for the delay in responding. Adding BU information is on my backlog. I will let you know once I release the new version with this.

[geoff-lennon]

Hi Ravi,

Inspired by your app, I did a bit of work myself and have created a rough draft where I can see / assign BU-specific security roles for users, so that's working nicely.

The main challenge now is assigning multiple roles on select of my "assign" button. It's currently using a relate function with the "is selected" value from the gallery, but unfortunately, that's a single value. So while I've added checkbox controls to my gallery to make it seem that it's a multi-select, it doesn't work as such. Upon review, galleries don't support multi-select at the moment, so I'm looking into alternatives (e.g., saving selected roles to a collection, but the collection of selected roles then doesn't seem to work with the relate function inside a forall function, etc.).

Have a few more ideas to try (e.g., trigger a flow, etc.), but was hoping to manage all with PowerFX in the canvas app, if possible.

Would of course welcome any ideas you might have concerning how to multi-select from a gallery / relate.

Thanks!

Geoff

---

[Ravi-Chada]

Hi Ravi,

Inspired by your app, I did a bit of work myself and have created a rough draft where I can see / assign BU-specific security roles for users, so that's working nicely.

The main challenge now is assigning multiple roles on select of my "assign" button. It's currently using a relate function with the "is selected" value from the gallery, but unfortunately, that's a single value. So while I've added checkbox controls to my gallery to make it seem that it's a multi-select, it doesn't work as such. Upon review, galleries don't support multi-select at the moment, so I'm looking into alternatives (e.g., saving selected roles to a collection, but the collection of selected roles then doesn't seem to work with the relate function inside a forall function, etc.).

Have a few more ideas to try (e.g., trigger a flow, etc.), but was hoping to manage all with PowerFX in the canvas app, if possible.

Would of course welcome any ideas you might have concerning how to multi-select from a gallery / relate.

Thanks!

Geoff

Acting on multiple selected gallery items is through a collection and using forall function. You got that all correct. Paste your formula if you can

[geoff-lennon]

Thanks Ravi. Working with my more technically inclined colleague, think we've got it working now!

With the below function onselect of our "add roles" button, we're now able to assign in bulk.

ForAll(Filter(CollectionofRoles,Selected), LookUp(CollectionofRoles,Selected); Relate(Gallery1.Selected.'Security Roles (systemuserroles_association)',ThisRecord) );

Appreciate your responsiveness / willingness to help : )