Answered

Flow with calculated item

(0) Share

Report

Posted on by Community Power Pla...

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

All responses (5)

Answers (1)

Verified answer

v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report

Re: Flow with calculated item

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.
Community Power Pla... on at

Like (0)

Report

Re: Flow with calculated item

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..
v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report

Re: Flow with calculated item

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.
Community Power Pla... on at

Like (0)

Report

Re: Flow with calculated item

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. 😞
v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report

Re: Flow with calculated item

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.