Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Filter results from SharePoint query in advanced editor

I hav a query collecting records from sharepoint lists. This gives me a lot of results. Now I need to filter the records on the current user. One field returning from Sharepoint is "SP_username".   ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous RLS is going to be a "Pro" level feature, which would require all users to have a Pro license.

     

    Based on what you are saying, I really think it is what you are asking to do. Give a look in those links, and if it works out or not comment back so we can explore further or close out the thread for others.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I figured it out.

 

#"FilteredTable" = Table.SelectRows(#"Removed Columns", each [HourList.Name] = "j.doe")

 

I have to make this more dynamic but that will not be a big problem.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

However ;-(

When I try to do it in some dynamic way, I try this:

 

 #"FilteredTable" = Table.SelectRows(#"Removed Columns", each [HourList.Name] = (Text.End(USERNAME(), (Text.Length(USERNAME() - Text.PositionOf("\",USERNAME())))

 

This is not working. I'm not sure but I think te USERNAME() function does not work in power query...

 

Any suggesions would be very welcome