transfer sharepoint element to sql after 24 hours.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello ,

I apologize for my bad english ...

I'm working on a project with an application created with powerapps that feeds a sharepoint list.

I would like to set up a flow that transfers part of the list to a SQL database at Azure SQL DATABASE.

eg a user create a data (line) on sharepoint and after 24 hours his line moves in the sql database.

I set up moving items between two lists when it is created but not from a time slot.

I wish to set it up because I quickly arrive at 2000 lines in the Sharepoint list and therefore the entries are no longer visible in powerapps because there are more than 2000 lines.
Do you think it's a good method?

is it possible to set up this flow?

Thanks for your help.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Gristy 2,429 on at

Like (0)

Report
Copy link

Link copied!

Set up a scheduled flow that runs every 24 hours
Inside the flow perform your logic i.e. Get Items, Submit to SQL.

What you will need to do is indicate either on the items themselves (i.e. column indicating already synced yes/no) or by storing the last ID that you synced so you can start at last ID + 1 in your Get Items query.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

You could use Recurrence as a trigger and run Flow once a day.

Then use Get item to get the items in the list, and use Filter Query to filter the items created the previous day.

Then add these items to the Database.

Or you could use Delay action to save the newly created item to Database after a delay.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft and @Gristy

thank you for your help I wanted to create the following flow:

when an item is created

'crée' is greater than formatdatetime (addHours (utcnow (), - 24), 'yyyy-MM-dd')
but the flow tells me an error in the condition

because what I want is that 24 hours after the creation date I insert the line in sql.
I will do the tests. thank you very much for your help.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hey @Anonymous

Can you try updating the expression as

addHours(utcnow(),-24)

As the Created attribute of the trigger body wil be of the similar format, you can try by just adding the hours and check if the time comparision.

BTW, this logic wont work as the condition will never be true as the flow will trigger when a new item is created and there is no point comparing the created time with the past time.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please try this expression:

addHours(utcNow(),-24,'yyyy-MM-dd')

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft @yashag2255 @Gristy

Thanks for your help. My flow works perfectly.

Was this reply helpful? Yes No