Hi all,

I have a SharePoint list which has two columns "Email" and "Last contacted" for an internal piece of work.

My flow is essentially

1) Microsoft Form is submitted with an email 2) If the last contacted date is older than 3 months > Send them a template email

I'm struggling with the filter query for my "Get items". Specifically for the date. What would the expression be for today - 3 months?

Thanks!

Over the years I've bookmarked sites and blogs with projects to follow along with but most haven't been updated in years, apart from:

https://terenceluk.blogspot.com
(^ which is brilliant btw, it's the one site I've found that has very interesting posts/projects when compared to other sites)

Do any of you have some bookmarks that have recent tutorials/guides that that you can share? I've haven't built a too many LogicApps/PowerAutomate flows but I enjoy doing them when I have spare time in work.

Hi all, as shown in the photo above, I encounter error when i submit this approval in email. It works in MS Team Approval but not in outlook email (Unable to OWA webmail due to Policy). Anyone encounter this before and any solution?

Hello, I am trying to use power automate to acquire the people who were invited to an event like a teams meeting. I want to acquire the names of the invitees, filter out my own name and send this name to a single row in an excel file. The purpose of this is for a one-on-one meeting, so ideally this will only send a single name for each event located in my excel file. I cannot figure out how to do this, despite knowing how the general process of adding a row to a table in excel works with power automate. I would really appreciate any insight on this, like steps with the corresponding expressions. Thanks so much in advance!

Hey guys, I'm trying to do an automation to get attachments from a email, when the email arrives, get the attachment, verify the year and moth of the email received, and check in a SharePoint site if there is a folder with that year and inside of the folder that month, if not, create it, and the save the attachment into the right folder according to the previous conditions mentioned it.

Thanks in advance for your help.

Need help to send data properly from Microsoft Forms Multiple choice question to Sharepoint Lists

I have integrated Microsoft Forms to Sharepoint Lists. When a customer submits the form it updates the list.

One particular question multiple choice option. Is not coming to the lists as expected. It is in string/array format but and making it impossible to filter the customer based on the choice.

Can someone help?

Good evening, I'm working on a project where I would like to update a sp list when an excel file is uploaded. I have a Apply to each - condition that is evaluating the values using 'Contains' for certain text. I created a test excel product that has 15 rows and 3 of them contain the desired text. Rows 1, 2 and 13. All other rows contain random words. When I run the flow it succeeds and the outputs identifies rows 1 and 2 as true, and all subsequent rows as false - including row 13.

Has anyone experienced something like this? If so what was your work around?

Hi, I've created a flow that prompts the user for a few pieces of information, then creates a folder in a SPO library, generates a sharing link and emails that link. How can you embed that into a sharepoint page in a way that doesn't take the user to the flow page itself? If that makes sense? I managed to sort of make it work using a PowerApps button that pointed to the flow, but that just takes the user to the flow page, which ultimately works, but is exposing far more of the process to the end user than we would like. Is this possible?

Thanks!

No errors or warnings. Nothing has been changed, but as of yesterday my flow isn't triggering on keywords posted to the Teams channel any longer. I've recreated the connector, but it doesn't appear to be a permissions issue--I can create a different flow with a manual trigger that creates a message in the same channel with the same connector, and it posts fine. But the keywords trigger is just not monitoring the channel any longer, without any indication why. Anyone else experiencing the same thing, or have any idea what it might be?

Hi,

I have a Parts database with lots of parts information and I have an API that I can GET data from.

I want to develop a List that allows the user to enter customer details and the part # and the List will be auto populated with the parts details.

I figure I could do this based on when an item is created, I could do a HTTP call and update the item, but is it possible to do this 'dynamically' when the user is in the process of creating the item?

Sometimes users enter an invalid part number, or worse, the wrong part number and ideally I could show them this during the act of the item creation, rather than afterwards.

Any thoughts?

Hello everyone

I'm currently in a project and would like to know if it's possible to develop this flow.

So basically I receive a PDF file in my e-mail, then I want to execute a Python script that basically converts that PDF into a JSON file. Then I want to receive or send this new JSON FILE, that was created executing the script, into another e-mail or destination.

Is this achievable in Power Automate?

Thank you in advance

I have a flow which sends me an email with details from a group form (files get stored to shared docs in sharepoint) which was filled out. This form allows PDF’s to be uploaded. The issue I was facing was that in the email it was pulling through a lot of not needed information such as file ID etc. to combat this I used a compose action to split the name, for example a split(body( 'Get_response_details')? ['r50f363997c9484a8eb1e23907b], **) [7]

This then only pulled through just the link, which is great. However if someone uploads more than one PDF - it only pulls through the first PDF, not the rest. How do I fix this?

This flow has been working but started to fail intermittently about two weeks ago.

The flow uses an 'Invoke an HTTP request' action with Graph API to write JSON data to an Excel file stored in a SharePoint Online document library. More often than not, the flow is now failing at random points with a 307 TemporaryRedirect status code.

I have added a Condition to check for the 307 code, and if found, capture the new URI from the Location header in the response with a Compose action. From there, another 'Invoke an HTTP request' action uses the new URI to send the data again, but it receives a 400 Bad Request response.

1. What could suddenly be causing the 307 error?
2. Why is the new URI getting a 400 error?
3. Instead of trying to follow the redirect, should I have the flow wait and retry the original URI? If so, after how much time?

Thanks in advance.

Good morning y'all!

I recently created a flow that is triggered by a button in Sharepoint Lists, then compiles and sends an email with the element's data, saves the mail sent as a file in Sharepoint for backup and updates the Sharepoint List element (mail sent to YES, date of email sent, etc)

However I can only get the sent email's ID if I use "when a new email arrives", which is a trigger and PowerAutomate cannot handle two triggers in one flow.

If I use the flow as is, the flow crashes and doesn't even trigger.

If I don't use "when a new email arrives" I cannot get the mail's ID requested for "export mail"

Has anyone handled this kind of issue?

Microsoft states 1 trigger=1flow, so I have tried to create another flow after this one to retrieve the mail, but cannot seem to link both flows (ex: export the mail sent by the previous flow using XXX subject) because the variable subject is not available in the second flow.

Any help will be highly appreciated.

Have a great day!

I have a form with several questions. When a response is submitted the flow will run.

1. I will get the response details
2. Then I will create a task in Planner.
3. I NEED HELP WITH THIS ONE! ( I got this one... I just made a lot of conditions...)

If the response to one of the questions is "Promo" it will choose the Pink category:

1. Then I use the Update task details connector to populate the Description field with the answers.

2. I NEED HELP WITH THIS ONE!

In the forms, there is an upload document question. I want to add the documents as attachments to the card. How do I do that?

What’s everyone’s job title? Mine is currently business intelligence developer. My boss wants me to consider changing it as I do more than just business intelligence (for us, primarily powerbi reporting). I work with power platform (power automate, power app primarily) and a little bit of sql. Just hoping to get some ideas. TIA

Can I take a value like this, stored in a string variable

and(not(equals(item()?['CurrentEmployeeGroup'],'Non Employee')),equals(item()?['CurrentJobLevel'],'Supervisor'))

and turn it into an expression with that syntax? This is my use case: I want to make the filter expression in a "Filter array" action different for every SharePoint item that the flow loops through, so I want to store the expression syntax in a text field in the SharePoint list. Hope it's possible. Thanks!

Is there an easy way to capture who changed a column and when they made the change? Not who has changed a whole row, Sharepoint has an easy way to do that, but just one column.

So far, my research has lead to:

• Create an ID list of who might make the changes and link it to the flow
  • Not ideal, because the list of people who might make the changes is long and changes often
  • From: https://www.reddit.com/r/MicrosoftFlow/comments/17myqwc/recording_who_edited_what_in_a_list_item/
• Search the audit log per this post: https://answers.microsoft.com/en-us/msoffice/forum/all/who-modified-my-sharepoint-list/5153734c-ba7d-40e2-b0d4-a0508477b5d7
  • I don't know if I have access that will allow me to do that, and I can't tell if it will tell me which column was updated.

It seems like this would be a common thing to do for task lists, capturing who on a team might complete the task, but I haven't had much luck on finding a 'WhoDunnit' action in the libraries.

Thanks!

Hope someone can help:

In my company we have an excel document to keep track of all our staffs training and when its up for renewal. Right now this is a fully human task that i'd like to move to power automate flow. The first flow iv been working on but been totally stumped by, is a flow that reads the excel doc, takes those with training up for renewal, groups them by staff member and sends a unique email to each member of staff with all their training in the email, specifically, the course name, time it takes to complete and a link to it on our intranet.

You can see that iv not managed to get very far, i can send one email for each course that needs done person, but the second i need to use arrays I'm done. Any help or ideas for a new direction would be greatly appreciated.

I have a flow that starts when an item is added to a SharePoint list. The flow then makes a folder in a document library based on the title of the item in the list.

I don't want the flow to continue to the next steps until there are items manually put into it. So, wait until the folder is not empty to progress to next steps.

I have tried many different options within my Do Until statement to no avail. Does anyone have a goto solution for this?

I recently moved a number of flows I inherited from another person at work to a solution to make it easier to compartmentalize them and make the easier to keep up with.

But after that I realised that exporting individual ones into a ZIP wasn't possible anymore, and no matter where I look, there doesn't seem to be a way to disattach it from a solution, even if I make a copy it goes into the environments' "Default" solutions area.

I have found workarounds to getting sort of what I wanted, but there doesn't seem to be a way to just get back to standalone without sending a copy (Assuming it has been run before) to myself then setting up a new flow and exporting that as a ZIP file.

Is there any hints or tips people have regarding this sort of situation, as I was pretty new to Solutions and didn't realise any of this as I was doing it.

Hi, In my "append to array variable" action, I have the following:

{

"FileName": items('Apply_to_each')?['{Name}'],

"Count": items('Apply_to_each')?['{Name}'],

"Link to File": items('Apply_to_each')?['{Link}']

}

I want to append the link from Link to File in the filename and get rid of "link to file", but when I try the following format: <a href="link">Document Name</a>

It doesn't work and says its invalid.

I am trying to build a flow. I have a Sharepoint library with some files that need to be updated once per year, and these files are assigned to different owners. I would like to build some email notifications where the owner receives 1 email when a file hasn't been modified for 11 months, and then switch to a different email when the file hasn't been updated in 12 months. I've played around with it for a day but I can't make it work and looking for help. Here are the basics that I know work the way I want them to:

Recurrence: Interval 1 week, on Monday at 1:00.

Get files (properties only) in Sharepoint: Connected to the proper site address and library name.

I've tried a million things past here. [Get Past Time (11 months) -> For Each -> Filter Array (Modified Is Greater Than Get Past Time) -> True -> Send An Email Notification to Owner.Email] is what I thought should work, but when I tested it, it sent notifications on every file in the directory even if they were 10 minutes old. Since I can't get this to work, I haven't even thought about how to handle the switch to >12 month notifications.

Am I on the right track here? Any help would be appreciated. Thank you.

Hi all,

First time poster here, not a long time listener either... just got into using flows yesterday. This was all driven by me trying to automate some manual tasks I have to do with excel files. I recorded an automation in excel, and saved the script in my OneDrive (standard location). I then built out a flow, following some guides I found, that would manually trigger and apply this script to each file in a Sharepoint folder - provided it was a file that ended in .xlsx.

The problem I'm facing is that the "for each" loop seems to hang with a "not specified" message, and it spins endlessly until the script test times out after 10min. I'm attaching a screenshot of the flow for reference. The script will run if I change the conditional from "{FileNameWithExtensions} ends with xlsx" to "{Name} ends with xlsx", which causes the conditional to fail. So maybe the issue is not with the loop, but with the condition? But I have even tried running this without the condition and it still fails. I would appreciate any direction here.

I was wondering if anyone has ever done anything that can take one drive files from a user and pull them into a SharePoint site? My use case is for terminated users. We have an automation that runs (not in power automate) that will terminate the user, disable account, remove license remove from groups etc. We aren't able to move the one drive files using this automation because of a security issue in how it would have to be done so I am trying to see if this is possible to do with power automate. Basically, current automation would finish and send an email to a specific email that would trigger power automate. I want the automation to extract the email address from the subject line (I believe I have this part figured out already) and then use that email address to get the one drive files and move them to a former employees SharePoint site. Any insight or guidance would be appreciated! I'm not unfamiliar with power automate but I am also not an expert.