Skip to main content

Notifications

Power Automate - General Discussion
Answered

create item creates 2 elements in sharepoint

(0) ShareShare
ReportReport
Posted on by 413

Hi there. 

 

As discuss here: Solved: Create a date with get item() and a specific time. - Power Platform Community (microsoft.com)

 

I had some troubles with datetime variables (always a nice gym) but we manage the issue thanks to your advices.

Now I have to make a copy of my sharepoint element, to do it, i'm using "create element" function giving him the same input information of my get item() put at the begin of the flow. 

 

We start from an element with a Start and an End fields. The End field should be empty.

Then, my flow close the item putting a value on End field (problem solved in topic linked above) and it creates a copy with the Start field valued as "DayAfter 00:00:00" and End field empty. (in little words, I split the event at the midnight).

 

So, we start from this:

Calcioscacchi_0-1675778989555.png

 

 

This is the flow composed by a getItem() setted to take the most recent element (so, array with dimension 1):

Calcioscacchi_1-1675779046984.png

 

then a flow piece discussed in the above topic close the element at 23:59:59 of the same day.

Immediatly after this, I compose another daytime which is the Start of the new event:

 

Calcioscacchi_2-1675779176235.png

and after a conversion, I create the new element:

Calcioscacchi_3-1675779221265.png

 

and, as aspected, we have this (actually, sometimes it creates another row with Start: 04/02/2023 00:00 and End: 03/02/2022 23:59:59, I dont't know why):

 

Calcioscacchi_4-1675779297308.png

 

 

Now, If I run the flow again, we have this:

 

Calcioscacchi_5-1675779448682.png

When I aspected to find the row with ID=104 closed at 04/02/2023 23:59:59 and the ID=105 with Start = 05/02/2023 00:00:00.

 

The getItem() output of my second round of the flow is this and is wrong:

 

Calcioscacchi_6-1675779620396.png

 

Do you have some ideas of what is happening? 

Thanks.

 

  • Verified answer
    Calcioscacchi Profile Picture
    Calcioscacchi 413 on at
    Re: create item creates 2 elements in sharepoint

    Solved! It was a region configuration, with a few conversions I did it 😉

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard