cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Power Automate
Power Automate

Re: How to select specific view from SharePoint Online List

This is perfect! I love that it include the manager's information!

 

WOW!

Highlighted
Power Automate
Power Automate

Re: How to select specific view from SharePoint Online List

One of the profile attributes is AccountEnabled. This is coming up 'false' for me - although I do have an Exchange Online email account mailbox.

 

Can you explain the .Account Enabled attribute (what is this related to?? Is that saying that the account does not need to be enabled? (need to be enabled = false)?

Office365Users.UserProfile(InfoAbout.Text).AccountEnabled

Highlighted
Power Participant
Power Participant

Re: How to select specific view from SharePoint Online List

Hi, also coming up 'false' for me.

Not related but interesting: the .Id property seems like a GUID which is the same that is used by CDM to identify the CreatedBy and ModifiedBy user, very useul.

Highlighted
Advocate II
Advocate II

Re: How to select specific view from SharePoint Online List

Ankit, you are a staff member at Microsoft. You've just documented something that will probably help A LOT of people. Maybe add this to the official powerapps document under a section on "how to filter users" or update this (https://powerapps.microsoft.com/en-us/tutorials/show-current-user/) section which you state can sometimes return misleading user data. I can't imagine any practical powerapp application that doesn't in some way filter by the end-user.

 

Furthermore, document how this can be integrated into CDM. Can I compare the 'user' with the createdBy meta-data, can I use the 'user' field to manage row-level security in CDM, how, ... and so on.

Highlighted
Power Apps
Power Apps

Re: How to select specific view from SharePoint Online List

@audrieg - The account enabled flag is supposed to indicate if the account is enabled or not in AAD. I will file a bug to check if the connector is misbehaving. Ideally, it should return the attribute as listed in AAD.

 

@Craig_Debbo - Thanks for your suggestion, we will work on updating the documentation to include this information.

Highlighted
Frequent Visitor

Re: How to select specific view from SharePoint Online List

Hi Ankit Saraf,

 

I got the same issue here,  I have added office 365 user conncetion but I'm not sure how can I add a filter to show the current user items.

 

Thanks,

Venu

Highlighted
Power Apps
Power Apps

Re: How to select specific view from SharePoint Online List

@venusura - are you trying this?

 

The User() function is useful but I have seen instances of the values returned by User() not matching with SharePoint. I have always had better success with the Office365Users connection.

  • Add a connection to Office365 Users in your app
  • Set your filter condition to: Author.Email=Office365Users.MyProfile().Mail
Highlighted
Frequent Visitor

Re: How to select specific view from SharePoint Online List

@sarafankit - Yeah, I couldn't figure out that how can I add  a filter on BrowseScreen but I have managed to get this by the below one.

Items= ShowColumns(Filter('IT Help Desk', User().FullName=Author.DisplayName), "Subject","Title","Created","Detailed_x0020_description_x0020","Author","Business_x0020_impact_x0020_of_x","DateTime_x0020_the_x0020_inciden","Division","How_x0020_many_x0020_users_x0020","Status","Ticket_x0020_Type")

 

much appriciated if you could guide me to try with your suggesstion.

 

Thanks

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,879)