Expected duration: 1 day or less I need a Power Automate SQL Flow creating. I will provide remote access under my supervision, so I can learn and understand what is going on for future ammendments.
In place already: Azure SQL Database, Power Apps Connection to SQL Database (tested and working).
THE FLOW
When a file is created or modified (in SharePoint) if a particular metadata column is NOT already set :
Select SequenceNumber from Table WHERE Mycolumn=DocumentMetadataValue1 AND Mycolumn2=DocumentMetadataValue2
Condition - if there is no data returned: set NewSequenceNumber at 1. If there is data returned, get the SequenceNumber of the last row and add 1.
THEN - flow will write the new document to the database along with various managed metadata from the document.
I have already started trying to build a flow which will give you something to work with and a good picture of what I am trying to achieve. I just haven't got it quite right. Probably a quick job for the right person!