Filter by Plumsail lookup in PnPJS

Forms SharePoint Online
1

I am using a Plumsail lookup for a cross-site lookup. The column in the child is plain text and if I query all items in PnP I can see the value returned as

Supplier: "{\"id\":1,\"text\":\"Test Supplier\"}"

I need to be able to use pnp to filter the list items by Supplier, either ID or text.

I’ve tried using various methods as I would for a normal SharePoint lookup, using expand and select for example but anywhere I put Supplier/id or Supplier/text gives me either a query error (in filter) or a The field or property 'Supplier' does not exist error (in expand or select).

Thanks

2

Hello @MadeNorth,

The Plumsail Lookup control stores the value as a plain text, so the approach must be as for a string when filtering results.

Why do you need to filter with PnP? What should be the outcome? I need to understand your use case to suggest the approach.

Please also share the code you are currently using.

3

Hi @Margo

What I would like to do is show forms from two separate lists as though they are one. I have two lists of supplier information, one is generic for the business the other is private data that only Admin people can see. Supplier data has a 1:1 relationship across both lists and there is a Plumsail lookup from the private to the public list.

The goal is to allow the admin staff to be able to edit both sets of list data on the same form if possible. If not, I was going to have a button from one form that would open the other form in a Dialog. Hence the question above.

I have gotten around it for now by putting the button on the private list as I can get the ID of the related list item from the Plumsail form and get it by it’s ID.

Does that make sense?

Thanks

4

@MadeNorth,

How do you display the second list on the form? Are you using List or Library control?
Can you share the screenshot of the form for better understanding.