cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eka
Helper II
Helper II

Filter SQL Odata query with username

Please I am trying to filter the based on the username of the person. There is a column “LocalUser” in the SQL table where usernames have been store. Now how do you filter where  Localuser equals UsernameFilter Odata with Username.JPG in power automate. I tried this but is not working; LocalUser eq User().Fullname

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @eka 

 

What's the error you get?

 

Should work just like that. 

 

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

Cheers
Manuel

View solution in original post

4 REPLIES 4
manuelstgomes
Community Champion
Community Champion

Hi @eka 

 

We need to get the user first. Below you have an example in SharePoint (I don't have a SQL database set up to be able to show you) but the expression is exactly the same for your case.

 

small-Screenshot_2019-12-19_at_10_00_31.jpg

 

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

Cheers
Manuel

I get an error. what field do I select on the get profile?. I left it blank an it did not work

Capture5.JPG

Hi @eka 

 

What's the error you get?

 

Should work just like that. 

 

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

Cheers
Manuel

Thanks, it run after I put the display name in single quotes

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,690)