Send http request to make SharePoint event is not working and conditions not working

[Selom]

Hi all,

Update: even though I asked here, my hyperfocus was already on and I couldn't let go. I finally realised my dodo brain put 'EventEnd' instead of 'ENDDATE'!!!!!!! So please could you help me with my second question:

Another question I have is, I added a condition to check if the date columns are empty so that it would ignore that row if it was. it's just date is not equal to null (using expression) but it fails out each empty row. What I do wrong there?

My 2nd question is, can I feed in the banner URL via this too? (Update: I answered this by going to my original Create Item flow to get the JSON. I couldn't get the right word combo in Google to get the name, it's "BannerImageUrl", however, it doesn't do it, do I need to add anything else to help trigger it?)

Ok, I have a 3rd problem. The calendar item adds and then they disappear.

Thanks for any help.

I have read loads of articles and watched 1 video but for some reason (incompetence) I cannot wrap my head around my error.

I created a manual trigger to just read an Excel table and created the items fine. My only issue was that there was no 'All day' option.

I found the solution is to create the event via http request instead.

I thought I did it all, but each attempt to fix it produces a new error. I mixed single and double quotation so I moved to just single, I created a new calendar because I prefer it under 'Birthdays' but that wasn't being recognised so changed it back to Events.

 Error message: "status": 400,

  "message": "A type named 'SP.Data.EventsListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type. 

Moved from nometadata to verbose... changed obvious typos in between crying sessions...

What am I doing wrong?

{
'__metadata': { 'type': 'SP.Data.EventsListItem' },
'Title': '@{items('Apply_to_each')?['Name']}',
'fAllDayEvent': 'true',
'EventDate': '@{items('Apply_to_each')?['Birthday start']}',
'EventEnd': '@{items('Apply_to_each')?['End']}'
}

[eliotcole]

I have made calendar events recently, @Selom ... let me just see what I used there, as they appear to be working just fine. 👍

---

OK, I'm going to make a guess that your dates are not formatted correctly. So the list items actually do exist, but the dates you are inputting are not helping, perhaps.

That's just a guess, mind.

---

Either way, hopefully using my method might help you slip those events in there.

Firstly, I keep the site Events list ID in the 'eventsListIdVAR' string variable. This allows me to force the Create item action to do my bidding! 😈

Then I use the Create item SharePoint action with that variable as a Custom value in the List name field below the Chosen Site Address.

I have already built my JSON body in the 'createEventBodyObjVAR' object variable prior to this. It ends up looking something like this:

{
  "Category": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id": 0,
    "Value": "Meeting"
  },
  "Title": "EVENT_TITLE",
  "EventDate": @{variables('eventDateVAR')},
  "EndDate": "END_DATE"
}

Prior to building that I format my dates (for example the above "eventDateVAR" string variable) with the following function/expression:

formatDateTime(triggerOutputs()?['body/DueDate'], 'o')

That puts the date in the correct format to submit, I can add additional properties if needed later in the flow.

Hope that this helps!

---

Perhaps all you need to do is reformat your dates, though ... try changing the direct references to the dates with formatDateTime() functions wrapping around those values in place.

---

Also, and this is completely out there ... perhaps try it with double quote in place of your single quotes.

[Selom]

Hi Eliot,

Thanks for your message. I already figured out how to make them (that's the stricken out part).

My issues are:

• I can't get the bannerimage to trigger. I managed it once, didn't realise it worked and then changed it and now can't remember what I did to make it work.
• I am using conditions to skip empty rows but instead of accepted the criteria I made, it instead fails each empty row, so my whole thing "fails" but in reality every TRUE item is fine, but I don't want to have my flow as failed status. I'm not sure why it's failing because it's a simple binary option, not null TRUE or null FALSE.
• My 3rd problem isn't happening anymore.

[eliotcole]

OK, I was addressing the 3rd part.

I would suggest that you tackle each of your issues one by one. However if you take my approach you might resolve a few of them. Either way, good luck!

[Selom]

Oh I see, thank you. I could not identify where in the step it lets me have the 'All day' setting toggled on and have the photo in? From the error message and raw JSON, it seems to recognise the date fine.

I think for now I will just keep a table that only has values in it so that I don't need the conditions then.

Thanks again.