Unanswered

Filter JSON

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Power Apps portals

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Fubar Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Fubar Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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)?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Fubar .
Please check the question I have edited it.

Was this reply helpful? Yes No
Fubar Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No