cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Flow

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

1 ACCEPTED SOLUTION

Accepted Solutions

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?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

13 REPLIES 13
PrasadAthalye
Super User
Super User

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

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable

husthebest_1-1611745575749.png

 

husthebest_2-1611745627540.png

 

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

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

Anonymous
Not applicable

flow .jpg

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.

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable



"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"flow 3.jpg

 

 

 

 

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?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable

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

 

flow 4.jpg

 

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

 

PrasadAthalye_0-1611942669535.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable

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? 

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?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable

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
Not applicable

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
New Member

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.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,145)