Power Automate

Flow is suddenly appending a .0 to values from excel.

(1) Share

Report

Posted on by TM-19081817-0

Just as it sounds. The portion of my flow that seems broken is:

Get a Row > Run a condition > set a variable called taskID

Last week, my taskID would pull in just fine:

However, now it seems that a .0 is being appended to the values despite there being no .0 in excel. I also tried changing the data type to "number" and removed the .0 that resulted, but we still have the appended .0 in power automate:

Nothing changed in the data set from excel, so I'm a bit confused. I suppose I could maybe add a compose action to remove the .0 if it's there, but it seems like something changed over the weekend that is now appending this zero. Any ideas?

***UPDATE***

It looks like the break is happening when the "Update a Row" action writes the taskID to excel, see attached. So I guess the question at this point is whether the "Update a Row" action output is coming from excel or if it's something I can tweak within power automate.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

Based on what I saw, the top number is not just different, in that it doesn't have .0 but its actually not the same number all up.

What is the field type in Excel?

I've been seeing lots of issues/call outs on Excel issues lately so just want to see if it fits in there.

Was this reply helpful? Yes No
Suggested answer

Robby_WW 115 on at

Like (0)

Report
Copy link

Link copied!

Hey,

the task ID is to long to be a number in Excel.

you'll have to set your column in excel as text or add ' at the start of your value.

here's a test i did with your taskid value.

Was this reply helpful? Yes No
TM-19081817-0 4 on at

Like (0)

Report
Copy link

Link copied!

**EDIT**
Adding the apostrophe prefix worked. I manually added the apostrophe to my test application entry and re-ran the flow without making any changes to it. The apostrophe is not included when power automate pulls the field from excel. I think the next big question is: what the heck changed from last week to this week?

@Robby: I understand that the digits are too long, but it was working fine last week (first image of my post shows it without the .0). I'll try adding the apostrophe prefix to see what happens, but i suspect I'll need more logic in the flow to then remove the apostrophe, right?

@FLMike: I've been using the "general" data type, but I've also attempted using "text" and "number" data types - each one results in a .0 being appended to the end. Last week, this same flow was running fine, and the data type was "general". Also, when I attempted the "number" data type, I removed all trailing zeros in excel and, for whatever reason, the "Update a Row" action is still adding the .0.

Was this reply helpful? Yes No
Robby_WW 115 on at

Like (0)

Report
Copy link

Link copied!

I was able to replicate your issue when my column in Excel was set as "Standard" and "Number"

However when I put the column on text i had no issue.

So my guess is that some of your cells in your taskid column had different properties. Other then that I have no clue. Good to hear that the apostrophe worked.

to remove it is pretty simple. replace(value,''','')

Was this reply helpful? Yes No