I have a document library in which there are different folders which contains excel files. Excel file has name SA_0012ABCD_201901_Report. So here the 0012 is the folder name. So we Match the excel file name with the folder name and move them inside folders using flow. After that the properties needs to be filled to the columns. The excel file inside contains a cell which has value of amount. That cell value need to be updated to the Column Amount outside. So whenever a file is uploaded, the excel cell value k39 needs to be updated to the column amount of the list. I want this to be done using a Power Automate flow.
I'm providing a Power Automate sample that can be used to do:
- Read value from a cell in the Excel file uploaded to a SPO library
- In order to read values from an Excel file in Power Automate, the Excel file needs to have a table. The Power Automate first checks for a Table (Table1), if it doesn't find it, it creates it for a specific range containing the data.
- Update Document meta data, in this case, [Amount], with the value read from the Excel Cell.
- To avoid File Locked For Shared Use for recently created files in SPO library, a delay mechanism implemented when updating the meta data of the excel file. You can read details at here
Row Excel File
MS Flow (Power Automate)
outputs('List_rows_present_in_a_table')?['body/value']?['K'] Note: Table Rows' index starts at 0 and header row is deducted. (39-2)=37, the desired row index. ['K'] is column header (property name).