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

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 / viewing specific data ...
Power Pages
Unanswered

viewing specific data to the specific user

(0) ShareShare
ReportReport
Posted on by chahineatallah1 249

Hello

I have an app for internal shopping of employees

 

So basically when an employee places an order, there is ordereditems table in dataverse, with a column named full name, which is basically taking info from function user().fullname

Now i want to make a power page where the user can view only his orders, as i understood in power pages we have only contacts which gives user info

But my dataverse doesnt have any relationship with contacts, so how to solve this issue? to connect full name column from ordered items table to contacts, as the full name is populated only when order is placed

 

Thanks

Categories:
Security
I have the same question (0)
  • alaabitar Profile Picture
    alaabitar 1,503 Super User 2024 Season 1 on at

    Hey @chahineatallah1 

    If in your power page you want to only show order for the current user you could just do a filtering on the orderreditems tables with fullname = user().fullname

  • Saud Ali Profile Picture
    Saud Ali 812 Super User 2024 Season 1 on at

    Hi @chahineatallah1 ,

     

    First of all, if you want to stay with the same model that you have designed then you could just do a filtering on the orderreditems table with fullname = user().fullname as suggested by @alaabitar.

     

    But on other I would suggest you to bind your orders to contact (lookup) instead of creating a text field and set it by using user().fullname. If you can do this, then you don't need to apply additional filtrations and you can manage data accessibility based on Power Pages table permissions.

     

    For more information you can visit following links:

    Power Pages | Page Security & Power Pages | Table Permissions 

     

    Thanks,

    Saud

     

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
sannavajjala87 Profile Picture

sannavajjala87 38 Super User 2026 Season 1

#2
Valantis Profile Picture

Valantis 37

#3
Fubar Profile Picture

Fubar 23 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans