web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Why do I need to use T...

Power Apps

Unanswered

Why do I need to use Text() function to succesfully filter?

(0) Share

Report

Report

Posted on by mrpowergage

234

I'm filtering a custom table to show just the rows (Tasks) which are related to the current selected project.

This works

Filter(Tasks,Text(AsType('Client (Regarding)','Projects / Services').Project)=Text(selectedProject.Project)

This (with the Text() function removed from both sides) doesn't

Filter(Tasks,AsType('Client (Regarding)','Projects / Services').Project=selectedProject.Project

Anyone any ideas why? The reason it's an issue is that with the Text function I get a delegation warning. Any thoughts or solutions apprecited.

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mrpowergage ,

What's the data type of project?

And If your data volume is less than 2000, you don’t have to worry about delegation.

Best Regards,

Wearsky
mrpowergage 234 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-xiaochen-msft Wearsky

project is a GUID
data will be over 2000 at some point when in production
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mrpowergage ,

I did a test for you . But i didn't encounter your problem.

I directly compared guid instead of text.

Best Regards,

Wearsky

Join the conversation