Forum Discussion
ConnieMaldonado
Apr 04, 2022Copper Contributor
Lookup data based on user input either from SQL table to Sharepoint List
Hello! New to Microsoft Forms. I feel like it's been asked a million times, but I can't find a definitive answer, so here goes. I need to create a Microsoft Form that will be completed by technici...
RobElliott
Apr 05, 2022Silver Contributor
ConnieMaldonado the definitive answer is that there is no way in standard Mi9crosoft Forms to lookup and/or pre-populate data in the form. Whether that can be done with Customer Voice, the old Forms Pro, I don't know.
You're rabsolutely ight that you can do this with a canvas app in Power Apps. It has the Office 365 Users connector which you add to the app so it knows who the current logged in user is and can therefore look up and display data related to that user. So that's always the approach I would take in your scenario.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)