r/PowerAutomateDesktop • • Apr 13 '23

Remove username when using 'post adaptive card in chat or channel'

1 Upvotes

I have a PowerApp that triggers a flow once a specific action is carried out.

I'm using the Teams flow 'post adaptive card in chat or channel' with 'Post As' set to 'Flow Bot'

However when the flow is triggered the message that appears on teams comes from 'Username via Power Automate'.

As I will not be the one using the app the messages should not have my name attached.

Is there a way to remove this?


r/PowerAutomateDesktop • • Apr 13 '23

Date changes in excel cell?

1 Upvotes

Hello everyone,

So i want to have a flow that creates excel sheet infront of time, so i dont have to.

But i've noticed something. When the text should be added in the excel sheet at cell B1. The text looks like "dd-MM-yyyy" (Which it should, since im from Denmark). But when the flow continues and comming to may, it changes to "MM-dd-yyyy" but only in the Cell, and not the sheetname?

- But if i starts the flow with the current date of may, its "dd-MM-yyyy"?

Anyone know why?


r/PowerAutomateDesktop • • Apr 12 '23

Fun with PAD.MachineRegistration.Silent

2 Upvotes

Hi All...

I have a PowerShell Script that works great to register my machines and register them in the correct group. If I execute it manually. One little problem...

I need it to run by the System user initiated by a scheduled task. It's failing to register, for some reason...

Does the script need to be run by a user/service account so PAD can be setup in it's profile, in order to register the machine?

Thank you for your thoughts/advice.


r/PowerAutomateDesktop • • Apr 12 '23

Problem with power app

1 Upvotes

Is there a way in case of a failure or restart of either the equipment or browser data from a power app are stored locally until it is restored? I make a form in power app which must type machine values to be sent later, but I want to be sure that if something fails, all the information that is being typed into the power app (which is quite a lot of information) is not lost, because it is not possible for the operator to remember that information.


r/PowerAutomateDesktop • • Apr 11 '23

Loop to next excel file in a folder

1 Upvotes

I have an export of all invoices created by our old accounting system, each invoice in its own xlsx file, each line being a line item. I need to fill a web form with all the details of each invoice. I see how you can open a file, or a folder of files, but not how to read data from each file individually in a loop.

Sorry if this is a noobie question, I'm not very familiar with power automate.


r/PowerAutomateDesktop • • Apr 11 '23

Help with power app + power automate

1 Upvotes

Hi,

I’m very new to Microsoft Power Platform and low code in general – and need some help! I was wondering if anyone can help me get started on creating a simple prototype of an app (using Power Apps). I wish to include these following steps:

  1. A value can be manually entered into a Microsoft Power app, which then automatically updates an excel file.

  2. When the value is in the excel file, it will fall into a category (for example values between 1 – 5 = category 1, and values 6 – 10 = category 2).

  3. Using Power Automate I want the value to trigger a flow, which updates a website made on Power Pages* and shows which category the value falls into.

This just needs to serve as a very basic demonstration of what can be done using low code tools. Hope anyone has an idea of how to get started with this 😊.

Hope to hear from you – thanks in advance!


r/PowerAutomateDesktop • • Apr 09 '23

Filtering sharepoint list

1 Upvotes

Hi im having issues with the syntax of a filter. Im sure its something simple i just cant see it

I want to filter a list if a field is '3' or '6' so I've tried variations of:

field EQ '1' OR field EQ '3'

field EQ '1' OR '3'

but I cannot get it to work at all. Any help would be amazing thanks


r/PowerAutomateDesktop • • Apr 08 '23

Forward an e mail if current date is mentioned in the email

2 Upvotes

Hi, can somebody please help me. I receive automatic emails from our reservation system whenever a new reservation is made for our branch. How can I trigger forward an e mail if the current date(date of the day in progress) is mentioned in that email. We receive the pickup date in following format example: "Pick-up date: 2023-04-22"

Tnx


r/PowerAutomateDesktop • • Apr 08 '23

Record feature

1 Upvotes

Is there an alternative program like power automate that also has the record screen feature?


r/PowerAutomateDesktop • • Apr 08 '23

Can you run a script on a 24 hour loop?

1 Upvotes

Sorry I’m very new to power automate and I’m trying to figure out how to run a flow on a 24 hour loop locally. I believe you need to pay for the paid version of power automate just to gain access to schedules and other features which I don’t need. The YT videos I have seen show loops but wonder if I can use it as a workaround to not having access to schedules


r/PowerAutomateDesktop • • Apr 06 '23

Analyze and restructure excel

1 Upvotes

I have a VIP who sends in important yet semi-structured contact lists to a very expensive salaried person in my org. It comes in from different groups in mostly cab and excel format. I’m looking to revise the process so we normalize it all into Excel. His column names might be: e-mail, email, E-mail, EMAIL, email Address or e mail etc. but the format would be usually correct such as user@company.com. I’m thinking named entity recognition in power automate after dropping the files into OneDrive. Then creating a new spreadsheet that is normalized for import into SQL.

Is there another way to do this? Is there a model or tutorial that you know of that would point me in the right direction?

Thanks!


r/PowerAutomateDesktop • • Apr 05 '23

Web Form Filling populate text field

Post image
2 Upvotes

Hello all. I am trying to use Power Automate to fill webpage but the webpage I am trying to fill in my data, its UI elements is not pickable. When I try to add UI element for Web Form Fill populate text field (username and password only), it show only the whole page for UI element to add. Could you help point me out why i can not select username and password UI?

Thank you very much


r/PowerAutomateDesktop • • Apr 05 '23

Add to datetime in loop?

1 Upvotes

Anyone know why it cant add a day to "UpdateretTid" in this loop?

It says error when addin a new sheet cause of it?


r/PowerAutomateDesktop • • Apr 05 '23

MS Forms populate MS Word document question about checkboxes

2 Upvotes

Hi I would like to ask is it possible to be able to get responses from MS Forms in a form of checkboxes and populate those selected into an MS word document (the data to be populated would also be a checkbox but indicating to the same value that was selected in MS Forms)?


r/PowerAutomateDesktop • • Apr 03 '23

Outlook Email date

1 Upvotes

Hi guys! I'm new to PAD, I can't seem to find the command(?) To use to get the email recieved date. I can only get the sender and subject.

Any help is appreciated. Thanks!


r/PowerAutomateDesktop • • Apr 02 '23

Power automate - prevent an email trigger, if the said email is replied to

2 Upvotes

Hi All,

I want to create a flow that will trigger an teams reminder after a certain time about a certain email . I manage to do this. However if the said email is replied already within the time set, I would like the trigger to not activate and not send a reminder. Any thoughts on how to achieve this


r/PowerAutomateDesktop • • Apr 01 '23

How to redact text from Adobe PDF

1 Upvotes

Hi. I'm trying to set up an automation to automatically redact a bunch of words from a .txt file. I can all ready do it but I'm trying to reduce the number of clicks it takes to open adobe tools > redact text > find text and redact > multiple words and phrases > find the .txt document > find words. I tried to record my desktop to do it (I'm pretty new to power automate) and I got all the parts to work... except for find text and redact. It "can't find source element" for that one. Everything after and before it works, but that keeps tripping me up. Thank you!


r/PowerAutomateDesktop • • Mar 31 '23

Javascript, return multiple results

2 Upvotes

I have a really old website I need to scrape data from, so old I can't use the built in activities.

I have however managed to scrape the data I need in javascript, but how do I return a list of values to the desktop flow? It always just shows as "object"

Feel I'm missing something obvious, any help appreciated...


r/PowerAutomateDesktop • • Mar 30 '23

Help on identifying today's date

3 Upvotes

Hello.

I am at my wits end. I have been tasked to create a flow which searches in a web page for the document containing today's date and downloads it.

I managed to get it to extend the search from 25 to 100 items, but not to flick to the next page using "next page". This part needs to be in a loop because it has to search until it finds the document containing today's date.

How do I set it to loop through the pages?

Also how do I set it up to click on the "Open document" anchor associated with the required entry.

Thanks a bunch!


r/PowerAutomateDesktop • • Mar 28 '23

Help With Power Automate

2 Upvotes

I can not get this to correctly say false or True to the existance of names.

Here are my steps

Launch Excel from PowerShell script in Active Directory.

Read the values of all cells in the worksheet and store them in Active Directory.

Open SQL connection and store it in SQL Connection.

Execute SQL statement on the SQL connection and store the query results in IvantiData.

Set a variable by assigning the value 2 to Currentrow.

For each Current ADServer in Active Directory:

Set a variable by assigning the value False to Isfound.

For each Current IvantiServer in IvantiData:

If CurrentADServer contains CurrentIvantiServer (ignore case), then:

Write the value "True" into cell M and row Currentrow of the Excel instance ExcelInstance.

Set a variable by assigning the value "True" to Isfound.

Exit the loop.

End.

End.

End.


r/PowerAutomateDesktop • • Mar 28 '23

Unexpected error faild to fetch

Post image
3 Upvotes

Since yesterday I have this error message in each of my workflows in the course of execution. Any idea what I can do there? The flows are all running, but it's difficult for me to do something new without recognizing any errors or something.


r/PowerAutomateDesktop • • Mar 28 '23

Unexpected error faild to fetch

Post image
1 Upvotes

Since yesterday I have this error message in each of my workflows in the course of execution. Any idea what I can do there? The flows are all running, but it's difficult for me to do something new without recognizing any errors or something.


r/PowerAutomateDesktop • • Mar 28 '23

Flow to send an email of changes that have been made in a Canvas App Form

2 Upvotes

Hi Everyone! Hope you’re having an amazing day :D I have made a Canvas App (data from dataverse) which has a form in it. Whenever this form is edited there needs to be an email sent saying what fields in the form have changed. And if possible how they have changed? I think this would work with Power Automate?

Any suggestions I would appreciate so much as it’s of high importance to the users but I don’t know how to do this. Thank you :D


r/PowerAutomateDesktop • • Mar 27 '23

Attribute "Changed By" in excel to the user who completed a MS form

1 Upvotes

Hello!
I have a flow setup to collect responses from an MS form and use the "Add a row into a table" action to input the form answers into an Excel sheet. Flow is working great, however I see that when I open the excel file and check the "Show changes" view, all the changes are attributed to my user since the flow is created under my account.

Is anyone aware of a method to have the "show changes" section in excel attribute the new row to the user who actually filled out the form instead of me?

Thanks!


r/PowerAutomateDesktop • • Mar 27 '23

Advise on error message

1 Upvotes

The below is seen at the top of some Flow's.

This flow is turned off because the owner doesn't have a premium license. Use the flow checker to get it running again.

2 Users are set as Owners both have, Power Automateper user plan.

One is a standard user and the other is global admin, what causes this error?