Answered

When writing in excel power automate adds "@"

(0) Share

Report

Posted on by alessa

Hey everyone!

I´m new to Power Automate and am trying to calculate the calender week from a given date in excel. However when writing the formula (in German it´s "=KALENDERWOCHE(D1;21)") power automate (or excel, I´m not sure) adds "@" in between "=" and "KALENDERWOCHE" (in the end it´s: "=@KALENDERWOCHE(D1;21)"). This is causing problems with the flow since I have to click on the field and then somewhere else. After that I´m asked if I want to keep the "@" and after saying yes or no it both works. However I would like to solve this problem without having to let the flow do all that, since there are a lot of fields I want to calculate the calender week for.

Does anyone has a solution?

Thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

dominikmad 104 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried using the "Legt Text aus Zwischenablage fest" (in english: set text to clipboard) function? Set it to the required "whole" string ("=Kalenderwoche(D1;21") and instead of typing it, then, use the function "Ruft Text aus Zwischenablage ab" (in english: pase text from clipboard) to paste it in the correct field. He shouldnt ask you for any formating then.
(so instead of writing the whole thing out, set the clipboard (zwischenablage) to the required text and then paste it in the field)

Also id assume you already do that, but make sure the flow writes the values here instead of here:

Excel likes to be stupid with formatting. If you're lucky that will solve it, if it doesnt, please get back to me and i'll try to help.

Was this reply helpful? Yes No
alessa 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks!

Was this reply helpful? Yes No
alessa 7 on at

Like
a
(0)

Report
Copy link

Link copied!

So I tried your solution copying the text from the clipboard, which works perfectly. Thank you!

I am still curious though. I am using the "In Excel-Arbeitsblatt schreiben" ("Write to excel worksheet") function. I´d assume this writes in the cell and not in the line above you mentioned. Is there another function I can use for that or would I have to position the mouse there and then write?

Was this reply helpful? Yes No
dominikmad 104 on at

Like
a
(1)

Report
Copy link

Link copied!

You could use the "Click on UI Element" function, if its always in the same collums (for example C4 etc.).
"In Excel-Arbeitsblatt schreiben", would be the right way to do it, but there is really no right or wrong. It always depends on the Flow and the end result you want to achieve

Was this reply helpful? Yes No