Power Query - Add a column with current permission login user email

%3CLINGO-SUB%20id%3D%22lingo-sub-2000773%22%20slang%3D%22en-US%22%3EPower%20Query%20-%20Add%20a%20column%20with%20current%20permission%20login%20user%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2000773%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20putting%20data%20from%20Sharepoint%20workspace%20and%20using%20Power%20Query%20as%20ETL%20tool%2C%20and%20data%20of%20a%20query%20will%20be%20written%20into%20database%20using%20VB.%26nbsp%3B%20I%20want%20to%20add%20a%20column%20of%20the%20current%20permission%20login%20user%20email%20from%20Data%20source%20settings%20into%20the%20query%2C%20therefore%2C%20after%20written%20into%20database%2C%20I%20know%20each%20row%20is%20created%20or%20modified%20by%20whom.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20of%20doing%20so%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EDavid%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2000773%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello everyone,

 

I am putting data from Sharepoint workspace and using Power Query as ETL tool, and data of a query will be written into database using VB.  I want to add a column of the current permission login user email from Data source settings into the query, therefore, after written into database, I know each row is created or modified by whom.

 

Is there a way of doing so?

 

Thank you so much!

 

Best regards,

David

0 Replies