cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iwannabfishn
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!

2 REPLIES 2
jaeiow
Advocate III
Advocate III

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

iwannabfishn
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.

Thanks

Helpful resources

Top Solution Authors
Users online (3,813)