Now add new step, and chose the ‘select’ action and underexpression it should skip the first record since the first row contains the data. select the expression and here enter first([Select the outputs from the compose-split by new line) now split the result with, split(first([Select the outputs from the compose-split by new line),’,’ Here my CSV has 7 field values.Ĭlick on ‘new step’ and add another compose action rename it as ‘Compose – get field names’. We know from the CSV the top header has field names. Split(outputs('Get_file_content')?,outputs('Compose-new_line')) Here we need to split outputs of get file content, by the new line. Rename it as ‘Compose – split by new line’. If there is it will be denoted under ‘Flow checker’. inside the ‘Inputs’ field just hit the ‘Enter’ key. Now select the ‘Compose’ action and rename it to ‘Compose –new line’. The final action should look like below in my case. Here I am selecting the file manually by clicking on the ‘folder’ icon. Search for action ‘Get file content’ and select the action under ‘OneDrive for business’ actions. It should take you to the flow designer page.Ĭlick on the new step and get the file from the one drive. Here I am naming the flow as ‘ParseCSVDemo’ and selected ‘Manual Trigger’ for this article. Now click on ‘My Flows’ and ‘Instant cloud flow’. Go to Power Automate using the URL ( ) or from the app launcher. Here I have created a folder called ‘CSVs’ and put the file ‘RoutesDemo.csv’ inside the CSVs folder. Here I am uploading the file in my dev tenant OneDrive. Upload the file in OneDrive for business. Thanks to Paulie Murana who has provided an easy way to parse the CSV file without any 3rd party or premium connectors. Below is the block diagram which illustrates the use case. Here the CSV file is uploaded in OneDrive, but this file can be also in the SharePoint document library. This article explains how to automate the data update from CSV files to SharePoint online list. Currently, they are updating manually, and it is cumbersome. I recently had a use case, where my customer wants to have data in a CSV file uploaded to SharePoint.
0 kommentar(er)
