To Bring particular column into Excel.

Mahima Kankriya 1 Reputation point
2023-02-02T13:37:38.78+00:00

Hi,

How to bring specific column data value into Excel file.

I have Excel files uploaded in a document library of SharePoint site. And, I have additionaly added 1 column (Status column) into document library (Refer Image - DemoSitePage).
Next time when I will open Excel file from SharePoint, I need that "Status column" value to be present inside the excel file anywhere.

Please help me out !!

How Can I add column value into Excel file??

Thanks !!

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,729 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,685 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Haoyan Xue_MSFT 20,186 Reputation points Microsoft Vendor
    2023-02-03T08:56:41.8733333+00:00

    Hi @Mahima Kankriya ,

    I have carefully read your requirements. You want to automatically put the contents of the status column of this file in the document library anywhere in the excel file every time you open the excel file located in the sharepoint library.

    Per my knowledge, you can achieve this function through Power Automate.

    In fact we are currently providing help on SharePoint in the Q&A forum, and Power Automate is a product independent of SharePoint which we are not so familiar with. Regarding the difference between these two methods which is more related to Flow, we would recommend that you go to the forum dedicated to flow for more professional help, there will be very professional people to solve the problem for you quickly:

    Microsoft Power Automate Community

    Thanks for your support and understanding.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.