Import data from e-mails to Sharepoint lists

%3CLINGO-SUB%20id%3D%22lingo-sub-1679012%22%20slang%3D%22en-US%22%3EImport%20data%20from%20e-mails%20to%20Sharepoint%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679012%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wonder%20what%20the%20easiest%20way%20is%20to%20set%20up%20an%20automated%20flow%20where%20specific%20information%20from%20automated%20mails%20I%20get%20daily%20is%20added%20automatically%20to%20a%20Sharepoint%20Online%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20adding%20new%20items%20but%20then%20the%20advanced%20level%20were%20already%20existing%20items%20get%20updated%20with%20the%20updated%20information%20from%20these%20e-mails.%20That%20would%20mean%20certain%20that%20certain%20information%20in%20columns%20gets%20replaced.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20with%20Flow%20or%20PowerAutomate%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20can%20get%20some%20help%20here%20or%20pointed%20in%20the%20right%20direction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1679012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1679437%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20e-mails%20to%20Sharepoint%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679437%22%20slang%3D%22en-US%22%3EYou%20might%20be%20able%20to%20write%20some%20heavily%20complex%20expressions%20that%20do%20string%20searching%20and%20pull%20out%20into%20variables%20and%20update%20SharePoint%20lists%20that%20way%2C%20but%20every%20e-mail%20would%20have%20to%20have%20a%20unique%20ID%20to%20do%20updating.%20%3CBR%20%2F%3E%3CBR%20%2F%3EThey%20do%20make%20connectors%20for%20this%20thou%20but%20it%20obviously%20costs%20some%20money%20to%20use%20but%20it'll%20save%20a%20bunch%20of%20time%2C%20just%20don't%20know%20how%20critical%20the%20issue%20is%20you%20are%20solving.%20Anyway%2C%20here%20is%20an%20article%20kind%20of%20covering%20what%20you%20are%20trying%20to%20do%20but%20they%20are%20writing%20to%20trello%2C%20you%20would%20just%20change%20that%20to%20a%20SharePoint%20list.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fparserr-blog.azurewebsites.net%2Fuse-email-parser-software-microsoft-flow%2F%23%3A~%3Atext%3D%2520How%2520to%2520Use%2520an%2520Email%2520Parser%2520Software%2CPreparing%2520everything%2520on%2520the%2520Parserr%2520side...%2520More%2520%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fparserr-blog.azurewebsites.net%2Fuse-email-parser-software-microsoft-flow%2F%23%3A~%3Atext%3D%2520How%2520to%2520Use%2520an%2520Email%2520Parser%2520Software%2CPreparing%2520everything%2520on%2520the%2520Parserr%2520side...%2520More%2520%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAnyway%2C%20hope%20this%20helps.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

 

I wonder what the easiest way is to set up an automated flow where specific information from automated mails I get daily is added automatically to a Sharepoint Online list. 

 

Both adding new items but then the advanced level were already existing items get updated with the updated information from these e-mails. That would mean certain that certain information in columns gets replaced.

 

Is this possible with Flow or PowerAutomate?

 

Hope I can get some help here or pointed in the right direction.

 

Thanks 

1 Reply
Highlighted
You might be able to write some heavily complex expressions that do string searching and pull out into variables and update SharePoint lists that way, but every e-mail would have to have a unique ID to do updating.

They do make connectors for this thou but it obviously costs some money to use but it'll save a bunch of time, just don't know how critical the issue is you are solving. Anyway, here is an article kind of covering what you are trying to do but they are writing to trello, you would just change that to a SharePoint list.

https://parserr-blog.azurewebsites.net/use-email-parser-software-microsoft-flow/#:~:text=%20How%20to...

Anyway, hope this helps.