How to get members of groups from Excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2260357%22%20slang%3D%22en-US%22%3EHow%20to%20get%20members%20of%20groups%20from%20Excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2260357%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20added%20a%20group%20of%20external%20vendors%20to%20our%20Active%20Directory.%20Now%20I%20want%20to%20create%20a%20group%20for%20them%20in%20our%20Microsoft%20365%20so%20that%20it%20will%20be%20easier%20for%20us%20to%20share%20power%20bi%20report%20with%20every%20vendors%20within%20that%20group.%20However%2C%20the%20problem%20is%20that%2C%20the%20group%20is%20not%20static.%20That%20is%2C%20some%20vendors%20might%20be%20included%20this%20year%2C%20some%20not.%20The%20members%20of%20the%20group%20could%20be%20dynamic.%20We%20decide%20which%20vendors%20we%20share%20the%20report%20with%20for%20the%20year.%20As%20a%20result%2C%20we%20have%20to%20go%20back%20to%20Office%20365%20and%20modify%20the%20group%20members%20manually%2C%20which%20is%20daunting.%20Could%20anyone%20please%20help%20me%20if%20there%20is%20a%20way%20to%20store%20the%20member%20of%20the%20group%20in%20excel%20file%20and%20connect%20to%20Microsoft%20365%20then%20we%20only%20have%20to%20update%20the%20excel%20file%20then%20the%20change%20will%20be%20reflected%20back%20in%20Office%20365.%20Could%20anyone%20tell%20me%20if%20there%20is%20a%20good%20workaround%20for%20this%20problem%20or%20experienced%20similar%20issue%20and%20came%20up%20with%20feasible%20solution%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2260357%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

I have added a group of external vendors to our Active Directory. Now I want to create a group for them in our Microsoft 365 so that it will be easier for us to share power bi report with every vendors within that group. However, the problem is that, the group is not static. That is, some vendors might be included this year, some may not. The members of the group could be dynamic. We decide which vendors we share the report with for the year at the beginning of every year. As a result, we have to go back to Office 365 and modify the group members manually, which is daunting. Could anyone please help me if there is a way to store the member of the group in excel file and connect to Microsoft 365 then we only have to update the excel file then the change will be reflected back in Office 365. Could anyone tell me if there is a good workaround for this problem or experienced similar issue and came up with feasible solution? 

1 Reply

Hello @Suraf,

One of the options would be to use dynamic Office365 group. In Azure Active Directory (Azure AD), you can use rules to determine group membership based on user properties. 

Reference

Hope that helps.