Answered

PCF control on subgrid

(0) Share

Report

Posted on by Sharath123

I've created a PCF control on subgrid, we're using office ui fabric react and react nuget packages. We're trying to filter the subgrid using below code. but the subgrid displays all record and filter is not applying on subgrid.

enum condOperators {
Equal,
}
var condition = {
attributeName: "msdyn_account",
conditionOperator: condOperators.Equal,
value: "{3c11d08a-4751-ea11-a813-000d3a7f1cdc}",
entityAliasName: "msdyn_payment"
};

context.parameters.sampleDataSet.filtering.setFilter({
conditions: [condition],
filterOperator: 0
});
context.parameters.sampleDataSet.refresh();

All responses (2)

Answers (1)

Sharath123 7 on at

Like (0)

Report

Re: PCF control on subgrid

Thanks for the response, there is a heirarchy on account Entity, I'm trying to achieve above or equal in the query for account, but this doesn't yield me any results, below is the code that i'm using. Could you please help me on this.

context.parameters.sampleDataSet.filtering.setFilter({
            conditions: [{
                attributeName: "msdyn_account",
                conditionOperator: 78, // Above or equal
                value: context.page.entityId // Remove '{' and '}' symbol which wrapped the GUID value
            }],
            filterOperator: 0,
        });
Verified answer

v-xida-msft on at

Like (1)

Report
Re: PCF control on subgrid

Hi @sharaths463 ,

Based on the formula that you mentioned, I think there is something wrong with it. I have made a test on my side, and the Filtering formula works well.

The screenshot of my TypeScript code as below:

On your side, you should modify your formula as below:

var condition = { attributeName: "msdyn_account", conditionOperator: 0, // Specify 0 here rather than Enum value you defined here value: "3c11d08a-4751-ea11-a813-000d3a7f1cdc", // Remove '{' and '}' symbol which wrapped the GUID value entityAliasName: "msdyn_payment" }; var conditionArray = []; conditionArray.push(condition); context.parameters.sampleDataSet.filtering.setFilter({ conditions: conditionArray , filterOperator: 0 }); context.parameters.sampleDataSet.refresh();

More details about supported values for conditionOperator in PowerApps Component Framework, please refer to following article:

https://docs.microsoft.com/en-us/powerapps/developer/component-framework/reference/conditionexpression#conditionoperator

Please also check and see if the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/How-to-use-filter-and-search-in-PCF-for-React/td-p/388748

Best regards,