SubString Error

[Matt_Dahdouh]

I am creating a flow that runs the following process. I need to trim the ("") off the end of the record that SalesForce is returning. I am trying to use this: 

substring(variables('varSector'),1,sub(length(variables('varSector')),12))

This is the output from Select Sector,

[shoog]

Your expression references varSector, not the output of the Select Sector action, is that correct?

Can you check the run history what varSector is set to? From the error message it appears the variable is empty/null.

[Matt_Dahdouh]

@shoog 

Yes, my expression references varSector. It will not let me have my substring under Set varSector. 

[shoog]

The Select action will return an array, so it's impossible to assign it to a string variable.

In case there could be multiple records from your source, you should place the consecutive actions in an apply to each loop.

Assuming you always expect just one result, you could use

substring(first(body('Select Sector')),1,sub(length(first(body('Select Sector'))),12))

Make sure the for the length 12 is right though, I think you intended 2 there for both of the quotes.

[Matt_Dahdouh]

@shoog 

There is multiple records from the source, which gets filtered in the Select Action, down to the one record that is identified. I need to do this for a number of fields. This just happens to be the first one.

[shoog]

The Select action selects which fields you want to keep from an array of objects, it will not reduce the number of items in the array.

If you want to filter, please use the Filter array action instead to make sure you always end up with 1 record, the expression in my previous reply will work as long there is just 1 record output from the Select action.

[Matt_Dahdouh · Accepted solution]

I have found through testing that a Combo Box will NOT accept a variable as a the Default property. A Combo Box allows you to have a variable as the default, while also having a list of options from Sharepoint.

[shoog]

@Matt_Dahdouh  I think your last reply is in the wrong topic, this one is about a flow, not a canvas app.