cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
golfnutt82
Post Patron
Post Patron

Pulling a field data using Odata Filter Query

Hello,
I am trying to pull a single related field data from another list.
The key data I want from List one is circled
I will then populate the User Role Access field with the data

The Odata Filter Query isnt working for me as I would expect so I am guessing my query syntax is incorrect.
Any help is always appreciated.

List 1 = Access Requests

golfnutt82_0-1634927793047.png

List 2 = Roles

golfnutt82_0-1634930892779.png

 

 



4 REPLIES 4
Mira_Ghaly
Dual Super User II
Dual Super User II

@golfnutt82

Please check the below topic for a similar issue:

https://powerusers.microsoft.com/t5/Building-Flows/ODATA-Filter-queries-on-LookUp-columns-from-a-SP-...

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hello,
Thank you for the link but for some reason I am not able to make this work for me.
I would think something like this would be simple.
Connecting two key fields in order to extract particular data related to the Key ID field.

I ran the workflow and can see what I need but I receive an error when I attempt to use the Odata filter query.

golfnutt82_0-1635169348101.png

 

@golfnutt82 

I figured out how it works

Use the below in your OData filter:

 

LU_RoleName_x003A_Asscoiated_x000/Value eq '3728'

or

LU_RoleName_x003A_Asscoiated_x000/Id eq 101

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Thanks, I will give this a shot and let you know.

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,873)