Flow

[Anonymous]

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? 🤔

[PrasadAthalye]

@Anonymous  - Can you please add your flow picture and provide more details where exactly failure is occurring?

[Anonymous]

the formula in the cell (Bildirim Kalan Gün)

"=[@[Bitiş Tarihi]]-[@TODAY]"  

[Anonymous]

[PrasadAthalye]

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.

[Anonymous]

"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"

[PrasadAthalye]

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?

[Anonymous]

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". 

[PrasadAthalye]

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?

[Anonymous]

Hi,

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? 

[PrasadAthalye · Accepted solution]

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?

[Anonymous]

Hi PrasadAthalye

I got the problem. Date data is the problem.  Although I changed them into date format in the cells it doesn't work. 

 I collected the dates from another source in the web for my original excel file.  The date data format fails for float function.  When I compose a new excel file with manually written dates (not copying from somewhere) , the flow works.

[Anonymous]

Hi again

I solved the problem 🙂 

I changed the date data format into date by two stages. Firstly I divided the date  into day, month and year in three cells. And then I used the function date (year;mm;dd)  to compose a date format in another cell. It worked 🙂 

thank you very much.. 

[amort118]

Trying to figure out how to copy form results into specific cells in an excel template i created. I would then PDF the completed template and email to respective people.

Struggling with the first part.