Send daily email using a multi choice column in Sharepoint
Hi, I am trying to create a flow that would send a daily email with the following conditions: 1. A column named "follow-up", with a multi-choice that consists of people name and different comittees that I would have a follow-up to do regarding the item. 2. For every item that "follow-up" is not empty, the email would list by "follow-up" choice, which item I would have to follow-up. 3. The "follow-up" choices are not static; from time to time I need to add a new choice so in the flow it can't be filtered with pre-determined choices. 4. Some items have a "due date", which would be included in the email Example: Email: "Daily follow-up elements" Follow-up choice 1 Item 1 Item 2 due 2022-12-05 Item 5 due 2023-01-08 Follow-up choice 2 Item 2 due 2022-12-05 Item 4 Follow-up choice 3 Item 1 Etc... I read a lot on the subject but wasn't able to find something that would solve what I need to do. Thank you!
Sending an email to a list of people I get by email
I have encountered two barriers that make me think that my approach is wrong to a set of flows I created. I receive an email on a Monday every other week with an attached Excel file. The file is a list of the email addresses of people who are out of compliance with the system that sends me the email with the attached file. I have set up a flow that saves the file (which always has the same name) to the same OneDrive folder when it comes in. I then set up a flow that takes the list from the Excel file and sends each address a "your Late" email. Unfortunately, the file I receive does not have a Table set, so I find I have to do that--but the length of the list of emails in the sheet is variable from file to file. That's problem 1. Problem 2 is that the file is overwritten each time a new one comes in and the flow fails because. the UID has changed. Is there a better way to fully automate this process? Thanks, DaveNeed help retrieving MS Form response and insert it into a cell in .xlsx
Hi MS Power Automate Specialists, Experts and Gurus, May I trouble you to help me a little bit with this question? I created an MS Form to get a text response and then I would like to insert this text into E2 cell and send me an email with this excel file attached. Basically, I can just create new .xlsx in my Onedrive/Sharepoint and use create a table then update row actions in the flow, but I do not want to place the file temporarily to any place, I need it to be sent to my email directly. By doing so, I use Compose action to get the file content and then use the Send an email action to send that file. but the problem is the .xlsx created and attached in the email cannot be open due to a file error. I suppose there's something wrong with the file content in the Compose action { "$content-type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "$content": [{ "cms_item_id": "120978", "data_version": "A", "translated": "TRUE", "language_id": "6", "data": "@{outputs('Get_response_details')?['body/r1c6600e386c648b3a04e9bce374cce47']}", "record_status": "1", "created_by": "", "created_when": "", "last_modified_by": "", "last_modified_when": "" }] } Could you please help verify and suggest how I should fix the code to make this flow work? Thank you in advance PjuvishAdding a comment to a DevOps Work Item using a given user
Second time writing this, as when trying to post the first time it gave me an error "invalid html" and discarded all my content -.- In Flow, I am using a DevOps - Update Work Item action, that updates a work item and adds a comment to it, using the Other Field "history" as the content of the comment. The problem is that the author is set to be the owner of the connection that the action is using, yet since the flow is triggering using an email, the author needs to be set dynamically using the email's author (provided he has an account in DevOps). How can I do this? Is there another name in "other fields" section, perhaps something like "Author" that I can use to set the author of the comment given the name, email or id from the email that started the flow? Screenshot:
