cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
steve_hendy
Resolver I
Resolver I

filter StartsWith And Not

My code has delegation on the Not part.  How can I fix?

Sort(
Filter(
'Report Archives',
StartsWith(
'Report/Doc. No.',
DropdownYear.Selected.Value
),Not('Report/Doc. No.' in 'PDF Reports'.'Report Number')
),
'Report/Doc. No.'
)

1 ACCEPTED SOLUTION

Accepted Solutions

I found the solution was to make a collection then filter on that.

ClearCollect(
col_ArchiveReports,
Sort(
Filter(
'Report Archives',
StartsWith(
'Report/Doc. No.',
DropdownYearSelect.Selected.Value
) And Certificate = false
),
'Report/Doc. No.'
)
);

View solution in original post

3 REPLIES 3
mdevaney
Super User
Super User

@steve_hendy 
Is your datasource SharePoint?  If yes, you cannot use the IN operator.  There is no workaround.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

tavila
Community Support
Community Support

I guess you are facing the delegation due the Sort function, since:

"In Sort, the formula can only be the name of a single column and can't include other operators or functions."

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#sorting-functions

 

Tarcisio Vilas Boas

I found the solution was to make a collection then filter on that.

ClearCollect(
col_ArchiveReports,
Sort(
Filter(
'Report Archives',
StartsWith(
'Report/Doc. No.',
DropdownYearSelect.Selected.Value
) And Certificate = false
),
'Report/Doc. No.'
)
);

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,211)