Power Platform Community Forum Thread Details

Hi All,

I have a SharePoint List, where we have a good number of tickets created. Now we are trying to move this tickets to SQL server. The purpose of moving this tickets to SQL Server is just to track the historical tickets. So the Criteria is if the Ticket status is "Closed" and it has been 30 days since it is closed then we need to move that ticket to SQL Server table.

for eg. Ticket 1 has close date of 18th Dec 2020 and today's date is 18th Jan 2021 then it has been 30 days since that ticket is closed so we will be moving this ticket to SQL server.

Now for eg. if i have 15 columns in SharePoint list then what i did is i created a table with same 15 columns in SQL server. As of now it is not having any records.

So first i want to know via Flows/Power Automate how to move the SharePoint lists records to the SQL server table (With the condition that ticket should be closed before 30 days from todays date). This flow should run daily.

Please let me know the detail steps because i Don't have much knowledge in Flows and Power Automate.

Thanks in Advance,

Prakash

Categories:

Building flows