Is this possible with PP -filtering

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

Just wondering before I try to figure out how, if this is even possible with power pages

I have a text field in a list with a number of company names that are separated by a ;

I would like the logged in use to see only those items on the list where their company name appears in that text field?

I know it's possible in Power Apps but I still don't fully understand the login process for Power Pages and whether I can pull in other info about an authenticated user such as their company name and then map that against a list? but the added complication being the name is in one text field with other names just with the ; separation. However they will match exactly.

TIA

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Christian Leverenz 1,214 on at

Like (0)

Report
Copy link

Link copied!

Hi @vffdd ,

if it was me, i would create either an m-n relation or a table with lookups to account and contact. Then i would write a small plugin, which fills this relation or table with the assigning contactid - accountid (may be its possible via lo/nocode - i am not in that story). (the plugin should of course care for changes 🙂 )

Once this relation is filled, you can use it as tablepermission in portals. For example see all accounts which are ralated to the logged in contact via this relation. I personally prefer using an ~~entity~~table as this could then be used as a parentpermission for many other purposes (like opportunities or orders or whatever somehow refers to accounts)

Hope this helps,

Christian

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thanks Christian

Was this reply helpful? Yes No