Power Automate SQL Flow
- or -
Post a project like this1341
£100(approx. $125)
- Posted:
- Proposals: 6
- Remote
- #2936027
- OPPORTUNITY
- Awarded
Experienced Graphics designer |Experienced WordPress Full Stack|SharePoint Expert|Data Entry Team |flyer/business card/Brochure||2DAnimation||Photoshop work|
Islamabad
Azure | PowerBI | SQL | SSIS | SSAS | Tableau | Javascript | Jquery | MVC .Net Core | EF Core | .Net Core API | ASP.Net |
Ranchi
software engineer|Full-Stack Software Developer| web developer| App developer | AI Engineer | WordPress
Indore
Designer and Developer|WordPress|Shopify|PSD|PHP HTML, JavaScript|WIX| PowerPoint/Keynote| Logo Designing
Berlin
31966863146592359825276731134271713811478
Description
Experience Level: Entry
Estimated project 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!
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!
Labyrinth T.
100% (26)Projects Completed
28
Freelancers worked with
12
Projects awarded
42%
Last project
22 Aug 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies