Showing results for 
Search instead for 
Did you mean: 
New Member

Using O365 connector to match against a SharePoint list



I'm new to Power Apps and I am wondering if it's possible for a user to search for themselves (using the Office 365 connector), then once the user has found themselves (the Power App shows their name, department and job title) - can I then use a SharePoint List connector to find a match (Team and Job Title combination) to show the value of a cell in my SharePoint list which tells them what training to book on?


I have been able to connect to O365 and get the users DisplayName, Department and Job Title to appear but I'm now struggling to create a formula in another field that looks at the users Team and JobTitle (from the O365 connector) and cycles through the SharePoint list to find a match and return the cell which holds the Training Course.


Any ideas anybody?


Helpful resources

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.

Users online (4,593)