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

Error filtering query for SystemUser D365 Finance

I'm trying to fetch data using SystemUsers entity in D365 Finance and using values saved in an array to filter results. See screenshot below. 

Each time I run the flow, I run into this error. However if I give string value explicitly to the filter, data is retrieved without an issue. What am I missing? Suggestions please. Thanks

 

An error has occurred. Could not find a property named 'xxx' on type 'Microsoft.Dynamics.DataEntities.SystemUser'.

User.jpg

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
raoraheel
Helper I
Helper I

Got it working by putting item() in single quotes.

 

Screen Shot 2021-01-22 at 11.57.59 PM.png

View solution in original post

1 REPLY 1
raoraheel
Helper I
Helper I

Got it working by putting item() in single quotes.

 

Screen Shot 2021-01-22 at 11.57.59 PM.png

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT 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.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

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 (2,028)