Filtering the data table based on a global variable

(0) Share

Report

Posted on by Aysan

271

Hi,

As a newbie in powerapps , I am working on a POC . I have 2 data sources connected to my app. I have a globalVar created and can see the variable in the detail page, I need to filter the datatable ( which is connected to 2nd data source) based on the variable, How can I show the value in Datatable3 where the external _id =globalvar

Would anyone please help me to figure the best way to achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@Aysan

For Datatable3's Items property, try using following formula:

Filter(<data source for the table>,external _id =globalvar)

Please check the above formula and provide your observation or questions here.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

Aysan 271 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Krishna,
Thanks for your response, I am not sure why I can't get the filter to work, the following screenshot shows the data table when I select item=

but when I try to Filter by name ( to make it simple) it doesn't work

Thank you!

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Aysan ,

Filter could not work because there was space after "Global", I suppose.

Please try below and check the result:
Filter(organizations,StartsWith(name,"T-Mobile"))

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No