You’re offline. This is a read only version of the page.
Hello,
I am still new with Power Automate and have been trying to figure out if it is possible to create an expression to extract the {name} of a file from a SharePoint library and a {link} to the file in the HTML table. We wouldn't want files being attached to the email since there could be over 5 files to be reviewed. It will then send one emailed to each approver of all items assigned to be reviewed.
First attempt I create an automatic HTML Table that provided all columns and metadata including the file {Name} and {Link} but too many other data that is not needed made it look messy.
Second attempt is to create a custom table with the following below, I receive the email but get no data for the Name and haven't attempted grabbing Link since they seem to fall in the same metadata tagging.
| Headers | Expressions |
| ID | item()?['ID'] |
| Name | ????? |
| Approver | item()?['Approver/DisplayName'] |
| Due Date | item()?['DueDate'] |
| Link to file | ????? |
After running the flow and reviewing the 'show raw input' for Create HTML table action shows there are metadata for {Name} and {Link}. Are these able to get extracted into the HTML table? What would the expression be?
Here is a screen shot of my workflow.
Any help or suggestion would be greatly appreciated! Please let me know if I need to provide more information.
Thanks,
ST
hi @SXT maybe ?['{Link}'], you can find a good example here How to add hyperlink in the 'Create HTML table' Power Automate action (tomriha.com)
Share
Report
All responses (
Answers (
8,953
