Unanswered

PowerAutomate desktop Writing Formula to Excel

(0) Share

Report

Posted on by Kratos1

Hi,

I am trying to write a data table which contains formula that needs to be added to the excel document and whenever it tries to add the formula I get a pop up window asking to choose an excel file.

Is there a way a data table with formulas can be written without the pop window or a way around this

Formula Examples
"='North 1 - Inverness'!H13" & "=IF(OR(C2<6,C2>18),"Yes","No")"

Thanks

Categories:

Power Automate Desktop

All responses (4)

Answers (0)

Sort by

OkanMTL 703 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If some simple formula also tries to save the file (you can try = 1 + 1), it has probably to do with where your Excel file is connected to.

If it doesn't, the first part "='North 1 - Inverness'!H13" contains one of the next properties where you wanna look deeper into:
Examples
momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kratos1
Try to use semicolon ";" as a delimiter.
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Is 'North 1 - Inverness' another Excel file than the one you are writing into?

If so, check by using the full path of the file in the formula.

If still giving problems, please share complete details of source and destination file, screenshots, etc.
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Please share screenshot of the pop up.