Unanswered

List not filtering correctly

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Folks,

See the Excel table and photo of the app that I am delivering. I need to be able to filter the Excel list down to the exact row. I planned on putting in the following formula:

Filter(OJTLIST, CAT = PROCESS.Selected.DEPT, ROW = 2), however, all I get are error messages. Anyone have any clue what I'm doing wrong? I have alternatively tried:
Filter(OJTLIST, CAT = PROCESS.Selected.DEPT, ROW = '2'); however, I get an error message that it is an invalid argument type.

Any help would be greatly appreciated!!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The only way you can do this is make the row number a field in the table and populate it with the number. When PowerApps looks at an Excel formatted table, it is simply data, not an Excel sheet.

You also might have a quick look at this video.

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.

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I watched the video and recreated the tables as SharePoint lists, but it is still not working... how would you make the Row column a number field? Do you mean just formatting the column as a number type (just like text or date?)

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

SharePoint has a built-in ID number you could use, which starts at 1 and continues for the life of the list. Deleting a record however does not "re-use" the number. If you have a small list, you could simply make a numeric field and populate this as required. I am not sure exactly what you are trying to do, but you can also dynamically populate a gallery with numbers. This blog of mine is about alternate shading in galleries, but the first bit is what you need to put numbers in a field called RowNo in the gallery.

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.

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No