Share via

A function to hide long text with a short text and can be readable in the excel file

Gal30 0 Reputation points
2023-03-09T11:19:01.56+00:00

I have a long sentence in an excel heading and need to create a flow in power automate using the excel template in a get file content action. My problem is that Power automate cannot recognise long sentences, so I need a function in Excel that I can add a long text and hide it under a short text in the excel so that my flow can see the short text and use the short text in an array, but when the file is created using flow- the long sentence can be unhide in the excel produced by Power automate flow.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor
    2023-03-10T08:08:08.5733333+00:00

    Hi,

    Are you looking for the HYPERLINK function?

    User's image

    Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    If the response is helpful, please click "Accept Answer" and upvote it.

    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.

    0 comments