Power Platform Community Forum Thread Details

"Hi, I am using Power Automate for the first time. Can anyone please guide me on the best practices to approach my workflow?

I need to have three flows:

The first flow will dump my SharePoint lists data into a SQL Server.
The second flow will be an automated process. Whenever a new item is created or modified the existing records in the SharePoint lists, it should either insert the new record or update the existing record in SQL and
I need to be notified if an existing item is deleted. If any item in the SharePoint list is deleted, is there a way to flag them by inputting a column? and can we just delete the record on sql server.
can i add new column on sql to know the source file name when the data gets dumped?
I appreciate for taking time to read this and thank you

Categories: