Hi @PabloGuerra
There must be a Dynamic Output/Body property associated after it runs. Please read the below and feel free to share pictures as you need help etc.
Just to test this, add a Compose after the above step to get the data. In the Compose, click the Input box, when the Popup Windows Appears, in the Dynamic Content scroll so you can see the Call SAP function (V2) Section and you should see something like
body
outputs
value
something like the above. That will be the Output of the Action.
Now here is the important part. There is a difference between getting the body of the Action and getting the values of the Rows.
As an Example: when you use Get Items for SharePoint, you can see body and value as Dynamic Content properties. Body is actually a JSON that has ALL the output from the Get Items, where-as the value is the JSON property that has the actual row data, so we need to find the one that matches that in the Dynamic Content properties for Call SAP Function (V2)
Now once you have that, you can easily either
A) use Create HTML Table, and pass in the (proper JSON parameter from the Call SAP Function (V2)) and it should make an nice table in the Email. But it could be very large.
B) Use the Create File (SharePoint) or Create File(OneDrive) to create a new file. You would pick the location in the Action, you would pick the Folder etc. And you would supply the Content which again, is the value or other property from the Call SAP Function (V2) step.
--After using Create File, that action will have a property for Content we want to use that as an Attachment in our Email.
--Use Send Email V(2) or (V3 if its there).
In the Email To: fill that out,
Fill out the Subject
Now in the Body
--If you used the Create HTML Table, then you would want to put ITS Dynamic Content output here in the table
--If you used Option B and want to attach it, then you would click Advanced options for the email. In the Attachment Name give it a name, in the Content, use the Dynamic Content property probably called Content or File Content, from either your SharePoint or OneDrive create file.
And bingo done.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
