create new group for existing site

I am trying to replicate to add a group to an exsiting site in PowerShell. This is where I am so far:

$  credential = Get-AutomationPSCredential -Name 'spadmin'    Import-Module 'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.dll' $  adminurl = "https://me-admin.sharepoint.com" $  ctx = New-Object Microsoft.SharePoint.Client.ClientContext($  adminurl) $  spcredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($  credential.UserName, $  credential.Password) $  ctx.Credentials = $  credentials $  tenant = New-Object Microsoft.Online.SharePoint.TenantAdministration.Tenant($  ctx) $  tenant.CreateGroupForSite("https://me.sharepoint.com/sites/nogroup", "group name", "groupname", $  false) 

At this point I receive the following error:

Cannot find an overload for "CreateGroupForSite" and the argument count: "4". 

This is strange, because according to the documentation, the 5th parameter is optional. But, even if I try to create this, another error comes up:

$  params = New-Object Microsoft.Online.SharePoint.TenantManagement.GroupCreationParams  New-Object : A constructor was not found. Cannot find an appropriate constructor for type  Microsoft.Online.SharePoint.TenantManagement.GroupCreationParams. 

Can somebody please help?

How to get users email address from person or group field – using CSOM

I have a field called Employee and it’s a person and group field. How can i get the users email address if i have the display name or the user id. Any tip/help will be appreciated

See my snippet code below:-

<script type="text/javascript">    function StartersItems() {     var context = new SP.ClientContext.get_current();     var web = context.get_web();     var list = web.get_lists().getByTitle("Starters");     var camlQuery = new SP.CamlQuery();      var camlText = "<View><Query></Query></View>";      camlQuery.set_viewXml(camlText);     this.collListItem5 = list.getItems(camlQuery);      context.load(collListItem5);     context.executeQueryAsync(getNewStartersSuccess,getItemsFail); }  function getNewStartersSuccess(sender,args){     var listEnumerator = collListItem5.getEnumerator();      i = 1;     var newStarters = [];      var newStartershtml= "";      Startershtml+='<ul id="newStarterContainer">';       while (listEnumerator.moveNext()) {          var listItem = listEnumerator.get_current();          //Employee is a person and Group field         var employeeName = listItem.get_item("Employee").get_lookupValue();         var employeeID = listItem.get_item("Employee").get_lookupId();          //Can return these values no issue         //console.log(employeeName);         //console.log(employeeID);          //Need help with a function to return email address here or use any of the Ids above         FunctionToReturnEmailAddress(listItem.get_item("ID"));         } function getItemsFail(sender,args){    console.log('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace()); }  }      </script> 

How many people need to succeed in a group check with three people?

In the comments of this answer it came up that the section on “Group Checks” states:

To make a group ability check, everyone in the group makes the ability check. If at least half the group succeeds, the whole group succeeds. Otherwise, the group fails…

It came up what does “half the group” mean when there also exists a rule on “Round Down”:

There’s one more general rule you need to know at the outset. Whenever you divide a number in the game, round down if you end up with a fraction, even if the fraction is one-half or greater.

There are two possibilities brought up in those comments:

  1. At least 1.5 people must succeed, and since you can’t have half-people 2-3 people must succeed on the check.

  2. The 1.5 people required rounds down to 1 person, so 1-3 people must succeed on the check.

Which of these interpretations is correct?

Group results from two differenct tables on same hours

I have two simple tables:

indoor

id | timestamp | temp | humi 

outdoor

id | timestamp | temp 

and two selects which give me time and average temperature grouped by same hour for the last 24 hours:

SELECT DATE_FORMAT(timestamp, '%H:00') AS time, round(avg(temp), 1) as avg_out_temp FROM outdoor WHERE timestamp >= now() - INTERVAL 1 DAY GROUP BY DATE_FORMAT(timestamp, '%Y-%m-%d %H') ORDER BY timestamp ASC;  SELECT DATE_FORMAT(timestamp, '%H:00') AS time, round(avg(temp), 1) as avg_in_temp FROM indoor WHERE timestamp >= now() - INTERVAL 1 DAY GROUP BY DATE_FORMAT(timestamp, '%Y-%m-%d %H') ORDER BY timestamp ASC; 

and now what I need to do is to group those two results by same hour, with respect to possibility that there can be no records in indoor or outdoor table for whole hour, so I need to get:

time | avg_out_temp | avg_in_temp 11:00 | 12.5 | 21.4 12:00 | 13.9 | null 13:00 | null | 22.4 14:00 | 14.0 | 22.5 

Is it up to the DM or to the player to “fix” a tone problem in the group?

Playing in a friend’s campaign and the other PC is difficult to play against, to the point that it’s frustrating me both in and out of character.

The DM and I are playing a high-magic, god-touched struggle against good and evil where I’m having an amazing time living out my existential crisis, killing bad things and making life-altering decisions. The other PC however seems only vaguely attached to the plot, keeps making objectively terrible choices in game and pokes fun at my character every time she tries to open up and share anything. Basically, her character doesn’t take anything seriously and doesn’t seem concerned about the results of his actions.

Before I get into specifics, my question is is the tone problem something I should be fixing, or is it entirely on the DM to solve?


The Story

Our campaign’s kick-off was that we were both dealt a half-deck of a highly modified Deck of Many Things, and our quest is to undo all the damage that’s obviously caused. My character, Nasa, has multiple curses and stat penalties on her, her soul’s been stolen, she has ghouls out for her blood, etc. Comparatively, the other player’s character, Chirp, got 50k gold, a loyal companion, a couple of magic items and his only “problem” is that he has disadvantage against being charmed. It was 100% luck which cards we drew and clearly I got terribly unlucky!

Chirp is a happy-go-lucky guy who doesn’t seem particularly interested in fixing his disadvantage problem. Comparatively, Nasa is a pessimist and a worrier, especially since all this bad luck has befallen her. She’s determined to repent for her past mistakes and leave the world a better place, even if she has to die for it.

The Problem

Nasa is (admittedly) pretty gloomy, and especially so compared to Chirp. Between the soul stealing and being marked for ghoul undeath she’s accepted her fate as ever un-dead and is ready to martyr herself to help others. In trying to play her accurately it’s possible I’ve made her too unpleasant to be around. However, I really have trouble dealing with Chirp when he’s constantly mocking and belittling her.

Examples;

  1. Nasa believes she has magic (she doesn’t) and every time she “casts a spell” Chirp calls her on it, tells her she’s lying and tries to pressure her into confessing. He’ll make fun of her attempts and belittle her for not actually having magic even after she stops defending herself. We had discussed the whole “not actually magic” thing ahead of the campaign and everyone thought it was hilarious at the time and was super into the idea, but now I feel attacked for it.

  2. Nasa got paralyzed during battle and was left, helpless, with 3 HP since she’d been up close with the enemy tanking so the others could lay in hits. Chirp killed the enemy, but instead of making any attempt to help Nasa or even just protect her until the effects wore off he grabbed a handful of mud and drew a mustache on her face while she was frozen and nearly dead.

  3. I figured it might help humanize Nasa to spill a little bit of her backstory, but in the middle of a halting explanation of some of her history Chirp interrupted and basically laughed at what she perceived as a personal sacrifice and cracked a couple of jokes.

The Player

I’m really, really good friends with both the DM and the other player. We’ve played other campaigns together (usually with me DMing) and while the player always chooses to portray a playful, goofy character something about Chirp is really driving me up a wall.

We had a session 0 where we discussed what the campaign was going to be like, and we all agreed to a heavier storyline. But this last session actually made me kind of angry because I feel like she’s mocking my attempts at playing things more seriously.

I’ve mentioned my feelings briefly to both player and DM. The DM seemed concerned but hasn’t done anything yet to fix it, and the player was moderately sympathetic but basically said something that sounded a lot like My Guy Syndrome to me – essentially that Chirp was just a naturally cheerful guy and not to take it personally.

I’m wondering if I’ve messed up in making Nasa and if I should lighten her up and give Chirp a reason to stay and get involved. This is my first time being a player instead of a DM. Is this tone problem something I should take upon myself to solve, or is it generally on the DM to fix such things, or even am I just reading too much into this?

Use Flow to update/delete events on Online Sharepoint’s Group calendar

I am new to Flow and SharePoint online.

My online SharePoint site is based on a group which was created in Outlook. This SharePoint site has a group calendar. And there is a SharePoint list of events, the info here is used to populate the calendar. So when a new item is added to the list, a new calendar event is created. The event creation is handled by Flow’s ‘Office 365 Groups’ connector.

But the problem is, this connector does not have the ability to update or delete events if the corresponding items on the SharePoint list has been updated/deleted.

Is there a way to make this happen using Flow?