Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Sharepoint lookup when gathering information during upload

I need a workflow that when it runs, it gathers required information from the user prior to creating the file in documents library. I can do this with a manual flow trigger, but I only seem to be able to gather "text", "yes/no", "File", "email", "number", and "date". I need to gather information from the user that is in a lookup column. This was very easy back in sharepoint 2010. The user would upload a file and sharepoint would ask it for all the meta data including lookup columns and the user would select what they need. I am new at power automate and I can't figure out how to get this functionality using power automate.


I wouldn't need this information if I could force Sharepoint online to gather the meta data during the upload. If there is a way to get sharepoint to gather this data during the upload then that would also fix my problem. 


Thanks for any assistance!

Advocate III
Advocate III

What is your trigger? File created, form upload, etc?

Frequent Visitor

It's a manual trigger with some text fields and a file upload. There doesn't seem to be any way to turn these text fields in the manual trigger to a lookup column. I can create a drop down, but I have to manually create all the drop down items. I need it to pull from a lookup. Alternatively, if there is another way to gather this information from the end user during the upload that would work too. 


Or if I am going at it the wrong way just let me know.


Helpful resources

Top Solution Authors
Users online (3,813)