t3_1h3lwls

Hello, I’m a teenager volunteering for a local cat rescue and I’m trying to automate the process of adoption forms by integrating the data from an online Microsoft Form to an Excel spreadsheet. 

I have made the flow that integrates the data and so far it works, however I need to include signatures from the adopter - so I tried to do this by using the ‘Populate a Word Template’ action. To create the template I used the ‘Get a Row’ action to select the key values I wanted in the personalised word document alongside developer tools on word - Plain Text Content Control and Properties. Then returning to Power Automate I used the ‘Populate a Word Template’ action, followed the steps and put the answers to the initial Form in the advanced parameters respectively. This step was to create the personalised form that the adopter could sign digitally with the draw feature on Word. Then I was going to turn this filled out document into a hyperlink that would be added to the Excel Spreadsheet in the same row as all their other data.

I can’t progress as this ‘Populate a Word Template’ action is a premium feature,
and so far I’ve been doing all this on my school account so I doubt I’ll be able to activate a free trial or get the necessary licence from an administrator. Does this mean I can’t do it? Will I have to speak to my school for a license or even make an organisational account and get a license for it? 

Sorry for the long winded context section - I thought there might be a way to get around using the premium feature which I don’t know about, as I’ve only started using Power Automate yesterday, and hoped someone who understands the context of the situation could advise me on how to get the online signatures.

Thank you.
  

<div class="md"><p>Hello, I’m a teenager volunteering for a local cat rescue and I’m trying to automate the process of adoption forms by integrating the data from an online Microsoft Form to an Excel spreadsheet. </p>

<p>I have made the flow that integrates the data and so far it works, however I need to include signatures from the adopter - so I tried to do this by using the ‘Populate a Word Template’ action. To create the template I used the ‘Get a Row’ action to select the key values I wanted in the personalised word document alongside developer tools on word - Plain Text Content Control and Properties. Then returning to Power Automate I used the ‘Populate a Word Template’ action, followed the steps and put the answers to the initial Form in the advanced parameters respectively. This step was to create the personalised form that the adopter could sign digitally with the draw feature on Word. Then I was going to turn this filled out document into a hyperlink that would be added to the Excel Spreadsheet in the same row as all their other data.</p>

<p>I can’t progress as this ‘Populate a Word Template’ action is a premium feature,
and so far I’ve been doing all this on my school account so I doubt I’ll be able to activate a free trial or get the necessary licence from an administrator. Does this mean I can’t do it? Will I have to speak to my school for a license or even make an organisational account and get a license for it? </p>

<p>Sorry for the long winded context section - I thought there might be a way to get around using the premium feature which I don’t know about, as I’ve only started using Power Automate yesterday, and hoped someone who understands the context of the situation could advise me on how to get the online signatures.</p>

<p>Thank you.</p>
</div>

Populate a Microsoft Word Template - Premium

t3_1h0ywuo

Hi team, 

I have trained some Purchase order of one  client  from different vendors each vendor have their own pdf format so I trained several ai  model but now can we able to combine all the different model into one model for a client using that one model all the diff vendors pdf need to be automated 

<div class="md"><p>Hi team, </p>

<p>I have trained some Purchase order of one  client  from different vendors each vendor have their own pdf format so I trained several ai  model but now can we able to combine all the different model into one model for a client using that one model all the diff vendors pdf need to be automated </p>
</div>

How to merge 2different Ao model into one 

t3_1h067hs

Webinar: Automatically Processing Invoices in SharePoint

t3_1h062cl

Save Base64 Image to Sharepoint

t3_1gzm0w3

Hi everyone, is there a way to convert a PDF file to a Word document in Power Automate without using a premium connector?

<div class="md"><p>Hi everyone, is there a way to convert a PDF file to a Word document in Power Automate without using a premium connector?</p>
</div>

pdf to word conversion 

How to | Loop through drop down menu using Power Automate Desktop

t3_1gylt3y

Looping through drop down menu using Power Automate Desktop

t3_1gxheau

Can't seem to get my SQL Connection working. Probably something simple I'm missing 

t3_1gx7fl8

Hello, i have a list of excel files which are project names "projects"(example P1234, P1675,P1765..) where for each projects we have the cost by months (months are columns).

I want to update a sharepoint list where every row has the name of the project file and for each row we update the forecast for each month depending on weather the file in "project" changes or not

Initially i had a python file to do this to update an excel file "forecasts" but now i want to change a list directly with power automate.

Can someone help me?

<div class="md"><p>Hello, i have a list of excel files which are project names &quot;projects&quot;(example P1234, P1675,P1765..) where for each projects we have the cost by months (months are columns).</p>

<p>I want to update a sharepoint list where every row has the name of the project file and for each row we update the forecast for each month depending on weather the file in &quot;project&quot; changes or not</p>

<p>Initially i had a python file to do this to update an excel file &quot;forecasts&quot; but now i want to change a list directly with power automate.</p>

<p>Can someone help me?</p>
</div>

python file to power automate

t3_1gw8wko

Print file name from variable %SelectedFiles%

t3_1gu2yxv

Hi there, I am kind of stuck with creating this one flow. We have SP list with the columns (type choice) that will be updated regularly by team members:
- managers approval: approved/declined
- supervisors approval: approved/declined
- status: pending/final

So I am looking to work with conditions & have an email send to item submitter (column Email) when the managers and supervisors column value changes to approved and Status is pending. I thought of linking it together with Status choice so it wont create a loop every time the list is modified and once the approved email is sent, it will update the Status to Final. 

Any ideas how to best handle this? 

<div class="md"><p>Hi there, I am kind of stuck with creating this one flow. We have SP list with the columns (type choice) that will be updated regularly by team members:
- managers approval: approved/declined
- supervisors approval: approved/declined
- status: pending/final</p>

<p>So I am looking to work with conditions &amp; have an email send to item submitter (column Email) when the managers and supervisors column value changes to approved and Status is pending. I thought of linking it together with Status choice so it wont create a loop every time the list is modified and once the approved email is sent, it will update the Status to Final. </p>

<p>Any ideas how to best handle this? </p>
</div>

SharePoint list approval flow via column choices

I want PA to read text(including letter, numbers and special char) from web page and type it in below input box. This is like captcha code it will give unique text everytime. Please help . I've tried using OCR but it is helpful.

<div class="md"><p>I want PA to read text(including letter, numbers and special char) from web page and type it in below input box. This is like captcha code it will give unique text everytime. Please help . I&#39;ve tried using OCR but it is helpful.</p>
</div>

Help! I want PA to read text(including letter, numbers and special char) from web page and type it in below input box. This is like captcha code it will give unique text everytime. Please help . I've tried using OCR but it is helpful.

Preciso replicar a escala de um turno no MS Shift (TURNO) utilizando Power Automate. Sei que existe a conexão mas não sei a logica para usar. ME AJUDEEEMMM ! 

<div class="md"><p>Preciso replicar a escala de um turno no MS Shift (TURNO) utilizando Power Automate. Sei que existe a conexão mas não sei a logica para usar. ME AJUDEEEMMM ! </p>
</div>

Como copiar uma escala na aplicação Turno (MS TEAMS), utilizando o Power Automate?

Thoughts on process building?

Automating an email with grouped data

FREE WEBINAR: Automatically Processing Invoices in SharePoint, by Power Automate expert; Tyler Wasson

How can I filter two arrays with multiple criteria.  Probably similar to SQL left join.

I have a SharePoint list where employees are meant to submit a new entry annually.

I want to create a power automate flow to check the max date for each employee and send a reminder if the max date is older than 12 months.

Any tutorials or help to create such a flow?

Thanks 

<div class="md"><p>I have a SharePoint list where employees are meant to submit a new entry annually.</p>

<p>I want to create a power automate flow to check the max date for each employee and send a reminder if the max date is older than 12 months.</p>

<p>Any tutorials or help to create such a flow?</p>

<p>Thanks </p>
</div>

Max Date per group via SharePoint

How do I create this flow - help with planning how to execute

Help please with first flow - when a folder is created on SharePoint S in path, create new folder with same name in SharePoint D...  then when folder with name abc is created in Sharepoint S, copy it to the new folder in SharePoint D 

I have created a workflow to retrieve information 4rm pdf files,yet every file uploaded will trigger to create a new file and it causes error.
So,I hope if I still use the same folder to upload pdf files, instead of creating new files again, it will continue to add information to the initial file

What is the best Automation tool? (from people who have used a few like, Zapier, Make, IFTTT (If This Then That) and Microsoft Power Automate?)


There is an email distribution list that is an entire list of multiple people, and i want them to be alerted when a new item is added to my sharepoint list. I can’t add every single person’s individual email address since there’s like a limit to how many email addresses i can create the rule for. For some reason when i type in the email distribution list though it does not pop up as an option. :( Is there any other way I can possibly create a rule for the whole group to get emailed when a new item is added or no? 
i attached a link that shows what i researched to get help but im still confused 

<div class="md"><p>There is an email distribution list that is an entire list of multiple people, and i want them to be alerted when a new item is added to my sharepoint list. I can’t add every single person’s individual email address since there’s like a limit to how many email addresses i can create the rule for. For some reason when i type in the email distribution list though it does not pop up as an option. :( Is there any other way I can possibly create a rule for the whole group to get emailed when a new item is added or no? 
i attached a link that shows what i researched to get help but im still confused </p>
</div>

SharePoint List not letting me put an Email distribution list as an email account in the alert rule

How to create a discussion thread when sending approval

Power Automate Desktop - Copying Charts From Excel and Pasting Into Respective Powerpoint Slides

Hi,
I’m completely new to automate and frankly have no idea how it works. I was wondering if this tool, perhaps paired with other tools, could enable me to automate the task below.

The mundane task: 
I host various training workshops that are recorded. After the recording is complete I need to upload it to a relevant area and send out to team members attached to an email.

How could I automate this full process?

[View Poll](https://www.reddit.com/poll/1gpy4sf)

<div class="md"><p>Hi,
I’m completely new to automate and frankly have no idea how it works. I was wondering if this tool, perhaps paired with other tools, could enable me to automate the task below.</p>

<p>The mundane task: 
I host various training workshops that are recorded. After the recording is complete I need to upload it to a relevant area and send out to team members attached to an email.</p>

<p>How could I automate this full process?</p>

<p><a href="https://www.reddit.com/poll/1gpy4sf">View Poll</a></p>
</div>

Automated emails post-teams meeting recording

Split Column to New Columns

I am working on a flow that fetches data points from my emails, populates them in excel rows and then creates folders and common subfolders from those excel rows in my onedrive. The only problem is at the end, there is a dummy.txt file which gets created inside the main folder and each subfolder. I want to delete all of those dummy files at the end. Can anyone advise please....i need this to work direly!!

<div class="md"><p>I am working on a flow that fetches data points from my emails, populates them in excel rows and then creates folders and common subfolders from those excel rows in my onedrive. The only problem is at the end, there is a dummy.txt file which gets created inside the main folder and each subfolder. I want to delete all of those dummy files at the end. Can anyone advise please....i need this to work direly!!</p>
</div>

I need help guys

 I'm just wondering if someone could help me out, I'm very new in powerautomate and I'm trying an automated cloud flow when say for example I mesage in a group chat in teams -- im on sick leave today, this will then trigger sending an email notification to the team. 

What I'm struggling at is the condition I set in which   

Action trigger: When a meesage is added to a chat or group chat  Condition:   

1. Trigger.output ['body/content'], 'sick leave') 
2. Trigger.output['body/from']['user'],['id'] = my user id  

The problem is that the values from the body doesn't include the user id. Is there any way to retrieve the userid as part of the condition before sending an email and making an OOO calendar with automatic reply?

<div class="md"><p>I&#39;m just wondering if someone could help me out, I&#39;m very new in powerautomate and I&#39;m trying an automated cloud flow when say for example I mesage in a group chat in teams -- im on sick leave today, this will then trigger sending an email notification to the team. </p>

<p>What I&#39;m struggling at is the condition I set in which   </p>

<p>Action trigger: When a meesage is added to a chat or group chat  Condition:   </p>

<ol>
<li>Trigger.output [&#39;body/content&#39;], &#39;sick leave&#39;) </li>
<li>Trigger.output[&#39;body/from&#39;][&#39;user&#39;],[&#39;id&#39;] = my user id<br/></li>
</ol>

<p>The problem is that the values from the body doesn&#39;t include the user id. Is there any way to retrieve the userid as part of the condition before sending an email and making an OOO calendar with automatic reply?</p>
</div>

Automated OOO

Help with SQL - Transform Data Using Power Query message - stopped working after working for awhile.

Hey guys, looking to build a low-code community at work, on the assumption that somewhere in the few thousand people in my org, there must be other people into this stuff! 

Hoping we can work together and solve some of the challenges across the org and also give people the opportunity to learn and dabble if they haven’t already.

Have set up a Team and looking to add content before I get the org to publicise it.

Does anyone have an existing list of some of the best videos/resources before I go down the road of building a collection list/app? It’s clearly going to be a big job and I don’t want to reinvent the wheel if possible. 

Or is this something I could automate somehow do you think? 

I have a few bookmarks saved from my own learning journey but I pay for a course with PowerApps 911 and then mostly just google or post on Reddit if that doesn’t work! Clearly I don’t just want to tell people to pay for a course or google it, I want to give them some base content to get started/excited. 

Any other advice around this sort of community project would also be appreciated :)

Thanks!



<div class="md"><p>Hey guys, looking to build a low-code community at work, on the assumption that somewhere in the few thousand people in my org, there must be other people into this stuff! </p>

<p>Hoping we can work together and solve some of the challenges across the org and also give people the opportunity to learn and dabble if they haven’t already.</p>

<p>Have set up a Team and looking to add content before I get the org to publicise it.</p>

<p>Does anyone have an existing list of some of the best videos/resources before I go down the road of building a collection list/app? It’s clearly going to be a big job and I don’t want to reinvent the wheel if possible. </p>

<p>Or is this something I could automate somehow do you think? </p>

<p>I have a few bookmarks saved from my own learning journey but I pay for a course with PowerApps 911 and then mostly just google or post on Reddit if that doesn’t work! Clearly I don’t just want to tell people to pay for a course or google it, I want to give them some base content to get started/excited. </p>

<p>Any other advice around this sort of community project would also be appreciated :)</p>

<p>Thanks!</p>
</div>

low code community- resources

Please visit /r/microsoftflow for PowerAutomate discussions.

<div class="md"><p>Please visit <a href="/r/microsoftflow">/r/microsoftflow</a> for PowerAutomate discussions.</p>
</div>

<div class="md"><p>Community for Microsoft Power Automate discussions.</p>
</div>

5,596 Subscribers

How to merge 2different Ao model into one

Looping through drop down menu using Power Automate Desktop

python file to power automate

Como copiar uma escala na aplicação Turno (MS TEAMS), utilizando o Power Automate?

Automated emails post-teams meeting recording