Filter within AddColumns formula

(0) Share

Report

Posted on by johnjohn123

3,514

I have this formula to add column on a SharePoint list named "grant Applications"

// Create a collection of all related Grant Applications
ClearCollect(
 colGrantItems,
 AddColumns(
 ShowColumns(
 
 'Grant Applications',
 "ID",
 "Title"
 ),
 "Level",
 2
 );

now i only want to filter the items inside the "Grant Application' which have status= Open or Inprogress.. so how i can filter my above formual?

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
You can try something like this ClearCollect( colGrantItems, Filter( AddColumns( ShowColumns( 'Grant Applications', "ID", "Title" ), "Level", 2 ), Status.Value = "Open" || Status.Value="In Progress" )); //Assuming status to be a choice column
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@NandiniBhagya20 but i am getting error as "name is not valid, Status not recognized"
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please let me know the name of your column that has values "In Progress", "Open", etc.
And what type of column is it?
Single line of text, choice (single select), choice (multi select)
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @johnjohn123 ,

I suggest you to use the Filter function on the data source first, then ShowColumns and AddColumns.
I have made a test for your reference:
1.
2.I'm assuming Status is the Choice column.
ClearCollect( colGrantItems, AddColumns( ShowColumns( Filter( 'Grant Applications', Status.Value = "Open" || Status.Value = "In Progress" ), "ID", "Title" ), "Level", 2 ) )
3.

Best Regards,
Levi