CODEWITHSUNDEEP
excelpower-automate
Blowers
Blowers

Reputation: 77

Power Automate Flow is updating excel - want to include formulas

I have a power automate flow that is linked to a microsoft form. Every time a form is submitted the excel is populated with the form data.

The excel is located in a sharepoint folder. This is working fine so far, however i want to include some formulas in the excel, but each time the flow runs, it loads the form data but overwrites the excel formula.

I have a column at the end of the excel with a basic formula =E2 & " " & H2, but this gets overwritten each time the flow runs.

In the flow itself, i tried adding a parameter to load the column with this formula. However when the flow ran, it did populate the formula =E2 & " " & H2, but it was loading row 20, and the formula was populated as =E2 & " " & H2 so i wasnt getting the expected result.

Any ideas how i can store excel formulas, when using forms to load excel? I am aiming to have multiple columns in excel using formulas so I am just looking for the best direction to take.

enter image description here

enter image description here Thanks Blowers

Upvotes: 0

Views: 47

Answers (1)

Skin
Skin

Reputation: 11262

You need to setup the formula in your workbook in that column and it will fill it down for you automagically.

Workbook

Then when you add data to the workbook via the standard Add a row into a table operation, the formula will fill down.

Flow

This is the result ...

Formula Result

Upvotes: 1

Related Questions