Unanswered

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

(0) Share

Report

Posted on by bala11

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.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bala11,

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.

Was this reply helpful? Yes No
bala11 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bala11,

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

Not sure how you configure the excel table.

Was this reply helpful? Yes No