0

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

Improve this question

1 Answer 1

Reset to default
0

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/

Improve this answer
1
  • Link does not work anymore. Commented Nov 20, 2020 at 12:05

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.