Answered

Filter data table

(0) Share

Report

Posted on by Geostation

Hi, I'm new to PowerApps and struggling with filtering a data table from an excel spreadsheet. I have a column called 'Status' which picks either 'DUE' or 'COMPLETED' depending on a date and populates the column. In excel in can filter on that column but when I try to filter 'DUE' items in PowerApps using the formula below, it gives me error messages about 'incompatible types for comparison' and 'Expected text value'.

Filter(MeetingPlanner,STATUS="DUE")

A lot of people seem to have similar issues with filter on this site but I haven't found the solution - if it is to do with the fact that my source column is a calculated value, what function or syntax do I need?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Geostation ,

Calculated fields in Excel do not work with Power Apps filters - you need to populate a field with the result (as Text)

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Geostation 32 on at

Like (0)

Report
Copy link

Link copied!

Thanks @WarrenBelz. Is there an alternative I could use in the formula in PowerApps as I'd prefer not to have change the format of my spreadsheet if I can avoid it.

Was this reply helpful? Yes No
Geostation 32 on at

Like (0)

Report
Copy link

Link copied!

I have changed the column so that it only holds text values (either 'DUE' or 'COMPLETED') and the formula still doesn't work, this time telling me 'The property on this control expects Text values' - I am using text values so am really confused.

PowerApps seems like it should be a great product for non-developers but it is so frustrating!
Help appreciated - or if there is a tutorial available please point me at it.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Geostation

Delete the table in PowerApps and reimport the new one with the changes you made.

Was this reply helpful? Yes No
Geostation 32 on at

Like (0)

Report
Copy link

Link copied!

I appreciate the help, but I changed my source data to text, deleted the data table on PowerApps and recreated it and am still getting the same error messages.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Geostation

Once you make changes to the structure of the underlying Excel table, it may not work right in PowerApps. You need to delete it from the Data Sources list and reimport it.

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Geostation ,

Yes, you can do the formula in Power Apps, probably using AddColumns - something like

Filter( AddColumns( MeetingPlanner, "Status2" YourExcelFormulaHere ), Status2="DUE" )

Naturally your Excel formula needs to be in Power Apps format.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Geostation 32 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I'll need to have a re-think as I suspect this won't be the first limitation with using Excel as my source in the app I am creating. I was trying to base my app on Excel because I understand it and haven't got that much experience in working with databases. I'll explore creating a new database. Appreciate you taking the time out to help.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Geostation ,

If you have access to SharePoint, use it - as a Database, Excel makes a good Spreadsheet . . .

Was this reply helpful? Yes No
Geostation 32 on at

Like (0)

Report
Copy link

Link copied!

Thanks Warren. Just read your https://www.practicalpowerapps.com/ blog on data structure and it makes a lot of sense. Your site is amazing and is likely to be very helpful to me so thanks for making it available,

Was this reply helpful? Yes No