Answered

Flow with calculated item

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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 excel cell, otherwise it fails.

How can solve my problem? 🤔

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-yiwenxie-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

May I assume that the calculated cell data is divided into 3 types: null, float, integer?

I’ve created a flow as below:

First, check if the column value is empty. If yes, do nothing. If no, go on.

Secondly, check if the column value contains ‘.’. If yes, convert the string into float. If no, convert the string into integer.

Finally, check whether the float or number is less than 90. If yes, send an email. If no, do nothing.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Cell in the excel (Bildirim Kalan Gun) has always a value, it is not empty and doesn't contain "."

I have used int function before but It didnt work.

Problem is related to the formula in the excel cell. If there is no formula flow works when I just write number manually.

I saw the same problem in my other list flow. Flow can not recognize the calculated value in the cell or in the list item. 😞

Was this reply helpful? Yes No
v-yiwenxie-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

I've succeeded in referencing excel cell value calculated from formula as a valid type in Flow.

Could you tell me what kind of formula you have used in the calculated cell?
Is the cell value in excel shown as integer, float or numbers mixed with characters?

Could you show me the screenshot of the error?

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

thank you for response. I got the problem. Problem was related to the date cell format. Somehow float function did not recognize the data. After I changed the dates in different cells into exact date format. And then flow worked. the problem has been solved.

thanks..

Was this reply helpful? Yes No
Verified answer

v-yiwenxie-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

So glad that you found the solution yourself. Would you please consider accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No