web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Power pages filter a c...
Power Pages
Answered

Power pages filter a chart based on current logged in user rather than all users in Contacts table

(0) ShareShare
ReportReport
Posted on by

Hi folks,

 

I need some help on how to filter a pie chart based on current logged in user.

 

Currently I have a view and a pie chart in power apps, and i have successfully put the chart into the power page website by inserting a liquid code like below:

{% chart id:"********" viewid:"*******" %}
 

But the view listed results from all users(Contacts)in the system.

 

What I want is to filter the user(Contacts) based on the current logged in user. My initial thoughts was to add a filter in the liquid code.

Really appreiciate some ideas!!

Categories:
I have the same question (0)
  • Verified answer
    fm_skeller Profile Picture
    277 Moderator on at

    Is the fact that users can see all records correct? If you set entity permissions to allow read access based on the contact record it should automatically filter the view?
    If portal users should be able to view all records - just not in this chart - you could try and add a filter to the view, where you set the contactid to any contactperson - the portal should replace this with the current portal user automatically. I usually create a dummy contactperson 'Active Portal User' to use for this purpose.

  • CU07080733-3 Profile Picture
    on at

    Thanks, really appreciate your help.😁 I managed to do that by simply restricting the corresponding table Access type to contacts access. 

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 52

#2
Valantis Profile Picture

Valantis 46

#3
Vish WR Profile Picture

Vish WR 29

Last 30 days Overall leaderboard