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
Solved! Go to 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
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
I get an error. what field do I select on the get profile?. I left it blank an it did not work
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
User | Count |
---|---|
16 | |
16 | |
14 | |
9 | |
8 |
User | Count |
---|---|
29 | |
28 | |
24 | |
23 | |
13 |