a TDS in Sharepoint extract the name of the file and split In different columns of an excel table When a file is created in a file deprecated Initialize a variable ID: 1048703
Download Presentation The PPT/PDF document "FT PS flow When adding" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
1. FT PS flowWhen adding a TDS in Sharepoint extract the name of the file and splitIn different columns of an excel table
2. When a file is created in a file (deprecated)
3. Initialize a variable{ "type": "InitializeVariable", "inputs": { "variables": [ { "name": "FileName", "type": "string", "value": "@base64ToString(triggerOutputs()?['headers/x-ms-file-name-encoded'])" } ] }, "runAfter": {}}
4. Compose{ "type": "Compose", "inputs": "@{split(variables('FileName'),'_')[0]}@{split(variables('FileName'),'_')[1]}@{split(variables('FileName'),'_')[2]}@{split(variables('FileName'),'_')[3]}@{split(variables('FileName'),'_')[4]}", "runAfter": { "Initialiser_la_variable": [ "Succeeded" ] }}
5. Add a row in table{ "type": "OpenApiConnection", "inputs": { "parameters": { "source": "groups/b3b156cc-2e16-4ec6-b61c-ce92a8b0571f", "drive": "b!38V3xpodI0mgz31N_uotSIpxGEPDfrVLukM_MzpJR8cVAghzHnNLR6k_unNjDnNu", "file": "01ME3XBLRWRWABCRD2RBD3AGXS5QQCDA7B", "table": "Tableau1", "item/Code \nProduit": "@{outputs('Compose')[0]}", "item/Nom \nproduit": "@{outputs('Compose')[1]}", "item/Date MAJ \nFT provisoire": "@{outputs('Compose')[3]}", "item/Client": "@{outputs('Compose')[4]}" }, "host": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness", "connection": "shared_excelonlinebusiness", "operationId": "AddRowV2" } }, "runAfter": { "Compose": [ "Succeeded" ] }, "metadata": { "01ME3XBLRWRWABCRD2RBD3AGXS5QQCDA7B": "/general/PRE SERIES/suivi preserie GJ nouvelle trame 12 12 2023.xlsx", "tableId": "Tableau1" }}
6. { "type": "OpenApiConnection", "inputs": { "parameters": { "source": "groups/b3b156cc-2e16-4ec6-b61c-ce92a8b0571f", "drive": "b!38V3xpodI0mgz31N_uotSIpxGEPDfrVLukM_MzpJR8cVAghzHnNLR6k_unNjDnNu", "file": "01ME3XBLRWRWABCRD2RBD3AGXS5QQCDA7B", "table": "Tableau1", "item/Code \nProduit": "@{outputs('Compose')[0]}", "item/Nom \nproduit": "@{outputs('Compose')[1]}", "item/Date MAJ \nFT provisoire": "@{outputs('Compose')[3]}", "item/Client": "@{outputs('Compose')[4]}" }, "host": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness", "connection": "shared_excelonlinebusiness", "operationId": "AddRowV2" } }, "runAfter": { "Compose": [ "Succeeded" ] }, "metadata": { "01ME3XBLRWRWABCRD2RBD3AGXS5QQCDA7B": "/general/PRE SERIES/suivi preserie GJ nouvelle trame 12 12 2023.xlsx", "tableId": "Tableau1" }}