Power Apps Filter Date table using Text-input control

(0) Share

Report

Posted on by HM-22080408-0

Hi Members,

I have a requirement in Power Apps to filter the data table using text-input control [With SharePoint list]

I have a SharePoint list [Power Platform Training], with various columns like:

Text
Choice
Currency
Date and time

Using this SharePoint list, I need to filter the Power Apps data table using Text-input control.

For Example,

When a user searches for any column values in a text-input control, the data table should filter and display the data based on the provided text.

Can anyone please suggest how I can achieve this? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

VaidasG 469 on at

Like (0)

Report
Re: Power Apps Filter Date table using Text-input control

Hi @Hemashree,

You can use DateValue formula to pass your TextInput.
DateValue(TextInput1.Text)

Regards
VaidasG

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report

Re: Power Apps Filter Date table using Text-input control

Hi @VaidasG

I need to filter any column values, not only the date column, then how can I achieve this?

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report
Re: Power Apps Filter Date table using Text-input control

Hi @Hemashree,

Assuming your "Course start date" column in your table is cast as string, you could use something like:
Search('Your Data Source', TextInput1.Text, "User ID", "Course", "Course Start Date", "Course Cost")

Regards
VaidasG

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
HM-22080408-0 67 on at

Like (0)

Report
Re: Power Apps Filter Date table using Text-input control

Hi @VaidasG

As you said, I tried it, but it only supported text-type columns, as shown below:

But my SharePoint list has different types of columns like:

User ID = Title column
Course = Choice type column
Course Start Date = Date and time column
Corse Cost = Currency column

How can I filter those in a data table using text input control? Please suggest how I can achieve this.

Was this reply helpful? Yes No
WarrenBelz 152,847 Most Valuable Professional on at

Like (1)

Report
Re: Power Apps Filter Date table using Text-input control

You can only search Text fields - you need to convert the others

Search( AddColumns( DataSource, "CourseStart", Text('Course Start Date',ddmmyyyy'), "CourseName", Course.Value, "CourseCost", Text('Course Cost') ), YourSearchBox.Text, "User ID", "CourseName", "CourseStart", "CourseCost" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Hi @Hemashree ,

Was this reply helpful? Yes No
VaidasG 469 on at

Like (1)

Report
Re: Power Apps Filter Date table using Text-input control

@Hemashree

Done quick test on my side:
Create a collection for your data:
ClearCollect(colTableContent, AddColumns(ShowColumns('Power Platform Training', "Title", "Course", "CourseStartDate","CourseCost"),"CourseText",Text(Course),"CourseStartDateText",Text('CourseStartDate'), "CourseCostText",Text('CourseCost')))
Use this collection in your table -> choose text version of your non-text columns
Search(colTableContent,TextInput1.Text,"Title","CourseText","CourseStartDateText","CourseCostText")

Hope this helps 😀

Regards
VaidasG

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No