Read from custom metadata

Copper Contributor

Hi,

 

In excel I've created a link between a cell and custom properties. 
The value is dynamically updated in  custom properties:

 

01.png

 

How ever it is only created once in the files metadata and it does not update when saving the document or make any changes in the cell. 28,57% was the first value created from the linked cell, the value in the cell has now changed to 14,28 % in custom properties but is not updated in the metadata: 

 

02.png

 

I want it to act the same way as the "Size" does. I want to use the metadata in a column in sharepoint which shows the status in a project:

 

04.png

 

Am I doing it wrong?
Is there any other approach to render a dynamic cell value from a excel document to a column in a document library? (We only use modern UI in Sharepoint Online)

 

Regards,

Emil

0 Replies