Excel row with formula adding to sharepoint list not updating the formula based cells

Like (0) Share

Report

Posted on 25 Jul 2021 05:40:56 by kapiljarial

Hi,

i am trying to update excel to sharepoint list, everything is working fine except one thing and that is formula in my excel ( =today()-(a specificDate) which is in number format which i want to update in sharepoint list but the value which create item is picking is older date value not the current date value

eg- with formula- = today()-(23-07-2021) = 2 -------- Lets take this (A)

and =latest is =today()-(24-07-2021) =1 -------- Lets take this (B)

when is create item in list from excel then B is not getting updated and only A value is getting updated daily but i want daily value should be updated as my flow runs daily.

Anyone can help me out with this

All responses (1)

Answers (0)

v-bofeng-msft on 27 Jul 2021 at 03:26:41

Like (0)

Report
Re: Excel row with formula adding to sharepoint list not updating the formula based cells

Hi @kapiljarial :

Could you please sharing more details?Something like:

The screenshot of your flow

Your SharePoint list

The screenshot of your Excel table

Best Regards,

Bof