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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (5,212)