Answered

Using Power Automate to generate SharePoint Communication Site Events in the Site’s Event List - Missing WorkspaceURL

(0) Share

Report

Posted on by nhaynes

In my organization, we have Power Automate flows that work from a List trigger. When “Publish to Calendar” is selected on the List, then a flow creates a calendar event on a SharePoint communication site. This impacts two different sites within our intranet.

Starting on 1/25/24, the flow errored out. Through investigating, it seems the WorkspaceURL, which was previously working fine, is no longer part of the schema.

Questions

This issue just started happening, and I can’t find any resources about this issue. Any ideas as to what’s happening with WorkspaceURL in the object schema of events?
How can I continue to automate SharePoint calendar events through Power Automate?
Where in SharePoint are Event lists items storing the Link (available when creating an event manually in SharePoint)

Additional Details

The issue we have is why is this no longer part of the schema? This abruptly changed, and in looking at the JSON outputs of the Events lists on these sites, there is no WorkspaceURL or any hyperlink (even though these exist somewhere in SharePoint). I can still create an event manually on a SharePoint communication site and add a registration hyperlink, but where that “lives” now I have no idea. Previously, we could access that WorkSpaceURL in Power Automate; now, it doesn’t exist in the schema, in the JSON outputs, in Event list views, and nowhere that I can find. But it has to exist somewhere in SharePoint because we have live events with registration hyperlinks.

In Power Automate, I get this error: 'item/Workspace' is no longer present in the operation schema. It should be removed before the workflow is re-saved.

This was always a challenging flow—the Events list doesn’t show up under lists, and to make this Create Item action work, I had to manually paste in the Event List ID (vs finding it in the dropdown of Create Items). Why Microsoft doesn’t allow easy automated creation of SharePoint events is beyond me, but this has worked successfully for about 9 months.

Even more odd, there is a switch in this flow, and depending on the event type, there are possibly 6 naming conventions tacked on to the webinar title, and then it’s published to 1 of 2 sites. You can see the flow on the right in the screenshot shows a different layout, still identifies WorkspaceURL as an option (where the flows attached to the other site on the left flow in the screenshot now display item/workspace, indicating this is no longer available). Both sites yield the same back end results—I cannot trackdown the WorkspaceURL in the JSON outputs, views, etc.

Categories:

Using flows

Blurred PA Flow.png

I have the same question (0)

All responses (7)

Answers (2)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@nhaynes you can try using Rest API via Send HTTP Request to SharePoint to create item in Calendar list in SharePoint

Was this reply helpful? Yes No
nhaynes 13 on at

Like (0)

Report

Thanks @annajhaveri , have you recently tested this? I tried to use an HTTP request to SharePoint and get the following error: The property 'WorkspaceUrl' does not exist on type 'SP.Data.EventsListItem'. This is further verifying what I'm seeing in the JSON - no mention of the WorkspaceURL, but this link has to exist somewhere, and appears to have changed locations on the back-end of SharePoint.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@nhaynes please try using name Workspace instead of WorkspaceUrl

Was this reply helpful? Yes No
nhaynes 13 on at

Like (0)

Report

@annajhaveri I have successfully created SharePoint events in a test environment, but with two exceptions. Anytime I add the BannerURL or Workspace URL to the JSON, I get this error:
An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected.

In the first screenshot (Workspace), you can see where I authorize this request, and but the HTTP request to SharePoint throws that error when I run the flow. In the second screenshot (Success), you can see the successful HTTP request to SharePoint to create this calendar event, but I am not able to include Workspace or BannerURL in the JSON of the HTTP request.

It's worth noting that I get an object not found error on WorkspaceURL. Workspace seems to be found, but causes this error when trying to add WorkspaceURL to the JSON of the HTTP request.

Success.png

Workspace.png

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
@nhaynes Workspace is a hyperlink type of field so try providing its value as follows in the json

"Workspace": { "Description": "<Title of the link>", "Url": "<actual link>" }

Was this reply helpful? Yes No
Verified answer

nhaynes 13 on at

Like (0)

Report

That did it @annajhaveri! Thank you. I have one more issue that is preventing me from returning this flow back to its normal functionality. I cannot get the Banner URL to populate in the HTTP request (Primitive Node Error).

However, I am able to use an update items action after the HTTP request to populate the event image. This will work for now since I can't get that to work in the HTTP request. Thanks again!

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@nhaynes Please share the Banner Url json for me to check whats wrong with that. Also if my response helped you to get to solution, i would appreciate if you could mark it as answer so other people with similar issue can see the solution.

Was this reply helpful? Yes No