Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Search for the keyword in the file getting from GET FILE CONTENTS USING PATH

(0) ShareShare
ReportReport
Posted on by 2

I have the URL to get the Excel file content I used  GET FILE CONTENT USING PATH action when I run the flow I am getting Object file ( CONTENT TYPE and CONTENT ). But I need to search the keyword in the file.

 

I tried parsing the output from get file content using path but getting error that the output was in Object format.

For understanding I am sharing the screenshot of input and output.

 

Compose 3 contains the URL where we can get file.

In the output we are getting Object file. As per the screenshot I want to know what the next action is better to get the data from the file I can able to search the keyword.

Thanks in advance.

  • AlexEncodian Profile Picture
    AlexEncodian 4,298 on at
    Re: Search for the keyword in the file getting from GET FILE CONTENTS USING PATH

    @bala11 

    If you dont have an Excel table in your Excel file, you can read the data using Encodian's Get Rows from Excel action. Works without tables.

  • Re: Search for the keyword in the file getting from GET FILE CONTENTS USING PATH

    Hi @bala11,

    Well, only a formatted table could be read in SP document library.

    Not sure how you configure the excel table.

  • bala11 Profile Picture
    bala11 2 on at
    Re: Search for the keyword in the file getting from GET FILE CONTENTS USING PATH

    Thanks for reply 

    For using List Rows Present In a Table I didn't have table name and it is from share point-documents folder, That's the reason why I used Get File Content Using Path with that atleast I can get the file.

     

    I have URL with me, so any action instead of Get File Content Using Path suggestions is fine .

     

    Can I know any other approach the that my issue will be resolved. 

  • Re: Search for the keyword in the file getting from GET FILE CONTENTS USING PATH

    Hi @bala11,

    vqiaqimsft_0-1710999847638.png

    I want to explain to you, that GET FILE CONTENT USING PATH is not for retrieving the data within the excel table, but getting an Excel file with an internal structure that is not readable by us, getting its result in base64.

     

    If we use this action to get a text file or csv, we won’t get it as a base64 file, but we’ll get its contents.

     

    If you want to read the file data, you need to use the List rows present in a table, which will get you rows of an excel table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics