Create Fields with Configuration CSV file https://sharepointfordeveloper.blogspot.com

Fields.ps1

#Dev Import
$Path = "C:\SharePointPnPPowerShell2013\"
Import-Module '$Path\SharePointPnP.PowerShell.2013.Commands.dll';

#-----Function to create Site Columns----#
function CreateSiteColumns($csvPath, $SiteURL) {

    $Cred = $global:GlobalCred

    $newUtfFile = "SiteCollectionSiteColumns_utf8.csv";

    If (Test-Path  $newUtfFile ) {
        Remove-Item $newUtfFile
    }
	
    Get-Content $csvPath | Out-File $newUtfFile -Encoding utf8
	
    # Get SPWeb Object
	
	
    # Reads the csv file and gets all records in one collection
    $MyFile = import-csv -Delimiter "," -Path $newUtfFile -Encoding Unicode

	
    $Web = $null;
    
    Connect-PnPOnline –Url $siteUrl –Credentials $Cred  
    $message = "Connect to site $siteUrl" 
	

    # Looping the csv file collection
    foreach ($myRow in $MyFile) {
        # Reading Site Column Attributes values from the csv file collection
        $colGroup = $myRow.Group                
        $desc = $myRow.ColumnDescription
        $columnName = $myRow.SiteColumnName
        if ($myRow.ColumnDisplayName -ne $null -and $myRow.ColumnDisplayName -ne "") {
            $columnDisplayName = $myRow.ColumnDisplayName.Replace("&", "&")
        }
        $fieldGUID = $myRow.SiteColumnID
        $type = $myRow.DataType
        $AdditionalFields = $myRow.AdditionalFields
        $req = $myRow.IsRequiredField
        $space = " "
        $required = "";

        if ( $req -ne "" -and $req -ne $null) {
            $required = ' Required ="' + $req + '" '
        }
		
        # Making SPField XML For using while creating Field 
        $caml = $myRow.CAML + $type + $myRow.CAML2 + $columnName + $myRow.CAML3 + $columnDisplayName + $myRow.CAML4 + $columnName + $myRow.CAML5 + $fieldGUID + $myRow.CAML6 
        foreach ($isParam in $myRow.Optional.split("|")) {

            if ($isParam -eq "required") {
                $caml = $caml + $space + $required
            }
            else {
                $caml = $caml + $space + $isParam
            }  
        }
						
        # If Field is a Choice Type and we want to assign default values in that Field
        if ($type -eq "Choice" -or $type -eq "MultiChoice") {
            $caml = $caml + "<CHOICES>"
            foreach ($isChoice in $myRow.Choice.split("|")) {
                if ($isChoice -ne $null -and $isChoice -ne "") {
                    $caml = $caml + "<CHOICE>" + $isChoice.Replace("&", "&amp;") + "</CHOICE>"
                }
            }
            $caml = $caml + "</CHOICES>"
        } 
	 
        if ($type -ne "TaxonomyFieldType") {
            $caml = $caml + $myRow.CAML7
        }
		
        try {
            $IscolExit = Get-PnPField -Identity $columnName -ErrorAction Stop
            write-host "Column $columnName already exists."
            Write-Host "Column $columnName already exists."
			
        }
        catch {
            if ($type -ne "TaxonomyFieldType") {    

                if ($type -eq "Lookup" -or $type -eq "LookupMulti") {
                      try { 
							$SourceID = "http://schemas.microsoft.com/sharepoint/v3" 
					  		$ListGUID = Get-PnPList -Identity  "$LookupList"
							Get-PnPProperty -ClientObject $ListGUID -Property Id
							$replaceValue ="^Lookup^";
							
							if($LookupListColumn -eq $null -and $LookupListColumn -eq ""){
								$LookupListColumn="Title"
							}
							
							if($myRow.IsMultiValued -ne $null -and $myRow.IsMultiValued -ne ""){
								if([System.Convert]::ToBoolean($myRow.IsMultiValued)){
									$ReplceString =' List="{'+$($ListGUID.Id) +'}" ShowField="'+$LookupListColumn+'" Mult="TRUE"'	
								}
								else
								{
									$ReplceString =' List="{'+$($ListGUID.Id) +'}" ShowField="'+$LookupListColumn+'"'	
								}
							}
							$Web = Get-PnPWeb 
							$caml =  $caml.Replace($replaceValue,$ReplceString); 
							$caml = $caml.Replace($SourceID, $Web.Id);  
							try{
							
								$message = "Create New Column : $columnName and xml $caml"
			                    Write-Host $caml 
			                    Write-Host $message  -ForegroundColor Green 
								
								$output = Add-PnPFieldFromXml  -FieldXml $caml
								$output.set_Description($desc)
								$output.set_Group($colGroup) 
								$output.Update();
								Execute-PnPQuery
								$message = "Create New Column : $columnName "
			                    Write-Host $message  
			                    Write-Host $message  -ForegroundColor Green 
							
							}catch{  
								write-host "ERROR - Column $columnName  NOT created."			
                            	Write-Host "ERROR - Column $columnName NOT created."
                            	Write-Host "$($_.Exception.Message)"   
							}  
                        }
                        catch {
                            Write-Host "$($_.Exception.Message)" 
                        }
                }
                else {
                    try { 
                        Write-Host  $caml
                        $output = Add-PnPFieldFromXml  -FieldXml $caml
                        $output.set_Description($desc)
                        $output.set_Group($colGroup)
                        $output.Update();
						Execute-PnPQuery
                        $message = "Create New Column : $columnName "
                        Write-Host $message  
                        Write-Host $message  -ForegroundColor Green  
                    }
                    catch {
                        write-host "ERROR - Column $columnName  NOT created."			
                        Write-Host "ERROR - Column $columnName NOT created."
                        Write-Host "$($_.Exception.Message)"   

                    }
                }
            }
            else {
                #For tax Columns----
            }
		
        } 
        
    }

} 

$siteUrl = "http://myintranet.com/sites"
$path = 'C:\Users\basantp\Documents\PNP Blog Section\Code\Fields'
$inputFile = $path + "\SiteColumns.csv"
CreateSiteColumns $csvPath $SiteURL

SiteColumns.csv

To learn more about the PNP-PowerShell Ojbect Model. Please visit my blog.