cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
steve_hendy
Helper I
Helper 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 III
Super User III

@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
Microsoft
Microsoft

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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

Top Solution Authors
Top Kudoed Authors
Users online (70,367)