SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,555 questions
How to import excel to sharepoint list which one column in list is defined as lookup type?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 99%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZW%3C/text%3E%3C/svg%3E)
Zhao, Wenyan (SGRE COG QM&HSE QMPS SE DI&A)
6
Reputation points
I have a excel list in the SP folder, and now the request is to import the excel rows to a SP list when the file is modified,
The problem now is:
the lookup column in the list cannot be imported well when I choose the excel column when doing the flow. It need the id, but I am not sure which ID is needed?
Is there any solution？
Thanks a lot.
{count} votes
-
Emily Hua-MSFT 27,526 Reputation points2022-02-22T01:33:44.483+00:00 Hi @Zhao, Wenyan (SGRE COG QM&HSE QMPS SE DI&A)
As this issue is more related to SharePoint, to help you better, I would change the tags.
Thanks for your understanding. -
Yi Lu_MSFT 17,456 Reputation points2022-02-22T10:02:10.92+00:00 Hi @Zhao, Wenyan (SGRE COG QM&HSE QMPS SE DI&A)
Could you please provide some screenshot to let me see how does your flow work? How do you create the list, is it based on excel? -
Yi Lu_MSFT 17,456 Reputation points
2022-03-08T02:46:31.343+00:00 Hi @Zhao, Wenyan (SGRE COG QM&HSE QMPS SE DI&A)
Would you please provide some update of this issue? Please feel free to reply.
Sign in to comment