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

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,232)