Answered

Dataverse connection ‘List rows’ - filter ‘Solutions’ table by publisher

(0) Share

Report

Posted on by Blurryface

149

I am running into an issue where the OData filter query for the Dataverse connector ‘List rows’ on the ‘Solutions’ table will not accept the following when trying to filter it by a publisher:

_publisherid_value eq ‘xxx’

it returns a binary error. Any help would be really appreciated

All responses (2)

Answers (1)

Blurryface 149 on at

Like (0)

Report

Re: Dataverse connection ‘List rows’ - filter ‘Solutions’ table by publisher

@DAllen365 @Thanks for responding so quickly, upon comparison of my filter versus yours I noticed my GUID was a bit shorter. Turns out I partially missed some of the start of the GUID on copy hence the error was actually related to the GUID rather than the column I was filtering. Thanks for your support, issue resolved!
Verified answer

DAllen365 446 on at

Like (1)

Report

Re: Dataverse connection ‘List rows’ - filter ‘Solutions’ table by publisher

@Blurryface I have run a quick test using the List Rows dataverse action connected to the Solutions table. I added the following query on the filter and it ran fine:
_publisherid_value eq '6e77232b-9eff-4ad7-a9c3-ea04353db501'

It also ran fine if I left off the single quotes:
_publisherid_value eq 6e77232b-9eff-4ad7-a9c3-ea04353db501

I then put this expression in a compose to count the number of returned rows:
length(outputs('List_rows')?['body/value'])

Please post screenshots of your flow so we can better diagnose what might be going on.

----------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.