Answered

Filter SQL Odata query with username

(0) Share

Report

Posted on by 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 Filter Odata with Username.JPG in power automate. I tried this but is not working; LocalUser eq User().Fullname

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

manuelstgomes 6,625 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
eka 56 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

manuelstgomes 6,625 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No