Hi,
I have set up a flow that sends an email to a user when they create an item in a list.
I am trying to have the email attach a file based on parameters within one of the fields.
e.g. if (listA-Column"Tool value" =v6), then (attach v6Tool), else (attach v7 tool)
The attachment appeasr to allow for an expression but not sure how I get that expression to point to th list or column etc.
Regards
Andrew
Solved! Go to Solution.
Hi @AndrewWilson911 ,
If it is a file stored in the SharePoint Library, use Get file metadata using path and Get file content using path to get the file content and file name.
Can't you view the screenshots I provided?
Best Regards,
Hi @AndrewWilson911 ,
Could you provide more details about the menu value of Tool value? Type and more.
In addition, the attachment you mentioned is stored, SharePoint Library or OneDrive?
Suppose the type of column you mentioned is single line of text, and the file is stored in the SharePoint library. Please refer to the screenshot below to configure Flow.
Image reference:
Best Regards,
I think this looks really helpful!
The values in the column will be either 'AMEM v6.0' or 'AMEM v7.0'
I assume I can then just use either one for the 'is equal to' conditon
do I need both metadata and content to return the file to enable it to be sent?
Thanks for your help
Hi @AndrewWilson911 ,
Yes, we need File display name and file content.
Best Regards,
sorry so if full link to file is:
and filename is:
AMEM v6.0 (organisation name - version number).xls
which parts do I put where?
Hi @AndrewWilson911 ,
If it is a file stored in the SharePoint Library, use Get file metadata using path and Get file content using path to get the file content and file name.
Can't you view the screenshots I provided?
Best Regards,
Thank you for your help this is now working!!!
Legend!
@v-bacao-msft wrote:Hi @AndrewWilson911 ,
If it is a file stored in the SharePoint Library, use Get file metadata using path and Get file content using path to get the file content and file name.
Can't you view the screenshots I provided?
Best Regards,
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
27 | |
26 | |
25 | |
24 | |
23 |
User | Count |
---|---|
62 | |
44 | |
41 | |
29 | |
27 |