How to deploy multiples csv files in azure table storage at a time using powershell script

Regarding pass file path as parameter, you can definition the global parameters for this Script:

param(
[string]$filepath
)
function Add-Entity()
{
 [CmdletBinding()]

 param
 (
 $table, 
 [string] $partitionKey, 
 [string] $RowKey, 
 [string] $Label_Value,
 [string] $Lable_cost 
 )

 $entity = New-Object -TypeName Microsoft.WindowsAzure.Storage.Table.DynamicTableEntity -ArgumentList $partitionKey, $rowKey 
 $entity.Properties.Add("Label_Value",$Label_Value)
 $entity.Properties.Add("Label_Value",$Lable_cost)
 $result = $table.CloudTable.Execute([Microsoft.WindowsAzure.Storage.Table.TableOperation]::Insert($entity))
}

$tableName = "TestTable"
$subscriptionName = "Tech Enabled Solutions"
$resourceGroupName = "abc"
$storageAccountName = "defghi"
$location = "North Central US, South Central US"

# Get the storage key for the storage account
$StorageAccountKey = "12345678"

# Get a storage context
$ctx = New-AzureStorageContext -StorageAccountName $storageAccountName -StorageAccountKey $storageAccountKey

# Get a reference to the table
$table = Get-AzureStorageTable -Name $tableName -Context $ctx -ErrorAction Ignore
$csv = Import-CSV $filepath

ForEach ($line in $csv)
{
 Add-Entity -Table $table -partitionKey $line.partitionkey -rowKey $line.RowKey -Label_Value $line.Label_Value Lable_cost $line.Lable_cost

}

Then you can pass parameters in Script Arguments input box of Azure PowerShell task: -filepath $(build.sourcesdirectory)\DeploymentScripts\TestTable.csv.

Regarding the multiple files with different columns, you can define a array object parameter, then include filepath and columns in its properties, then iterate the array object, for example:

    param(
         [object[]]$fileObj
        )
    foreach($fo in $fileObj){

     Write-Host $fo.filepath

    $cArray=$fo.Cols.split(",")

      foreach($c in $cArray){

      Write-Host $c

      #TODO add column to table

     }

#TODO insert data to cloud table per to current file 
    }

arguments:

-fileObj @(@{"filepath"="$(build.sourcesdirectory)\DeploymentScripts\TestTable.csv";"Cols"='c1,c2'},@{"filepath"="$(build.sourcesdirectory)\DeploymentScripts\TestTable2.csv";"Cols"='c3,c2'})

Update:

foreach($fo in $fileObj){
 Write-Host $fo.filepath
 $csv = Import-CSV $fo.filepath
  $cArray=$fo.Cols.split(",")
  foreach($line in $csv)
    {
    Write-Host "$($line.partitionkey), $($line.rowKey)"
    $entity = New-Object -TypeName Microsoft.WindowsAzure.Storage.Table.DynamicTableEntity -ArgumentList $line.partitionkey, $line.rowKey 
        foreach($c in $cArray){
     Write-Host "$c,$($line.$c)"
 $entity.Properties.Add($c,$line.$c)


        }
 $result = $table.CloudTable.Execute([Microsoft.WindowsAzure.Storage.Table.TableOperation]::Insert($entity))
 }
}

Argument:

@(@{"filepath"="data.csv";"Cols"="Col1,Col2,Col3"},@{"filepath"="data2.csv";"Cols"="Col1,Col6,Col7,Col8"})

Sample data in csv:

data.csv:

 partitionkey,rowKey,Col1,Col2,Col3
    p1,r1,one,two,three
    p2,r2,example1,example2,example3

data2.csv:

partitionkey,rowKey,Col1,Col6,Col7,Col8
p1,r1,one,two,three,four
p2,r2,example1,example2,example3,example4

Update:

param(
     [object[]]$fileObj
    )

$storageAccountName = "XXX"

$tableName="XXX"

# Get the storage key for the storage account
$StorageAccountKey = "XXX"

# Get a storage context
$ctx = New-AzureStorageContext -StorageAccountName $storageAccountName -StorageAccountKey $storageAccountKey

$table = Get-AzureStorageTable -Name $tableName -Context $ctx -ErrorAction Ignore

foreach($fo in $fileObj){
 Write-Host $fo.filepath
 $csv = Import-CSV $fo.filepath
  $cArray=$fo.Cols.split(",")
  foreach($line in $csv)
    {
    Write-Host "$($line.partitionkey), $($line.rowKey)"
    $entity = New-Object -TypeName Microsoft.WindowsAzure.Storage.Table.DynamicTableEntity -ArgumentList $line.partitionkey, $line.rowKey 
        foreach($c in $cArray){
     Write-Host "$c,$($line.$c)"
        $entity.Properties.Add($c,$line.$c)


        }
        $result = $table.CloudTable.Execute([Microsoft.WindowsAzure.Storage.Table.TableOperation]::Insert($entity))
 }
}

Update:

param(
     [object[]]$fileObj
    )

$storageAccountName = "XXX"

$tableName="XXX"

# Get the storage key for the storage account
$StorageAccountKey = "XXX"

# Get a storage context
$ctx = New-AzureStorageContext -StorageAccountName $storageAccountName -StorageAccountKey $storageAccountKey



foreach($fo in $fileObj){
$table = Get-AzureStorageTable -Name $fo.tableName -Context $ctx -ErrorAction Ignore
 Write-Host $fo.filepath
 $csv = Import-CSV $fo.filepath
  $cArray=$fo.Cols.split(",")
  foreach($line in $csv)
    {
    Write-Host "$($line.partitionkey), $($line.rowKey)"
    $entity = New-Object -TypeName Microsoft.WindowsAzure.Storage.Table.DynamicTableEntity -ArgumentList $line.partitionkey, $line.rowKey 
        foreach($c in $cArray){
     Write-Host "$c,$($line.$c)"
        $entity.Properties.Add($c,$line.$c)


        }
        $result = $table.CloudTable.Execute([Microsoft.WindowsAzure.Storage.Table.TableOperation]::Insert($entity))
 }
}

Arguments: @(@{"filepath"="data.csv";"Cols"="Col1,Col2,Col3";"tableName"="table1"},@{"filepath"="data2.csv";"Cols"="Col1,Col6,Col7,Col8";"tableName"="table2"})