Updating Excel cell from SharePoint Column

%3CLINGO-SUB%20id%3D%22lingo-sub-842101%22%20slang%3D%22en-US%22%3EUpdating%20Excel%20cell%20from%20SharePoint%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842101%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20document%20library%20with%20text%20column%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPermit_No%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E(for%20permit%20number).%20When%20a%20new%20permit%20file%20is%20uploaded%20(Excel%20file%20based%20on%20template)%2C%20Microsoft%20Flow%20generates%20a%20unique%20Permit%20Number%20and%20updates%20the%20SharePoint%20column%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPermit_No%3C%2FSTRONG%3E.%3CBR%20%2F%3E%3CBR%20%2F%3ERequirement%3A%20The%20value%20in%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPertmit_No%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Eshould%20be%20linked%20%2F%20synced%20to%20a%20cell%20in%20the%20Excel%20file.%20This%20cell%20is%20the%20place%20for%20the%20Permit%20Number%20in%20the%20template%20%2F%20form.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20know%20you%20can%20link%20cells%20from%20Excel%20to%20SharePoint%20columns%20using%20advance%20properties.%20When%20a%20SharePoint%20column%20name%20is%20linked%20to%20Defined%20name%20(for%20a%20cell)%20in%20Excel%20advance%20properties%20tab%2C%20on%20uploading%20the%20file%2C%20the%20value%20from%20Excel%20automatically%20flows%20to%20the%20SharePoint%20column%20value.%20In%20my%20case%20I%20have%20a%20defined%20name%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EE_PermitNo%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Efor%20the%20particular%20cell%20(formatted%20as%20text)%20which%20is%20linked%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPermit_No%3C%2FSTRONG%3E.%20If%20I%20enter%20a%20value%20in%20Excel%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EE_PermitNo%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ecell%2C%20it%20updates%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPermit_No%3C%2FSTRONG%3E%26nbsp%3Bcolumn%20in%20SharePoint%20when%20uploaded.%26nbsp%3BHowever%2C%20reverse%20does%20not%20work.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20avoid%20Macros%20as%20it%20is%20not%20supported%20on%20iOS%20%2F%20Android%20and%20the%20file%20will%20not%20open%20for%20the%20reviewers%20and%20approvers%20of%20the%20permit.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EAppreciate%20any%20ideas%20on%20how%20to%20resolve%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842101%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-843095%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20Excel%20cell%20from%20SharePoint%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843095%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F163964%22%20target%3D%22_blank%22%3E%40Yatin%20Purohit%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eideally%2C%20the%20custom%20column%20in%20SharePoint%20should%20be%20part%20of%20a%20Content%20Type%20and%20the%20Excel%20workbook%20should%20be%20using%20that%20content%20type%2C%20to%20ensure%20that%20all%20the%20custom%20columns%20are%20showing.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20you%20open%20the%20file%20in%20Excel%20and%20go%20to%20File%20%26gt%3B%20Info%20%26gt%3B%20Properties%20dropdown%20%26gt%3B%20Advanced%20Properties%20%26gt%3B%20Custom%20tab.%20Here%2C%20find%20the%20custom%20column%20and%20tick%20the%20box%20to%20%22Link%20to%20content%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787751%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20Excel%20cell%20from%20SharePoint%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787751%22%20slang%3D%22en-US%22%3EHey%20Yatin%2C%20I%20am%20looking%20to%20do%20something%20similar%2C%20have%20you%20found%20a%20solution%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a document library with text column Permit_No (for permit number). When a new permit file is uploaded (Excel file based on template), Microsoft Flow generates a unique Permit Number and updates the SharePoint column Permit_No.

Requirement: The value in Pertmit_No should be linked / synced to a cell in the Excel file. This cell is the place for the Permit Number in the template / form. 

I know you can link cells from Excel to SharePoint columns using advance properties. When a SharePoint column name is linked to Defined name (for a cell) in Excel advance properties tab, on uploading the file, the value from Excel automatically flows to the SharePoint column value. In my case I have a defined name E_PermitNo for the particular cell (formatted as text) which is linked to Permit_No. If I enter a value in Excel in the E_PermitNo cell, it updates the Permit_No column in SharePoint when uploaded. However, reverse does not work. 

I want to avoid Macros as it is not supported on iOS / Android and the file will not open for the reviewers and approvers of the permit.

 

 Appreciate any ideas on how to resolve this.

1 Reply
Highlighted
Hey Yatin, I am looking to do something similar, have you found a solution?