Hello,
Making my flow, I am using apply to each and float function. If the calculated cell data is less than 90 days it sends an email.
Unfortunately It works if there is no formula in the cell, otherwise it fails.
How can solve my problem? 🤔
@Anonymous - Can you please add your flow picture and provide more details where exactly failure is occurring?
the formula in the cell (Bildirim Kalan Gün)
"=[@[Bitiş Tarihi]]-[@TODAY]"
It appears that the value in [Bitiş Tarihi] is not in a date format and whenever that happens it can not subtract and output can not be converted to float.
Can you please check the value in [Bitiş Tarihi] and tell me what is the value when it fails? Also what values do you expect? Can the cell be empty? If a cell has some data, can the cell have text or just numbers?
Based on this, we will have to add validation before running float on it.
"BILDIRIM KALAN GUN" CELL FORMULA =[@[BITIS TARIHI]]-[@TODAY]
My calculation works in the excel. The problem is flow does not recognize the data.
Column format is "number"
I am unable to see clearly but It appears that you have a comma as a decimal separator in excel. Is that true? Can you please change it to period if it is a comma and test?
Hi,
I checked the value of [Bitiş Tarihi]. It is in date format. My formula works actually in the excel. It calculates difference between two dates. The problem is the flow can not float the value in the "Bildirim Kalan Gun" cell.
When I erase the formula in the cell and just paste the data manually, the flow works. It means if there is a just number without any calculation in the cell it works. Otherwise it doesnt.. 😞
"Bildirim Kalan Gun" cell format is "number".
I did a similar test and My flow worked fine. Can you tell me if this file is getting updated from somewhere just before flow runs? Also, can you use the attached short file and see if you can read difference column and convert it to float?
The excel file that the flow takes the data is not updated. There are two formulas in two cells. One is Today() formula that calculates today and the other one calculates the difference between two dates. (expirydate - today date = result)
I realized that the problem comes from date difference value. Although cell format is number, the flow doesn't understand the calculation value as a number. I checked the same calculation formula between two cells that contain just numbers no date. (for example I calculated the difference between 32-12 = 20 in the cell of 'Bildirim Kalan Gun'. The flow recognized 20 number and it worked.
Firstly, the sample you sent me is similar to mine. Date formats are the same and calculation cell format is number and finally formula is the same Cell 1 - Cell 2 = Result.
Secondly should I write "initialize variable" before the the list rows present in table step?
No. I am using variables just for testing purposes. I see that your number columns show a green tip on each cell. Can you check why that is appearing?
Can you send me your excel data mocked for 2 rows and maybe just those 3 or 4 columns?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tomac 497 Moderator
Michael E. Gernaey 477 Super User 2025 Season 2
chiaraalina 242
