Hi
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?
