Outlook to Sharepoint auto email upload
Hi, A colleague at my office is looking to set up a way for our weekly IT emails to automatically upload to a SharePoint folder from Outlook. Any suggestions? I'm new to Flows and can't find much online for help. Note: we want the entire email to upload, not just the attachments. Thanks for the help, JordanMatch a Microsoft Form submission to a table in Excel and run the condition if there's a match
Hi I have a Microsoft Form set up where I am requesting a first name, last name, email address and an ID value which is a number for an event I am holding. Only authorized members can attend this meeting, and I authenticate this via the ID value that's captured and look it up according to an Excel spreadsheet I have stored in OneDrive for Business. I want to use Power Automate to do the automatic authentication by taking the ID value from a Form submission, match it to the values in a table in an Excel spreadsheet stored in OneDrive for Business. If the ID matches, Power Automate must send an email to the recipient providing details to the meeting, i.e. the meeting link. If the ID does not match or is not found, the recipient gets an email stating what's the next procedure (a manual verification step - not created in Power Automate). The ID is a numeric value. It's captured as a numeric value on the form. The table has the IDs stored, formatted as "General". I added the following steps: When a new response is submitted Get response details List rows present in a table I specify the ID value from the Form under the "Filter Query" field Apply to each control inserted Select an output from previous steps I choose the ID value from the Excel table. Condition control inserted where the ID value from the Excel table is equal to ID value in the Microsoft Form submission. If yes, send an email with the meeting link. If no, send an email with alternative instructions. End When I test the flow, I get an error at the "List rows present in a table" step. Under "Inputs", I can see the ID value captured under the "Filter Query" field. Under "Outputs", an error is shown. The error is reproduced below: BadRequest Status Code: 400 Headers: Key Value Pragma no-cache x-ms-request-id 55ead164-c257-48e2-94ea-a... Strict-Transport-Security max-age=31536000; includeSub... X-Content-Type-Options nosniff X-Frame-Options DENY Timing-Allow-Origin * x-ms-apihub-cached-response false Cache-Control no-store, no-cache Date Mon, 27 Jul 2020 14:36:37 GMT... Content-Length 500 Content-Type application/json Expires -1 Body: { "status":400, "message":"The$filterexpressionmustevaluatetoasinglebooleanvalue.\r\ninnerexception:The$filterexpressionmustevaluatetoasinglebooleanvalue.\r\nclientRequestId:55ead164-c257-48e2-94ea-a0e8240e9dd1", "error":{ "message":"The$filterexpressionmustevaluatetoasinglebooleanvalue.\r\ninnerexception:The$filterexpressionmustevaluatetoasinglebooleanvalue." }, "source":"excelonline-we.azconn-we.p.azurewebsites.net" } Then the flow stops working after this. Any advice would be appreciated as to why this flow is not working?
Delete Calendar Invite Email when RSVP through Respond to an Event Invite V2
In a flow I've created, I'm using Respond to an Event Invite V2 https://docs.microsoft.com/en-us/connectors/office365/#respond-to-an-event-invite-(v2) to reply to a calendar event. If this was done manually within the Outlook email notification, the act of RSVP'ing would remove the email from my inbox; but the automated response from Power Automate doesn't seem to do that, leaving the email sitting in my inbox as if I haven't RSVP'ed yet. I've tried to use Delete Email https://docs.microsoft.com/en-us/connectors/office365/#delete-email-(v2) to remove the invite from my inbox after responding to it, but can't seem to identify the email id through a dynamic content token, because the only id I have is the event id, which is different. Does anyone have an idea around how I can accomplish this better? ThanksPower Apps : Sharing connector
Hi everyone, We developed a power app for users in our organization to subscribe to various events. When they select an event, they receive a calendar invite. We created a service account through with these emails invites are sent and used Office 365 outlook connector in power apps. However, the problem arises when we share this app with other users. Power App prompts them to sign in with their own user than using the service account. Is there a way we could let users use the Power App without having to authenticate using their own user ( and use the service account itself ? ) . Any pointers here ? Thank you!
Flow to transfer email attachments to SP site
I've created a flow to save all email attachments received in a shared mailbox to a sharepoint folder. But the thing is I want all those attachments to take storage space in SharePoint and not outlook. I can do that by deleting the email attachments from the mail once they're saved in SharePoint library. But I don't want to follow that approach. So the overall need is to make the email attachments take the storage space in SharePoint and not Outlook's with Power automate. Sharing the knowledge if you know would be really appreciable.
