Power Platform Community Forum Thread Details

Hello,
I am working on a way to list the hardware for each desk.

For this, I have created two tables:
→ Hardware
→ Desk

Hardware has a lookup to Desk (many-to-one relationship).

On the Desk table, I have created a modified subgrid (Picture 1).
In this subgrid, I have a button → Add Hardware (Picture 2).
This button gives me a list of all my hardware, and I can choose what to add (Picture 3).

I would like to know if there is a way to hide hardware that is already assigned to a desk.
Is this possible using parameters, JavaScript, or something else?

Thank you for your answer.
Bastian

Categories:

Building Power Apps

Hey there indeed that'll be great to have a custom filter you'll have to work with the back and bone of the entity download that solution export the XML and manually edit it to set a custom JavaScript... You can break something in the process...

another approach and is what I suggest its following

Create a JavaScript Web Resource e.g.
Create a custom Command and Hide the existing Subgrid + Add Existing Button e.g + Add Custom Hardware
Create a Custom Page (Like a Canvas app but Lighter)
always publish your work

NOTE 1: Edit your App Site map and include your created Custom Page if not, it won't work

NOTE 2: in Step #3 you need to include the JavaScript created in Step #1 as the command

NOTE 3: Canvas app needs the logic to filter only that hardware is Null/blank in Desk lookup, do the link between entities, and make it pretty

Indeed, lots of steps but it makes the trick would be nice if it'd be OOB feature

I only include JS Code

function openCustomPageBlade(primaryControl) {
    var pageInput = {
        pageType: "custom",
        name: "your_custom_page_name", // Replace with your Custom Page name (logical name)
    };

    var navigationOptions = {
        target: 2, // Opens in a dialog
        position: 2, // Right side (blade)
        width: {
            value: 400,
            unit: "px"
        },
        title: "Custom Page Blade"
    };

    Xrm.Navigation.navigateTo(pageInput, navigationOptions).then(
        function success(result) {
            console.log("Custom page opened successfully.");
        },
        function error(error) {
            console.error("Error opening custom page: ", error.message);
        }
    );
}

result