Unanswered

Add filter to gallery based on calculated column from sharepoint list

(0) Share

Report

Posted on by YogaLayang

Hello, I am quite new to power apps and right now I'm trying to build an app where the user can perform read and update operation on Sharepoint list record directly from the app. I followed a helpful tutorial from Reza Dorrani youtube channel about editable grid.

Unfortunately, I am facing difficulties when trying to add a filter based on a calculated column from my sharepoint list. Is there any proper way to accomplish this?

Here is the calculated column on my sharepoint list:

And here is the editable grid with filters on my power apps:

Fetching the data from sharepoint list to gallery using collection:

Any help is much appreciated!

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@YogaLayang

PowerApps does not work well with SharePoint calculated columns. Do the calculation in PowerApps and use that to filter your data.
YogaLayang 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply. I followed your suggestion and change the calculation directly in the Index FHO column in my power apps. Though now it is displaying the rows of data correctly as in the sharepoint list, I'm still struggling on how to apply the filter for the Index FHO column since it is now an independent and separated column not belonging to the collection that is connected to the original data source. Would you care to elaborate on how to implement the filter?

Thanks in advance
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@YogaLayang

Use AddColumns() to add it to the list and then include it in the filter.