Home

Read from custom metadata

%3CLINGO-SUB%20id%3D%22lingo-sub-207806%22%20slang%3D%22en-US%22%3ERead%20from%20custom%20metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-207806%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20excel%20I've%20created%20a%20link%20between%20a%20cell%20and%20custom%20properties.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3EThe%20value%20is%20dynamically%20updated%20in%26nbsp%3B%20custom%20properties%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20381px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F36651iA006E57DB4724348%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%2201.png%22%20title%3D%2201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20ever%20it%20is%20only%20created%20once%20in%20the%20files%20metadata%20and%20it%20does%20not%20update%20when%20saving%20the%20document%20or%20make%20any%20changes%20in%20the%20cell.%2028%2C57%25%20was%20the%20first%20value%20created%20from%20the%20linked%20cell%2C%20the%20value%20in%20the%20cell%20has%20now%20changed%20to%2014%2C28%20%25%20in%20custom%20properties%20but%20is%20not%20updated%20in%20the%20metadata%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20758px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F36652iCADA4F8BDD3430FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%2202.png%22%20title%3D%2202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20it%20to%20act%20the%20same%20way%20as%20the%20%22Size%22%20does.%20I%20want%20to%20use%20the%20metadata%20in%20a%20column%20in%20sharepoint%20which%20shows%20the%20status%20in%20a%20project%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F36654i285534781EE53F45%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%2204.png%22%20title%3D%2204.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20doing%20it%20wrong%3F%3CBR%20%2F%3EIs%20there%20any%20other%20approach%20to%20render%20a%20dynamic%20cell%20value%20from%20a%20excel%20document%20to%20a%20column%20in%20a%20document%20library%3F%20(We%20only%20use%20modern%20UI%20in%20Sharepoint%20Online)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EEmil%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-207806%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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

Related Conversations