Blank Variable

Hi Team.

Hoping someone might be able to help get around a small issue.

I have a Workflow that has a Parameter of Location. Values assigned to that are for example Server1 , Server2 , Server3 , Server4

Now when you run the Work flow and select Server2 , 3 , or 4 it adds this value to the $Location variable and connects accordingly. The Issue is that when people select Server1 i actually dont want anything passed in to the variable and for it to be blank. As an example if i was to hard code these it would be something like

https://DomainName-admin.sharepoint.com

https://DomainNameServer2-admin.sharepoint.com

https://DomainNameServer3-admin.sharepoint.com

https://DomainNameServer4-admin.sharepoint.com

Any suggestions on how to work around this?

$Location = $Workflow.Parameter("Location")

#Connection Propertis
$SPURL = "https://DomainName$Location-admin.sharepoint.com"
$ClientID = "something something"
$TenantName = "DomainName.onmicrosoft.com"
$Thumbprint = "something something"

#CSV Export Location
$CSVExport = "C:\$Location-Export.csv"


#Connect to SharePoint Online
Connect-PnPOnline -Url $SPURL -ClientId $ClientID -Tenant $TenantName -Thumbprint $Thumbprint

Top Replies

craig mcfarlane over 2 years ago in reply to craig mcfarlane +1 verified

Hi.

I got around it using this method.

$Location = $Workflow.Parameter("Location") switch ($Location) { 'server1' { $SPURL = 'https://DomainName-admin.sharepoint.com' } default { $SPURL…

0 Stu.Pollock over 2 years ago
If($Location -eq "some value") { $Location = "" }

Would something similar to the above fit the bill? Placed at line 2?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 craig mcfarlane over 2 years ago in reply to Stu.Pollock

Thanks mate. Where am i adding that If statement?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Stu.Pollock over 2 years ago in reply to craig mcfarlane

Between Line 1 and Line 3
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 craig mcfarlane over 2 years ago in reply to Stu.Pollock

Having some issues with that. Let me get my info together and post back.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

+1 craig mcfarlane over 2 years ago in reply to craig mcfarlane

Hi.

I got around it using this method.

$Location = $Workflow.Parameter("Location")

switch ($Location) {
    'server1' { $SPURL = 'https://DomainName-admin.sharepoint.com' }
    default   { $SPURL = "https://DomainName$Location-admin.sharepoint.com"}
}

#Connection Properties
$CxParams = @{
    URL        = $SPURL
    ClientID   = "something something"
    Tenant     = "DomainName.onmicrosoft.com"
    Thumbprint = "something something"
}

#CSV Export Location
$CSVExport = "C:\$Location-Export.csv"

#Connect to SharePoint Online
Connect-PnPOnline @CxParams