I am trying to add a "Select ----" default option to the top of a drop-down.
I found this great dynamic example that works for sharepoint.
with (lclchoices :choices(powerappssamples.choicecolumn)),
forAll(sequence(countrows(lclchoices)+1), {value: if(value=1, "Select ----", last(firstn(lclchoices, value -1)).value)
)
This would replace parent.allowedvalues in the items property. note: the first "value" is the record column called "value:" and the last is the return value from the choices and the 2 middle values are part of the sequence statement.
I am wondering if this would work for the Salesforce Datasource. Is choices available to get the picklist values? Also wondering what it expects for the record column. I tried all sorts of options and cannot seem to stumble on the right answer.
FYI.....newbie here......just finishing my first app and this is the last loose end.
