
So, I'm creating a flow so that once we receive a MS form, it adds a row into an excel, triggers an approval and if approved sends out an email. The problem that I'm having is with the email itself: I need to include in text format information that comes from the excel but that the approver is adding, not the form. Insofar the flow works but it's only the email bit that's coming without the information, even for the subject.
I'm having a minor secondary issue that the file that I want to add as an attachment is a PDF but it is coming in a weird format and people need to choose to open as PDF.
the other threads that i've found mostly talk about creating a variable and then creating a table to be sent in the body, but that's not what I'd like.
I'd be grateful for any advise.
Dear D,
To me what you want to achieve/do with the flow seems perfectly reasonable and within what is possible.
There is however something I do not understand. What is the source of the text you want to add in the email, where does it reside?
You mention "comes from the excel but that the approver is adding, not the form.", but this seems ambiguous.
It sounds like you want to include the comments which come with the approval action, but I do not see any data elements from the approval action in your email (hence possibly what it is not included).
As said, your flow seems simple enough, when you figure out where the data is you want to add, you should solve your problem.
Happy flowing,
Koen