Basically what i want to know is how i could create some kind of matching array so that an email address variable could be based on a location field.

A microsoft form dumps data into a sharepoint list. The sharepoint list has a location item. I want it to dynamically send an email to a particular distribution list based on the value of the location field (string). For instance, SITE1 = site1admin@domain. This isnt defined anywhere so i have to define the mapping between site and email and i figure i can do that inside the flow but dont know how. I thought it might be the "select" data operation but got lost and might not be correct one to use.

I can probably do this with nested IF statements (if site = site1 then update variable to site1admin@domain, else move on to check for the next site name, etc...) But that seems kludgy and i feel like there should be a way to create an array or something that i can just look up an email based on the site. I would manually populate that array with a site relation to email address, just dont really know how to create it in the flow.

EDIT: i feel like the control "switch" actually does what i want here. will post back if i get it working. Sometimes i just have to write things out to figure it out!

I've been trying to figure this out, but if yall could help that would be amazing!

I'm trying to automate a form, and based on what section is responded, a specific department gets an email (example: If someone responds to the X section, the response is emailed to X department, if the X section isn't responded to, X department wont get an email)

Hi All,

I have created the following flow to create a new row in Excel on receipt of an email. I have used a condition to search the email subject and body for certain key words. If the condition returns 'True' I would like to output only the found keyword within the excel row.

Currently, if any of the keywords are found it returns the string 'keyword found' from the variable I have created.

Really appreciate any support on this!

https://preview.redd.it/su2h9qjcz3yd1.png?width=568&format=png&auto=webp&s=0fa3e1c50fff90a0d26911391f1effcb164b4820

https://preview.redd.it/shbdfkklt3yd1.png?width=870&format=png&auto=webp&s=a9ae764749456c41089c05a1d48604e12a08e524

How do you even add columns for this filter to filter certain columns ?

This is in PowerAutomate

Hi there.

Background: I have a US-centric intranet site (SharePoint) that I want to share with my organization's global staff. IT has decided against automatically sharing the site with any users who have a non-US domain, citing cybersecurity concerns. Currently, global staff have to request access on a file-by-file and page-by-page basis. This is annoying/slow for all involved; they can't view a particular page or file until their request has been manually approved, while my team has to manually approve all requests.

Question: Is there a way to use Power Automate to extend our response ("Accept" or "Decline") to a particular file/page request to the entire site? I can't figure out which trigger to use. I'm gathering that, once I have the right trigger, I can grab the user's email or UPN to add them to a SharePoint group that has the necessary permissions.

Hi All, I am currently facing challenges with my email distribution flow and am seeking guidance on the most effective approach for sending "Lessons Learned" communications to a group of 3,600 recipients within our sector.

I understand there is a limit of 500 emails per 60 seconds. To address this constraint, I am considering the implementation of email batching combined with strategic delays in the flow.

Has anyone successfully navigated this process? I would appreciate any insights or real-world experiences you can share.

I have a column Approver 1 - where user can enter multiple people.

I want to create a flow where it picks the first person entered and then go to the second approver without sequential approval.

How to get the first object in the array?

When I use Parse JSON to get the column names in a more convenient way, I found a difficulty to generate the sample schema when you have a column that can be null or string value. (empty is allowed).

After filter array, is there any method to get the column names shown in the selection area instead of using function?

Example - Person A and Person B in Approvals Action.

Person A Approves with Comments.

Is it possible to get Person A's comments through mail when being sent to Person B?
The comments are being shown in Teams Approvals.

Second question -

Is it possible to add cc in Approvers?

My scenario is - Person A approves with comments, Person B gets Person A's comments as well in the mail and approves. While the mail is being sent to Person A and B, include Person C and Person D in cc.

If Approvals can't do this - Is it possible for Outlook Send a mail to do this or any other way?

Dear comunity. I need help. From excel file which has a participans list (emails and names) there should be pairs generated and to each of the pairs a personalized email should be sent. Every week new pairs have to be made and the pairs should not repeat themself. The file is on sharepoit therefore if you add new participans it should include them in the new week pair generation. Can somebody help via Teams so that i share the screen and you help me make the steps?

Willing to pay small amount via revolut if necessary.

Tried for hours now and im losing my mind🥲 send email adress via dm and i will sent you teams invitation

Hi all,

I’m trying to set up a Power Automate flow that will automatically export data from Microsoft Project to an Excel file whenever there’s a change in the project. My goal is to save the Excel file in a specific folder. Has anyone done something similar, or could you suggest the best approach for this? Thanks.

Trying to update a dynaverse field with a number, but for most contacts the value of the field is null, not 0. I made a business rule to make it 0 by default but I don't think it's really working. I could update it to 0 in this flow, but I'm not sure how to get around the 'The template language function 'add' expects its first parameter to be an integer, a float or a decimal number. The provided value is of type 'Null" error. I'm a little confused why there isn't a "is/isn't null" check. Anyone have ways to get around it?

|| || ||

I’ve created a flow to get, export and save certain emails to sharepoint (create a file), mainly email responses from a MS form.

All working fine, however, the flow is pulling the wrong email.

It pulls the correct file name and time, but the text of the email is usually the previous email, so the file saved is always the previous email, if this makes sense?

Any suggestions on tweaks would be greatly appreciated!

Hello everyone , I am new to power automate and automations . I am trying to generate reports using azure automations . I just wanted to know if you can get the output of a azure automations Runbook in power automate so that i can send it by mail or using a teams channel .
Thanks for the help

I need a flow that send an email automatically on 30th day of every month.

please can help me.

I trained the AI Builder to automatically process the invoices of my company using Power Automate Cloud and the inbuilt AI model available.

Premium capabilities can be bought on the platform for 15$ a month which to me is crazy cheap. Do you use Premium capabilities yourself?

https://www.youtube.com/watch?v=NpzB1HvROco

I have a brand new flow (Office 365) that's supposed to run every couple days, and delete any automated messages older than 1 day from a shared mailbox's "Sent Items" folder. I've tested the flow, and after a successful test, I ran it manually.

It correctly identifies that there are exactly 12 emails that fit the basic search criteria, and of those, 9 are older than 1 day. It also indicates that those 9 email were successfully deleted (no errors were thrown). Except they weren't. The emails are still there.

Full Flow

Code for "Get Emails (V3)" (with identifying info removed):

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "importance": "Any",
      "fetchOnlyWithAttachment": true,
      "folderPath": "Id::<snip>",
      "to": "<snip>",
      "fetchOnlyUnread": false,
      "mailboxAddress": "<snipped shared mailbox>",
      "includeAttachments": true,
      "top": 25
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
      "connection": "shared_office365",
      "operationId": "GetEmailsV3"
    }
  },
  "runAfter": {},
  "metadata": {
    "Id::<snip>": "Sent Items"
  }
}

Code for "Apply to each":

{
  "type": "Foreach",
  "foreach": "@outputs('Get_emails_(V3)')?['body/value']",
  "actions": {
    "Condition": {
      "type": "If",
      "expression": {
        "and": [
          {
            "less": [
              "@formatDateTime(item()['receivedDateTime'],'yyyy-MM-dd')",
              "@addDays(utcNow(),-1,'yyyy-MM-dd')"
            ]
          }
        ]
      },
      "actions": {
        "Delete_email_(V2)": {
          "type": "OpenApiConnection",
          "inputs": {
            "parameters": {
              "messageId": "@item()?['id']",
              "mailboxAddress": "<snipped shared mailbox>"
            },
            "host": {
              "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
              "connection": "shared_office365",
              "operationId": "DeleteEmail_V2"
            }
          },
          "runtimeConfiguration": {
            "staticResult": {
              "staticResultOptions": "Disabled",
              "name": "Delete_email_(V2)0"
            }
          }
        }
      },
      "else": {
        "actions": {}
      }
    }
  },
  "runAfter": {
    "Get_emails_(V3)": [
      "Succeeded"
    ]
  }
}

Code for "Condition":

{
  "type": "If",
  "expression": {
    "and": [
      {
        "less": [
          "@formatDateTime(item()['receivedDateTime'],'yyyy-MM-dd')",
          "@addDays(utcNow(),-1,'yyyy-MM-dd')"
        ]
      }
    ]
  },
  "actions": {
    "Delete_email_(V2)": {
      "type": "OpenApiConnection",
      "inputs": {
        "parameters": {
          "messageId": "@item()?['id']",
          "mailboxAddress": "<snipped shared mailbox>"
        },
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
          "connection": "shared_office365",
          "operationId": "DeleteEmail_V2"
        }
      },
      "runtimeConfiguration": {
        "staticResult": {
          "staticResultOptions": "Disabled",
          "name": "Delete_email_(V2)0"
        }
      }
    }
  },
  "else": {
    "actions": {}
  }
}

Code for "Delete email (V2):

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "messageId": "@item()?['id']",
      "mailboxAddress": "<snipped shared mailbox>"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
      "connection": "shared_office365",
      "operationId": "DeleteEmail_V2"
    }
  },
  "runtimeConfiguration": {
    "staticResult": {
      "staticResultOptions": "Disabled",
      "name": "Delete_email_(V2)0"
    }
  }
}

Is there something I'm missing? Is this just not something that works natively with shared mailboxes? Many thanks!

I’m working on a flow that makes API requests for each product and receives JSON data containing some ID details for each product. I want to structure my flow to group IDs by each product, but I’m running into an issue with duplicates when I append data.

First request:

[

{

"ID": "20852497",

"Data": "xxx"

},

{

"ID": "17970000",

"Data": "xxx"

},

{

"ID": "17970001",

"Data": "xxx"

},

{

"ID": "17970003",

"Data": "xxx"

}

]

Second Request:

[

{

"ID": "79382273",

"Data": "xxx"

},

{

"ID": "79382274",

"Data": "xxx"

},

{

"ID": "79382275",

"Data": "xxx"

},

{

"ID": "79382276",

"Data": "xxx"

}

]

Currently, I am getting this output:

[

"ID: 20852497",

"ID: 17970000",

"ID: 17970001",

"ID: 17970003",

"ID: 79382273",

"ID: 79382274",

"ID: 79382275",

"ID: 79382276"

]

Desired Output for Product 1:

[

"ID: 20852497",

"ID: 17970000",

"ID: 17970001",

"ID: 17970003",

]

Desired Output for Product 2:

[

"ID: 79382273",

"ID: 79382274",

"ID: 79382275",

"ID: 79382276"

]

Any advice on how to structure my flow to avoid mixing the data?

Hello, I was tasked with reverse engineering a flow that was created by an employee who is no longer with the company. I was able to get a flow that matches and works exactly as the previous one did, the only issue I am encountering is the formatting of the email. I will try my best to explain the situation, but essentially the flow is as follows: 

Trigger: When a response is submitted in Microsoft Forms.

Action: Get response details.

Action: Start an approval.

Action: Send an email. 

I will leave an example of how it shows up when answered on the Microsoft form as well as an example of how it actually shows up in the email. 

Microsoft Form Answer:

SKU - Description - Qty

SKU - Description - Qty

SKU - Description - Qty 

Email:

SKU - Description - Qty SKU - Description - Qty SKU - Description - Qty 

How do I keep the same formatting from the answer of the question on the form to the email outputting the response details? ChatGPT keeps saying to add line breaks (<br />) but whenever I add them, it does nothing with the formatting and just shows up the same with that at the end in plain text.

https://preview.redd.it/wql52rqztpxd1.png?width=288&format=png&auto=webp&s=e1b50623384abf881442c323abce63053968d53f

I have a flow with 'Approvals'. Based on the conditions - it sending a mail to the specific person. But I want to remove EXTERNAL and the Microsoft Power Automate.

I want it to be Approvals instead of Microsoft Power Automate.

Does anyone have a simple demonstration I can follow showing how to update a hyperlink column in a teams room? I went into the teams area and am using the SharePoint view. My requirement is to have a clickable hyperlink that will open Word, Excel, PowerPoint, PDF etc. in the client and not in the browser.

The reason for the URL is so that it can be selected from a combo box in a Canvas Power App. The client does not want to open the items from an attachment in the app, edit them, save them somewhere, delete from the app and upload the saved one.

I did something like this in an InfoPath form where I had a SharePoint Designer workflow update the metadata with a working hyperlink, but the "citizen developer" friendly Power Automate direction I have are already not making sense and failing to just that.

I'm very new to PA, this might be a basic question, I will try to explain it clearly.

I would like to send a card to a teams chat (preferably, I could use a channel as well if necessary) when a Sharepoint item is created in a specific place. That part I have working.

The part I'm struggling with is this: I want the card to have a button that will take the person who presses it to the item, and will change the card's look to indicate that it has been addressed. I also would like to know who pressed it, and if possible, how long between when it was created and the button was pressed.

Right now, I have it so the button changes the look of the card, and the link to the SP item is in the "new" card, which works well enough.

Anyone have any thoughts on how I can track the statistics of who pressed it and when?

Around 10/25 RSS workflow feed updates seem to not work/post. Run history stops 10/25. When you look at the RSS feed itself there are new events with a more recent than 10/25 PublishDate.

I try to get organizer e-mail from resource calendar.

For some reason when I use " When an event is added, updated or deleted (V3)" trigger, organizer event is always me. Doesn't matter who create event in that resource.

Same when I try Get Events V4..

Do you have any idea what I am doing wrong? It looks like organizer is who calls the flow instead who organize event...

From time to time the interval to check for new emails, that is used in the "When a new email arrives in a shared mailbox (V2)" resets from the minimum 15 seconds to the standard interval of 5 minutes.

Does anyone know why power automate does this?

is it possible to create a flow that sends an automatic email to external email addresses only and appears in the email thread but the automatic email should only be sent once per subject. can someone help me with this i'm stuck ?

I need help,the situation is that every week on sunday at 10pm i need to download one file from website in order for me to make a report the next morning. I have create a workflow using PA Desktop and want to connect it with PA scheduled cloud flow.will the scheduled cloud flow run even when i do not turn on my laptop as i already connect it with cloud system?

Hello,

I created a flow from this Tutorial which allows me to send custom emails with individual Excel files for each email. I've used it several times but it also skips the last few rows of my table. For example, today there are 26 rows but it only sent emails to the first 20. In the flow, when it gets to the get file content, it's skipping that for the last 6 and not sending the emails. All of the rows were created the same way, I get the file name from the path in the folder, added a column for the email address, etc. I then run it without issues minus it skipping some. I'm really stumped because it works, just not for the entire table. I included the flow and the error message about the condition not being satisfied. Anyone else run into this?

https://preview.redd.it/8uvz781lhlxd1.png?width=936&format=png&auto=webp&s=a205560f5d5871e5cdecc1c21b381521e0e71c06

https://preview.redd.it/jruc19w1hlxd1.png?width=1105&format=png&auto=webp&s=990daa7e6f1d8cbc6dd2c53ac6dd4f1f055fb835