Filter SQL Odata query with username

[eka]

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 Username in power automate. I tried this but is not working; LocalUser eq User().Fullname

[manuelstgomes]

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.

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

[eka]

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

[manuelstgomes · Accepted solution]

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

[eka24]

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