I’m working on a flow that sends automatic email with ticket details when “Status” of an item is changed in MS Lists.
Then the flow should take one of the URLs (which links against a file in SharePoint) available in the corresponding column field in MS Lists which had the status changed to attach a file (Excel, Word or PDF) as attachment (not the URL) in the email to be sent through Outlook.
Can anyone help me which steps and variables I should adopt to:
1 – take from item ID the corresponding URL under specified column in MS Lists
2 – Get file name
3 – Get file content
So then it can be attached in “Send an email (v2)?
NOTE: Flow was developed in Power Automate MS 365 environment not desktop.
Many thanks in advance.
Currently I’m not getting any right steps for the goal here…