Forum Discussion
Import Sharepoint Groups: UserId - GroupId
- 2 years ago
Hi everybody,
and thanks for the answer.
I want to share with you the solution that i find on a post.
- I create a function with a parameter that use the GET
let
Source = (Offset) =>
let
Source =
Xml.Tables(Web.Contents("https://MYWEB.sharepoint.com/sites/MYSITE/_api/web/SiteGroups/GetById(" & Number.ToText( Offset ) & ")/Users"
)
)
in
Source
in
Source
- then i call this function with insert a new column INVOKE CUSTOM FUNCTION and using a column of the same table (the id of the groups) as parameter of the function.
- then i arrange the data to obtain what i need: extract the users id from the results.
This post help me to resolve:
https://community.fabric.microsoft.com/t5/Community-Blog/Use-Column-as-Parameter-for-Custom-Function-in-Power-Query/ba-p/1495277
Thank you every body i put it as a solution.
See you next time!
Hi everybody,
and thanks for the answer.
I want to share with you the solution that i find on a post.
- I create a function with a parameter that use the GET
let
Source = (Offset) =>
let
Source =
Xml.Tables(Web.Contents("https://MYWEB.sharepoint.com/sites/MYSITE/_api/web/SiteGroups/GetById(" & Number.ToText( Offset ) & ")/Users"
)
)
in
Source
in
Source
- then i call this function with insert a new column INVOKE CUSTOM FUNCTION and using a column of the same table (the id of the groups) as parameter of the function.
- then i arrange the data to obtain what i need: extract the users id from the results.
This post help me to resolve:
https://community.fabric.microsoft.com/t5/Community-Blog/Use-Column-as-Parameter-for-Custom-Function-in-Power-Query/ba-p/1495277
Thank you every body i put it as a solution.
See you next time!