Answered

Adding a "@" in formula, while using Write to excel worksheet

(0) Share

Report

Posted on by dprost

I am creating a flow that will open a excel sheet, create a new worksheet, then put in a formula into a cell.

The formula is a filter function "=FILTER('027-028 Min - Max'!D7:R114,'027-028 Min - Max'!O7:O114>0,"none")" that will output a table when working correctly.

For some reason the write to excel worksheet action adds a "@" symbol to the excel formula. ref below.

Am I using this incorrectly? Is there a possible workaround for this?

Categories:

Power Automate Desktop

All responses (4)

Answers (1)

Sort by

WillSG 352 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dprost I hope you are doing well.

That @ is part of Excel actually and the new Dynamics (which is not that new Hehe).

Basically, what the @ means to the Filter formula is to only return one value of the Dynamic Array formula.

The same will happen with =sum, =index, etc.

You can read more here in this MS link,

https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34

Hope this helps,

If I have addressed your inquiry successfully, kindly consider marking my response as the preferred solution. If you found my assistance helpful, a 'Thumbs Up' would be greatly appreciated.

Additionally, if you have any questions, please feel free to DM me, and we can initiate a discussion.

Kind regards,

Will SG

Managing Director & Automation Lead

RAMS CR (Recruitment & Automation)

LinkedIn Profile
SeanLin 55 on at

Like
a
(0)

Report
Copy link

Link copied!

If I were you, I'll try to use Excel build-in function to setup the whole formula in stead of using "Write to Excel worksheet". It costs more steps but less problem.
Verified answer

AdyG 50 on at

Like
a
(2)

Report
Copy link

Link copied!

Hello @dprost,

I encountered the same problem and while looking for the solution, came across this post of yours.
I just tried the below and it worked for me-

Please try adding the formula via send keys. Even if you have to pass the variables, go ahead.
My formula required variables from previous actions and I passed them and it worked for me.
Don't forget to click 'Enter' via Send Keys like in last step.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks.
mer5 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I had a similar problem and this worked for me!