
Announcements
I built a flow that runs a dataverse list rows action when a button in Power BI is clicked. The flow is built inside the actual power bi desktop report as a visual, but the flow designer is essentially the same.
List rows action works when my filter query is only 1 item, ex: "contains(fieldname,'example')
but if i try to add 2 items (Which works normally, 2 is the max for odata filters) it does not work
I've tried multiple different syntaxes, i can't find any info on this error.
Error:
No function signature for the function with name 'contains' matches the specified arguments. The function signatures considered are: contains(Edm.String Nullable=true, Edm.String Nullable=true).
Figured it out, i was looking for ownerid with ownerid eq 'guid'
for some reason that doesnt work in the power bi flow visuals, i had to use the value version of that field so _ownerid_value eq 'guid' and it worked.
ownerid just gave me the actual user name, _ownerid_value gives the guid for lookup.