Power Platform Community Forum Thread Details

Hi @rr24072020

Use case1:

This is the formula you need to write from PAD into cell C2

Make note of the double percent sign (yellow highlighted below). If this is not done then PAD considers it as its own variable having a percent sign and gives an error.

Once you write this formula into cell C2, then use "Copy Cells from Excel worksheet" action and then "Paste cells to Excel Worksheet".

Basically you need to copy from C2 and paste into C3 so that the formula will automatically get copied and pasted.

Here you have 2 options;

i. Either copy into every single cell from C3 to C9 one by one as mentioned above (in this case you dont need to worry about changing anything in the formula. The Copy paste will do that for you).

ii. OR write a loop that changes the row number in the formula.

Formula for C3 is as follows. Notice in the formula bar $B2 changed to $B3.

If you are writing a loop (option ii. above) then you need to increment the row number inside the loop from B2 to B3, B4.....till B9 (for Peaches) and similarly for A3, A4...till A9.

Use case 2:

This is the formula from the Excel side.

Make sure to use double percent sign %% as mentioned in Use case 1 when writing via PAD.

Once this is done, use either option i. or option ii as mentioned above depending upon your choice.

In the formula bar for $G$9, notice the $ sign before G and before 9. This is because the Total is going to always stay in cell G9. Change $G$9 to as per your own Excel.