cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fs92
Helper I
Helper I

How to use filter and search in PCF for React

Hi,

I want to use the filter and search function in my react app for a model driven powerapp with PCF.

The documentation describes not how to use it in javascript correctly. Has someone information about this?

Do I have to import some additional React components?

 

Here is a description of filtering but there is no example or full description on how to use it:

https://docs.microsoft.com/en-us/powerapps/developer/component-framework/reference/filtering

 

Best regards

1 ACCEPTED SOLUTION

Accepted Solutions

There really isn't any difference using this in React or not - the setFilter accepts a FilterExpression https://docs.microsoft.com/en-us/powerapps/developer/component-framework/reference/filterexpression

 

You can use as follows:

const expression = {
  name: "account",
  from: "accountid",
  to: "parentcustomerid",
  linkType: "inner",
  alias: "parentaccount ",
};

_context.parameters.sampleDataset.linking.addLinkedEntity(expression);
const condition = {
  attributeName: "accountid",
  conditionOperator: 79, // Equal or Under
  value: _context.page.entityId,
  entityAliasName: "parentaccount",
};
const conditionArray = [];
conditionArray.push(condition);
_context.parameters.sampleDataset.filtering.setFilter({
  conditions: conditionArray,
  filterOperator: 1, // Or
});
_context.parameters.sampleDataset.refresh();

Hope this helps

View solution in original post

3 REPLIES 3

There really isn't any difference using this in React or not - the setFilter accepts a FilterExpression https://docs.microsoft.com/en-us/powerapps/developer/component-framework/reference/filterexpression

 

You can use as follows:

const expression = {
  name: "account",
  from: "accountid",
  to: "parentcustomerid",
  linkType: "inner",
  alias: "parentaccount ",
};

_context.parameters.sampleDataset.linking.addLinkedEntity(expression);
const condition = {
  attributeName: "accountid",
  conditionOperator: 79, // Equal or Under
  value: _context.page.entityId,
  entityAliasName: "parentaccount",
};
const conditionArray = [];
conditionArray.push(condition);
_context.parameters.sampleDataset.filtering.setFilter({
  conditions: conditionArray,
  filterOperator: 1, // Or
});
_context.parameters.sampleDataset.refresh();

Hope this helps

Thanks for your reply.
Is there another documentation or guides on how to use filters and conditions? The documentation on the PCF site isn’t good currently

I believe that more documentation is in the works!

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,343)