Trying to automate downloading of email attachments and saving to Sharepoint
Please forgive me if I used the wrong terms. New to power automate.
I have been asked if I can create a flow that captures emails with attachments and save them to specific folders based on the sender.
I tried to create it based on a switch connector but I have around 2000 different email addresses
I also tried to use the switch connector to first separate them into first letter, then further separate using the function below but this wasn't successful
startsWith(triggerOutputs()?['body/from'], 'a')
This is the error message
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The template action 'From' at line '1' and column '4564' is not valid: the value '@startsWith(triggerOutputs()?['body/from'], 'a')' specified for 'case' property in switch case 'A' contains expressions that are not supported. Only a literal of type string or interger or a '@parameters()' expression can be specified for the 'case' property.'.'.
I have exhausted my basic training and I don't know how to search for the correct method, but is there a way I can essentially do a Vlookup to match email address with the specific folders?
Thank you in advance