You’re offline. This is a read only version of the page.
Hello to all of you,
I try very hard on this problem but really can't find a solution. The problem:
I have a FORMS document and save the results via POWERAUTOMATE to a table in an EXCEL document. No problems at all.
I get the answers as DYNAMIC CONTENT and send them via POWERAUTOMATE as an E-Mail. No problem at all, too.
But if I use a function in Excel to create new values, pick the item via DYNAMIC CONTENT and send it via Mail, the item can't be seen in the Mail. There is absolute nothing.
In my example I calculate a fee for borrowing books. I know exactly how much books were borought, let the number be "a". And I know exactly the fee for each book, let the number be "b". I then multiply the numbers in excel by a function and get a result.
When I pck this result as DYNAMIC CONTENT in POWERAUTOMATE to send it via Mail, the position, where the result should be seen is empty. There is absolutely nothing.
Is anybody in here able to help me?
Best wishes,
Stefan
@v-alzhan-msft
I format the outcome as text. Maybe thats why it works.
@edgonzales
IT WORKS!!! HEUREKA!!!
Thank you so much! The issue was the "get row"-part. I didn't used that. Your hint helped very much. And now it is working.
As row-ID I use the timestamp I got from FORMS.
@v-alzhan-msft
Hmm, but I now can use the outcome of the function for sending it via mail...
Best wishes to both of you!
Hi @Anonymous ,
Sorry for Microsoft flow couldn't work with excel table that has math function in the column currently.
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Ok, looks great. The steps above are Add a Row and Get a Row, respectively, right?
Can you open up the Get a row step, specifically what you're using as the Row ID? The other thing we should look at is the past runs (not in edit mode) to make sure the data is making it through.
Thanks!
-Ed
Hello Ed,
here are some pictures:
This is my flow (Sorry, its german):
And here is the part, that sends a Mail:
This is a part of my excel table:
(its only test content...)
I do the math also in Excel. Here is the important part of the table:
"Anzahl Leihexemplare" means the number of books borrowed, "Leihgebühr" means fee. The fee for every book is 3€ but you don't have to pay more than 27€. That's why I use this "if-condition".
Here is a bigger picture of the Mail part from my flow:
You see, I pick the "Leihgebühr" (=fee) with dynamic content.
And here is the Mail I recieve:
By the way:
the dynamic content for "Arbeitshefte und Materialien" (workbooks and other stuff needed) "alle Kaufexemplare" (all books someone buys) and "alle Leihexemplare" (all books someone borrows) is also empty in the Mail. Here I use a "concat"-function (german Textkette).
Here you can see it:
The funny part: If I copy AA7 via ctr+c and paste it for example in Word everything is fine.
Therefore I think it is possible to get the outcome of an excel-function and copy it elsewhere.
Thank you very much for your help.
Best wishes,
Stefan Garthoff
@Anonymous
Hi there. Could you post a pic of the most recent run? Clicking on the actions going in and out of the spreadsheet will help us make sure the math is happening and it's at least hitting the sheet, right.
Are 'a' and 'b' already in Power Automate? We could also do the math there using mul() and a compose.
Keep us posted.
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (