Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages - Power Apps Portals / Filter JSON
Power Pages - Power Apps Portals
Unanswered

Filter JSON

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

Hi All,

I have multiple screens on the portal and I am using multiple JSON scripts for that. My scenario is-

I have one screen suppose A.  I want to check that whether that A screen's data is present/used in other screen or not. How can I do that it will consume less time?

Suppose I have data table A like below which I am using in Screen 1-

Name      Country        GUID                 Date

Ram         India               1                1/1/2021

Sham         India            2                  2/1/2021

Hetal         India               3              3/1/2021


Now, I have different screens where I am using different JSON scripts/ tables/web pages. Suppose I have screen 2. In that I am inserting some data and have Name from table A as dropdown. These data I am dumping in table B.
Consider table B has below data-

ID        Value     Table A Lookup        

0011         1098        1                      

0022         2045        2                      

 

I want to filter the from Table A which is not used in table B. In above case record with GUID 3 is not used, so it should return record with GUID 3. 
Also, please note that there multiple tables from I need to check above condition.

 
   

  • Fubar Profile Picture
    Fubar 8,010 Super User 2025 Season 1 on at
    Re: Filter JSON

    Is the data that you want to base your filtering out on Saved to dataverse? if so, then you don't have to worry about 'screens' - this to me is a Monitor - but depending on what the saves are etc you could still get an issue caused by the Portals data Cache (but it would depend on exactly what was being done).  But you have to have something on the other Web Page that gives you a trigger point 

    • On load of the Web Page you can use FetchXML in Liquid to get the data you need (and could then possibly even use the Web Api - if you do this you can build the whole page rather than having to hack lists or controls)
    • alternatively on some other change or focus or click etc you can call another Web Page via Ajax.  In this case you setup the other Web Page with a custom Web Template behind it so that it returns a JSON object with no header and footer.  You then have to process the returned JSON and filter out the values you do not want - this is where it is not clean particularly if you have more than 1 page of data in what you are trying to filter out (as the standard controls are paginated and you can't readjust the pagination well)
  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Filter JSON

    Hi @Fubar .

    Please check the question I have edited it.

  • Fubar Profile Picture
    Fubar 8,010 Super User 2025 Season 1 on at
    Re: Filter JSON

    So what are you really trying to do - have multiple Web Pages open at the same time? and try and detect what may be on one of the Web Pages (when the data hasn't been saved)? 

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Filter JSON

    HI @Fubar ,

    This is powerapps portal question as I mentioned in the question. I am building a application in which I have multiple screens. you can consider screens as web pages.

  • Fubar Profile Picture
    Fubar 8,010 Super User 2025 Season 1 on at
    Re: Filter JSON

    Is this a Canvas App question rather than a PowerApps Portal question? if so, you will probably have a better response in the Building PowerApps forum

    ('screens' is not a term we use for the PowerApps Portal) 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 1

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 1

#3
surya narayanan Profile Picture

surya narayanan 35

Last month Overall leaderboard

Featured topics

Updates on Power Apps Portals - PLEASE READ

Product updates

Microsoft Power Platform Community release plans