cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Duplicate problem recording in SQL and in an SPO list

Hello,

I create a stream that works like this:
when a creation or modification is done in the list A, I get the recordings as well as the version and the id to put them in list 2 then I insert the recording in SQL.

I would like registration above 25 hours to be removed from list A (I have implemented the formula but it does not work)

The problem is that as soon as there is a new element or a modification, I insert the same record several times in list B and in SQL.


Do you have any idea of ​​how to solve this problem?

 

 

 

the condition to erase it beyond the 25th hour is:

greater(utcNow('yyyyMMdd'), formatDateTime(addHours(item()?['Created'],-25),'yyyyMMdd'))
 
I will put the overdrive phase in the last position
1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

Could you please explain your flow in English or share the screenshot of the flow in English?

Please take a try to create a flow as screenshot below:

1.png

The expression in the First column of the Condition as below:

addHours(items('Apply_to_each')?['Created'],25)

The expression in the second column of the Condition as below:

utcNow()

 

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

5 REPLIES 5
v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

Could you please explain your flow in English or share the screenshot of the flow in English?

Please take a try to create a flow as screenshot below:

1.png

The expression in the First column of the Condition as below:

addHours(items('Apply_to_each')?['Created'],25)

The expression in the second column of the Condition as below:

utcNow()

 

 

Best regards,

Alice       

 

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

Anonymous
Not applicable

hi @v-alzhan-msft 

 

unfortunately I can not put in English, when I want to edit in the menu - Language and Time Zone - I have a load without displaying the languages.

 

I describe you my flow:

1
when an item was created or modified in my list
List A

2
I send a Http request to sharepoint
to retrieve the version of the item

3
I initialize a variable
which recovers the value of the hhtp request

4
get the elements
from list A

5
when an item has been created or modified in list A
I create the items in the list B (I take the version and the id of the list A) and in a base sql (I take again the version and the id of list A)

6
when an item is created after the 25th hour in list A, I delete the items.

 

 

I set up your code, when an item is created after 25 hours it is created in the list 2 and created in the SQL database, and it works.

 

However, he copies me every time all the items.
ex:


list A


title | ID
Hello | 2
World | 3
Ninja | 4

 

List B
title | ID
Hello | 2
Hello | 2
World | 3
Hello | 2
World | 3
Ninja | 4

 

SQL
title | ID
Hello | 2
Hello | 2
World | 3
Hello | 2
World | 3
Ninja | 4

 

Is it possible to put a condition that analyzes if the item already exists and if it does not create it?

 

 

Hi @Anonymous ,

 

Please refer to screenshot below to create the flow:

1.png

Expression in the Condition 2 as below:

length(body('Get_items_2')?['value'])

 

Best regards,

Alice       

 

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

Anonymous
Not applicable

hi @v-alzhan-msft ,

 

Thanks for the interest and your help for this flow,

 


The problem is that I can not determine the query filter because I do not have a title column in my list A and my list B.

An Item can have multiple versions and a single ID.

 

What I want is to copy the items of the list A in the list B as soon as there is a new entry in the list A without having the duplicates each time.

 

I noticed that if there is a new entry in the A list and an old item's idication, the new item takes the version of the modified item.

 

Thank you for your help, I translated and made screens of my flow with my explanations.

 

 

Anonymous
Not applicable

thks

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,315)