web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter data table

Power Apps

Answered

Filter data table

(0) Share

Report

Report

Posted on by portalweb

23

Hey,

I have a data table connected to CDS Users.

In this data table i have an attribute "Windows live ID".

I want to filter this particular column such that "Windows live id" = xxxxxxxxx@hp.com

other data like : xxxxxxxx@HP.onmicrosoft.com should not be present in this column.

Please help!

Thank you

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@portalweb

Try this code in the Items property of the data table. It will exclude any emails ending in onmicrosoft.com.

Filter(your_datasource_name, !(“onmicrosoft.com” in ‘Windows Live ID’))

---
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."
Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

If you want to ONLY show items that end with @hp.com, you can use the EndsWith function:

Filter(DataSource, EndsWith( 'Windows Live ID', "@hp.com" ) );

This will only show entries that end with that specific text,

@mdevaney 's idea will also work, however the caveat to that is if you have any other addresses on there that arent hp.com and arent onmicrosoft.com then it will show those too 🙂

Cheers,

Sancho

Join the conversation