Home

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
Yatin Purohit
New 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.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies