Sort DataTable by the content of DropDown

[Maorzd23]

Hi all,

I'm trying to sort a DataTable by the content of DropDown,
In my DropDown there is "Waiting for approval", "Rejected", "Approved".
When the contents of the DropDown is = "Approved" I want it to appear in the DataTable.

I tried to use in that Formula:
Filter (RequestForCourse, Status.Value =...)

But I can not access the content

Anyone have an idea?

Thanks in advance,
Maor

[dinusc]

Since you've tried using the "Filter" function, I assume you would like to filter (not sort) your data in data table.

Your approval values (Waiting, Rejected, Approved) are static so you could use osmething like this:

Filter(RequestForCourse, Status.Value = ComboBox1.Selected.Value) 

The example above assumes that the  "
RequestForCourse" source contains the "Status" field that containes all the valid approval values, that those values are populated in a ComboBox control and that the ComboBox control is in a single selection mode (so you cannot select "Rejected" and "Approved" at the same tyime for example).

[Maorzd23]

First of all thanks for the quick answer @dinusc

Sorry but I did not explain myself well.
I use in Sharepoint list. I have a Choice field named Status and it contains the three options (Waiting, Rejected, Approved).
I want to filter and display only what is "Approved" in the DataTable. 

It is possible?

Thanks again

[dinusc]

Correct. The formula above should work for you.In your Sharepoint list, make sure that the Status field (of type Choices) does not allow multiple selections. Then set your ComboBox control as following: ComboBox.Items = Choices(RequestForCourse, Status)

Then set your DataTable as following: DataTable.Items = Filter(RequestForCourse, Status.Value = ComboBox1.Selected.Value) 

After that, selecting an option from the ComboBox control ("Approved" for example) should automatically filter your DataTable control

[Maorzd23]

Thanks again @dinusc

But I dont use any comboBox, I want to use the content of a field (Choice field, named status) in the item I created in the list.

I use a DataTable that only displays what its status is "Approved" on my Sharepoint list

Thanks

[dinusc]

I thought you wanted to use a DropDown control (form your first message) and therefore I suggested to use a ComboBox which is very close functionally but can be bound to your Choice field from your SharePoint list.

Can you please explain again what controls you're trying to use and how would you like to filter your list (selecting an item from DropDown/ComboBox control, checkbox, Listbox or else)?

The filter formula above can work with any value, regardless where it comes from. The Status field does not even need to be added to the Data Table control. 

[Anonymous]

Add a combo box control in your app and set its item property tot Choices(SharePointListName.Satatus).

This will display Waiting, Rejected and Approved as choices.

Let me know how this goes (while I am creating a test app)...

[dinusc]

Confrmed. That worked for me. I can see the content of the Choices column in the combobox control

[Anonymous]

Is that what were looking for? If so, mark it as an accepted solution, if not ask more, specific question.

[dinusc]

Maorzd23 was looking for a way to filter the data table control and using the ComboBox control for that has been already suggested.