Data Connections

Re: Sort (order by) an REST data connection for a drop-down list

TOE_CHEESE — Mon, 13 Nov 2017 18:16:08 GMT

Thank you. It shouldn't be much of a problem to sort the data prior to uploading to SharePoint.

Re: Sort (order by) an REST data connection for a drop-down list

Hilary Stoupa — Sat, 11 Nov 2017 00:57:37 GMT

Since you aren't using ODATA for that connection, I don't think you'll be able to sort it. Can you store the data in Excel sorted the way you want it returned?

Sort (order by) an REST data connection for a drop-down list

TOE_CHEESE — Thu, 09 Nov 2017 19:06:10 GMT

I can bring in a column of data into my drop-down list from a REST connection using the following expression... count(preceding-sibling::ns2:c) = 0. However, I need to sort this data alphabetically. Any help would be appreciated. Thank you.