Hi guys, before everyone destroys me in the comments, this is my first power automate project ever.
A client is requesting that we create a system where 5000 mails are sent out to suppliers (through mail chimp) and on those mails will be Microsoft form link. Here’s where it gets tricky, they want a system that captures all this data from the form into share point document library (so the form must be made into an excel document or word), this will capture all the suppliers details but they will also need to upload files on the form but as they are external users, they would need a link to a share point folder where they can drag the folders, but the folders must be moved out so that future applicants don’t see their confidential folders.
Everything submitted in that form (including docs from the external link) must be put in a folder that is created and has the name of the company (which will be entered in the form).
I’m getting stuck with form data into a brand new excel sheet (is this possible) to then also create a new company folder to store this all in and I don’t even think the last part of getting those uploaded docs in a share point folder to then go into the correct newly created company folder… sorry I know this is a lot to follower and I can imagine I’ve explained it poorly…
Am I wasting my time ?
I have literally restarted about 5 times…….

View Poll

Hi,

I am very junior to this field but I am tasked with automating resetting the password in unattended process. Basically Power Automate will get the credentials from Azure Key Vault, pass it to PAD which will do password reset in default app. How to return the new password back to the Azure Key Vault? I assume if it's possible it would be from PAD? Would anyone kindly give any suggestions of how that can be done?

View Poll

I'm trying to get this dynamic content to show up as text in an email.

The email is pulling information from a new line that's added in SharePoint. This is for employees who are calling in sick or who are requesting sick leave. I'm trying to get it so that in the body of the email it will have the supervisor, employee, number of hours, and the type of leave that is requested.

The problem is this email that generates is showing up as {@odata.type"."Microsoftazure.connectors....then it goes on to have a bunch of information related to the content.

I'm trying to figure out how to fix this and I just can't figure it out is a lot of the guides online are not good.

View Poll

Hello everyone

I would like to know if it's possible to create a tool with power automate that will extract specific data from multiple pdf files and add it in a existing excel sheet.

I have acces to PowerAutomate, PowerApps ...etc only, I can't take a suscription for API, needs to be inlcuded in Power suite.

Thx for your help

www.google.com

Relatively new to power automate.

What does it mean by “my flow’s operation is hitting an action limit”?

I’ve been using this same flow for over a year without any issues and today I got an email saying “my operation has been throttled”.

And also the flow used to take 6sec to run but now it either fails or takes 12min to run.

View Poll

I created a flow that starts by triggering the flow manually, then lists rows present in a table and creates a task. However, my spreadsheet has multiple rows for the same task because each task has more than one item. How can I add these items within each task without duplicating the tasks? For example:

Task 1: Create report
Task 1: Send report

I want it to be a single task with Task 1 and 2 items: Create report and Send report. What is missing in my flow?

I’m creating an approval for new items added to a list using the template but there are foreach loops around my “Start an approval” tasks that I think are messing up my flow.

Can someone explain why the foreach loops are appearing?

Requesting help with replacing text in date. I have imported data from excel sheet which contains dates. I have created all the buttons clicked but the text is not getting replaced. Please help.

I am wanting to use automate to remind me somehow when a date is approaching. I have to update paper work once a year for each person. As you can see column E shows the last date I updated the paper work.

So one shows 10.9.23- I’m past due for this, so I needed a reminded on 10.9.24 to update the paperwork.

What is the best way to go about this

View Poll

How to create a teams chat without including myself in power automate?

Hi all, I am trying to create a flow that creates a group event when a new response is sent from Microsoft Forms. I want to create the group event with my time zone (UTC -5), however no matter what I do to specify the time zone, the group event is created with UTC time zone.

I have seen that other people also had the same problem, and the solution was to use the action 'Send an HTTP Request', but I do not know how it works, it would be of great help if you can explain me how it works, if you have link to articles or videos that explain, it would be of great help, thank you very much.

I have a Sharepoint list with 2 columns (people), Employee and Managers. The Managers are in Cc and Employees in the “To”. Currently the “To” function works, it takes the column and converts it into an array variable and then it uses Join function for the “;” as example@gmail.com;example@icloud.com will make the email send. However now I’m struggling to get it working for the “Cc” part, I’ve tried to repeat the process and separate the variables outside and inside, however I can never get two distinct variables for the To & Cc.

Does anyone know what I could do? Thank you!