Is it posiible to fill columns in SharePoint library based on SharePoint list or excel where key is file name?

The situation: I upload 200 Excel files each month to SharePoint online library. I need to sort and group them by value in added columns. I add this value manually. I would like to fill this columns automatically. I have Excel file and SharePoint online list with needed information. The key is file name.

I tried to:

  • build lookup column on SharePoint List but I have to manually chose item from the list for each row;
  • build power automate but it works with list not with library;

I will be grateful for your support Michal

1 Answer 1


Whether you want to fill SharePoint Metadata with Excel File Values on Upload using flow?

If true, please refer to https://blog.ion.works/2020/04/01/scenario-fill-sharepoint-metadata-with-excel-file-values-on-upload-with-power-automate/

  • Link does not work anymore.
    – Popkornak
    Nov 20, 2020 at 12:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.