cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Is this possible in Flow?

We currently have a 2007 SharePoint site that is using three Nintex workflows to create individual sub sites based around a specific trial project we’re conducting at our work location.  Each project sub site has a set template, generated from a pre defined site template (full of files and document templates) and an individually generated ID number.  For example, a document library with an expense spreadsheet, trial result spreadsheets etc.

 

We are hoping to move the site to the Office 365 platform without the use of the Nintex workflows and subsites.  For the updated new site, we still want individual ID numbers created with a set template, but we do not want it to create a new site for every new project.   That part is easy enough, with a new list and a form with the relevant fields on it via a sharepoint list (unless somebody suggests something different).

 

As part of each trial, or document created, we will also have some date fields that will be entered.  One of these will be a start date, but can be entered or updated after the document is created.  Once the start date is entered, we’d like to create some calendar items based on some calculations from the date.  This may take the form of some kind of button or something that can be triggered manually to create these sub items (most likely in a calendar list or something similiar).

 

What tools, of combination of tools, could be used to achieve this?  Is it best suited to flow or something different in the Office 365 suite.

Any help or suggestions would be much appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Is this possible in Flow?

Hi @julesp ,

 

Do you want to create an item on SharePoint Calendar list when a list is modified, especially when the Date in the list is updated?

 

Before starting the flow, I created a list with a Title field, and Date column for start date.

 

Then set up the flow which is triggered by When an item is created or modified, adding a condition to check if the Date field has value, if yes, create an item on SharePoint Calendar list.

 

The function used in the Condition is:

 

not(empty(triggerBody()?['Date']))

is equal to

True

 

 

About the End Time, it will be 7 days after the start date:

addDays(triggerBody()?['Date'],7,'yyyy-MM-dd')

 

Image for your reference:

1.PNG

 

Please take a try with it on your side.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Is this possible in Flow?

Hi @julesp ,

 

Do you want to move sites from SharePoint 2017 to Office 365?

Please consider using the SharePoint action Send an HTTP request to SharePoint, which could be used to execute any SharePoint Rest API you have access to.

Please check the following doc for a reference:

https://docs.microsoft.com/en-us/connectors/sharepointonline/

There is a blog on how to create a new sub site using Microsoft Flow for your reference:

https://www.sharepointeurope.com/microsoft-flow-create-new-sub-site-using-microsoft-flow/

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Is this possible in Flow?

Hi @v-yamao-msft  ,

 

We won't be moving the site from SP2007 to O365 - we'll probably just start fresh completly, I should have rephrased that a little better.  We're "moving" as in the 2007 Sharepoint install will be retired and we need a new site on O365.

 

So we want to recreate something that will allow us to manage our files in O365, but without the subsites and Nintex workflows etc that we currently use in 2007.

 

Basically, we're thinking of a list with set fields, then we want some of those fields to trigger actions when they're updated (or we have a button to click when there's data that's been entered).

One of these will be a start date, but can be entered or updated after the document is created.  Once the start date is entered, we’d like to create some calendar items based on some calculations from the date.  This may take the form of some kind of button or something that can be triggered manually to create these sub items (most likely in a calendar list or something similiar).

 

Sorry for the confusion.

Highlighted
Community Support
Community Support

Re: Is this possible in Flow?

Hi @julesp ,

 

Do you want to create an item on SharePoint Calendar list when a list is modified, especially when the Date in the list is updated?

 

Before starting the flow, I created a list with a Title field, and Date column for start date.

 

Then set up the flow which is triggered by When an item is created or modified, adding a condition to check if the Date field has value, if yes, create an item on SharePoint Calendar list.

 

The function used in the Condition is:

 

not(empty(triggerBody()?['Date']))

is equal to

True

 

 

About the End Time, it will be 7 days after the start date:

addDays(triggerBody()?['Date'],7,'yyyy-MM-dd')

 

Image for your reference:

1.PNG

 

Please take a try with it on your side.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (5,433)