Get email addresses from Excel Attachment and Send emails
Pls need help creating a Power Automate flow: When I receive a certain email (Outlook 365) with an Excel attachment, get the email addresses from column D in the Excel attachment, then forward the original email I received to that list of email addresses.
MSAL Modern Auth (OAuth 2.0) for personnal accounts
Hi, I am trying to use azure/msal-node on a node backend server. all work fine for business accounts onmicrosoft.com but not for personnal accounts like mailto:email address removed for privacy reasons, according to this documentation, Authentication seems to be possible https://docs.microsoft.com/fr-fr/exchange/client-developer/legacy-protocols/how-to-authenticate-an-imap-pop-smtp-application-by-using-oauth But i don't understand if my problem come from azure AD configuration or from my code. exp.post('/connect', function (req, res) { let authCodeUrlParameters = { scopes: SCOPES_OUTLOOK, redirectUri: "http://localhost:4220/redirect", }; publicMicrosoftClient.getAuthCodeUrl(authCodeUrlParameters).then((response) => { if (req.body.email) { response += `&login_hint=${req.body.email}` } open(response) }).catch((error) => console.log(JSON.stringify(error))); }); exp.get('/redirect', async function (req, res) { try { const form = { 'code': req.query.code, 'client_id': CLIENT_ID_OUTLOOK, 'scope': SCOPES_OUTLOOK.join(' '), 'redirect_uri': 'http://localhost:4220/outlookOauth2', 'grant_type': 'authorization_code', 'client_secret': encodeURI(SECRET_VALUE_OUTLOOK), } const options = { url: 'https://login.microsoftonline.com/common/oauth2/v2.0/token', headers: { 'Content-Type': 'application/x-www-form-urlencoded', }, method: 'post', } response = await got(options, { form }); respToken = response.body ... } catch (error) { console.log(error) res.end(); } }); the error come from ...v2.0/token request. the server response doesn't really help (error 400 bad request) in azure AD we have app registered and all required scope with status granted. Thank you in advance for your help, Yan
(Flagged e-mail => SPO list) results in duplicates
I have a flow that works mostly correctly. When an e-mail in a user's inbox is flagged, an item is created in a SPO list. (The list is a Task web part, but this problem occurs with a custom built list, also.) The problem piece is that the list items become duplicated. In addition to causing confusion, this distorts the item numbers and ID numbers. The desired behavior is to create an item only once per flagged e-mail, but not necessarily once per e-mail thread. (In other words, one thread might have two flagged messages.) I cannot determine if the duplication occurs each time Outlook is opened, each time the flagged e-mail is viewed, or whether it's something under the hood that's causing it. (1) Is this something that has an obvious fix? (2) If not, how can I cause the flow to check to see if the item has already been created?
