I have a document library with text columnPermit_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 columnPermit_No.
Requirement: The value inPertmit_Noshould 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 nameE_PermitNofor the particular cell (formatted as text) which is linked toPermit_No. If I enter a value in Excel in theE_PermitNocell, it updates thePermit_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.