Unanswered

Sharepoint Power Automate and Formulas.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,
I am very new to Sharepoint power automate. I am trying to have a formula continue down a column and reference the next rows cells. however in the power automate sharepoint it wont fill downwards whenever a new entry comes in via forms to an excel live document

For example:

I have these 3 columns

C is automatically pre filled via a form, D is =now()

and E is =(D2-C2)*24 to get the total time that has transpired.
However if i put this into sharepoint power automate it only continues to use the cells reference in the formula

is it possible to get the formula to continue down the line? or is this just not possible with this program?

Thanks!

Categories:

General topics

All responses (3)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

You need to refer to the columns by names not cell references. You can build the expression using the Expression builder.
e.g.,
Instead of =now(), try utcnow() in the expression builder.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SudeepGhatakNZ Thanks, i'm not familiar with expression building? I looked through excel and sharepoint powerautomate but unsure where to find this and how to do this.
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

When you click on the field in Power Automate, it pops up on your right.