web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps in operator does not w...

Power Apps

Unanswered

in operator does not work on mobile offline

(0) Share

Report

Report

Posted on by mertadsay

25

Hello, i am building offline-enabled canvas app and below code working on web player but not working on mobile.

Filter('Project Tasks' As test,
test.Code in Distinct(UserTasksCollection, ProjectTask.Code)
)

I realize that the problem is "in" operator. What can I use instead?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

vaubeee 533 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mertadsay ! Problem is the non-delegable nature of 'in'. You could try combining Filter and LookUp instead. Like so:
Collect( LocalTasks, Filter( 'Project Tasks', LookUp( UserTasksCollection, ProjectTask.Code = 'Project Tasks'.Code ) <> Blank() ) )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question / helped to solve your problem, please accept as solution and give me a Thumbs up. Thanks! - Remember: you can accept more than one post as a solution.
mertadsay 25 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you very much for your reply. This way now works both web and mobile but it gives delegation warning for large datasets.

Filter( 'Project Tasks' As tasks, !IsBlank( LookUp(UserTasksCollection, ProjectTask.Code = tasks.Code) ) )

Any suggestions for getting rid of this delegation warning? Because in production there will be more than 2000 records on these tables.

Join the conversation