Regarding the incompatibility of Excel.ReadFromExcel.ReadCell

(0) Share

Report

Posted on by 隆湊-16050834-0

It seems that an incompatibility has occurred with the "Read from Excel worksheet" action in Power Automate for Desktop.
When a flow created with version 2.57 or earlier uses the "Read from Excel worksheet" action, how is it interpreted in version 2.58?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @隆湊-16050834-0,

What is the exact issue your facing.

Regards,

Vishnu Reddy

Was this reply helpful? Yes No
隆湊-16050834-0 9 on at

Like (0)

Report
Copy link

Link copied!
The "Read from Excel worksheet" action corresponds to Excel.ReadFromExcel.ReadCell in the Robin source, but its arguments have changed as follows:

Version 2.57 and earlier:

ReadAsText: False, or

ReadAsText: True

Version 2.58:

GetCellContentsMode: Excel.GetCellContentsMode.TypedValues, or

GetCellContentsMode: Excel.GetCellContentsMode.PlainText, or

GetCellContentsMode: Excel.GetCellContentsMode.FormattedTextValues

When a flow saved to Dataverse in version 2.57 is loaded in version 2.58, it is converted as follows:

ReadAsText: False -> GetCellContentsMode: Excel.GetCellContentsMode.FormattedTextValues

ReadAsText: True -> GetCellContentsMode: Excel.GetCellContentsMode.PlainText

In other words, while values were retrieved as numbers or dates in version 2.57 and earlier, they now appear to be retrieved as text in version 2.58.

Was this reply helpful? Yes No
Suggested answer

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @隆湊-16050834-0,

In the new version of Power Automate Desktop, the “Read from Excel worksheet” action has added an "Advanced" dropdown called "Get cell(s) content as:", with the following three options:
1. Typed values (default)
Meaning: The value is returned in its native data type as Excel interprets it.
Example:

A cell with number 100 → returned as integer

A date like 01/01/2025 → returned as DateTime

A string like Hello → returned as text

Use this when you want to work with actual data types for calculations, conditions, etc.

2. Plain text
Meaning: The cell value is returned as plain text, ignoring formatting or data types.
Example:

Number 100 → "100" (as a string)

Date 01/01/2025 → "01/01/2025"

Currency ₹100.00 → "100"

Use this if you just want to treat all content as raw text (e.g., for logs, file writes, string comparisons).

3. Formatted text values
Meaning: The value is returned as it is displayed in Excel (what the user sees), including any number/date formatting, symbols, etc.
Example:

1000 formatted as currency → "₹1,000.00"

Date 01/01/2025 with format dd-mmm-yyyy → "01-Jan-2025"

Cell with percentage 0.25 formatted as % → "25%"

Use this if your flow needs formatted outputs, like for display in UI, reports, or emails.

Regards,

Vishnu Reddy

Was this reply helpful? Yes No
隆湊-16050834-0 9 on at

Like (0)

Report
Copy link

Link copied!
Hi @VishnuReddy1997

Thanks a lot.

Will we get Text type or other types(such number, datetime), using "3. Formatted text values"?
I also tried it but got the following:

1000 formatted as currency → "1000" (Number type)

Cell with percentage 0.25 formatted as % → "25" (Number type)

Was this reply helpful? Yes No
Suggested answer

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @隆湊-16050834-0,

May be there are few bugs on this as its new but they will fix those . And there is no official documentation yet on this.

Regards,

Vishnu Reddy

Was this reply helpful? Yes No