cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OscarBroekman
Advocate I
Advocate I

How to select specific view from SharePoint Online List

We have a SharePoint Online list with orders. Some are open and some are closed. We have a view that only shows the open orders. I would like to connect to that view, but it seems that I can only select the general list, without specifying a specific view. Is that correct? Assuming that is correct, how can I filter just on orders that have a status equal to 'Open'?

17 REPLIES 17

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

 

WOW!

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

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.

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.

@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.

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

@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

@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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,220)