Error while process excel file using power automate

(0) Share

Report

Posted on by Binni

Hi team,

I am getting below error while running flow.:

--- Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template function 'base64ToStringoutputs' is not defined or not valid.'.

In the above compose I am passing expression as : base64ToStringoutputs('Get_file_content_using_path')?['body']['$content']

I am processing excel file in that only 3 columns ,trying to get the data in content but showing above error.

New to Power Automate. Helps me a lot. Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

jinivthakkar 4,187 on at

Like (1)

Report
Copy link

Link copied!

@Binni for you to read excel content you should be using List rows present in a table action, refer below link

https://docs.microsoft.com/en-us/azure/cognitive-services/language-service/named-entity-recognition/tutorials/extract-excel-information

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Binni 3 on at

Like (0)

Report
Copy link

Link copied!

@jinivthakkar Thanks for helping . I am trying to get the column details (header name) which is present in my excel file. Any help here.

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Binni if you use the List rows present in a table action, it will give you the headers ? I think you did not check the blog url, check this video https://www.youtube.com/watch?v=rPaJVdx_k2E

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No