1. In editor mode entering input variable works, when you play using UI mode it start making mistakes.
2. many time we have to re-define same input variables (Not sure why because it start typing wrong values even it has same value)
3. still need lots of monitoring and cannot rely on automate its still manual work.

Hi everyone! I'm relatively new to powerautomate and I'm having some trouble with a flow that I'm working on. Essentially, I'm trying to create a flow that takes data from two sharepoint lists (one list has the columns "Person", "Department", and "Access Rights", and the other list has the columns "Department" and "Contactperson". I need the end result of the flow to send an (individual) email to each contactperson of each department, containing a table (also having issues with this part as it is not a predefined amount of rows, it depends on the amount of people per department) with all the people in that department along with their corresponding access rights. Might be useful to add that I'm also not sure how to reference columns of the sharepoint lists... Any suggestions on how to do this? I am really lost. All suggestions are appreciated! Thanks in advance

View Poll

I have really easy flow where after approval process there must be added a status and I get sometimes:

No row was found with Id '519'.

clientRequestId: d504cd33-1ac7-4ee6-b89e-63a65f71c7e2

Any ideas?

I'm trying to pull data out of an on-premise SQL table but want to filter on a bit field named "Complete" using the Get Rows (v2) action. I am at a complete loss on what to enter in the "Filter Query" field.

I have tried "Complete eq 0" "equals(Complete,0)", "$filter=equals(Complete,0)", "Complete eq FALSE". And I either get no record returned or an input error. If I omit the filter altogether, I get every record.

View Poll

Not sure what's up here, only "Link", "poll" and "AMA" are available.

I am currently working on a solution involving PowerApps and Power Automate, where I am passing an Excel file from an Edit Form in PowerApps. Upon clicking a button, the workflow in Power Automate triggers to:

1.Create an Excel file in SharePoint from the uploaded file.

2.Execute a script to process the Excel file by:

•Removing blank rows at the beginning of the file.

•Creating a data table.

•Renaming the sheet and table to a standard name for further processing.

The workflow performs as expected during testing in the Power Automate environment. However, when attempting to upload the file through PowerApps, the workflow fails with the following error:

“We were unable to run the script. Please try again. The script couldn’t create a connection with Excel. Please try again.”

We have explored multiple approaches but have been unable to resolve this issue.

Could you please assist in identifying the root cause of this error and suggest any alternative solutions to achieve the desired outcome?

Thank you in advance for your support.

Hello,

I wanna create a flow to automatize the copies between planners. Today, I have to copy tasks created into a specific bucket to another plan.

Ex: In plan 1 I have 3 buckets (a, b, c), and I want to copy only tasks of the bucket "a" to another plan.

I tried some flow, but there is no field to put a specific bucket name to extract tasks... so, the automation copy all tasks from all buckets.

There is a field to specify the bucket name only for the destination plan.

Hi everyone,

I’m a new user of Power Automate and trying to set up a flow to simplify my workflow, but I’ve hit a few roadblocks and would greatly appreciate your advice. Here’s what I’m attempting to achieve:

I need to create an automated flow where every time a file (PDF or image) is uploaded to a cloud storage platform like OneDrive or Google Drive, it updates an Excel sheet by adding a row with specific patient details (e.g., Name, Age, Procedure, Admission Date). While this seems straightforward, I’ve encountered several challenges.

What I’ve Tried and Issues I’ve Encountered: 1. Extracting Data with OCR: • I’ve tried using AI Builder in Power Automate to process forms and extract data from PDFs and images. However, as a new user, I found it difficult to access or configure AI Builder. At one point, I couldn’t even locate the “Explore” option to start the process. • Another issue is that not all files are formatted consistently, so the extracted data often has errors or is incomplete. 2. Updating the Excel File: • I’ve set up the flow to append rows to an Excel file, but I encountered issues when the file is locked or being used by another flow. • Managing simultaneous uploads has been tricky, as multiple triggers sometimes conflict, causing the flow to fail or overwrite data. 3. API Integration Errors: • I experimented with using external tools and APIs (like OpenAI for smart data processing), but ran into errors such as [401] OpenAI-Organization header should match organization for API key. As someone new to API integrations, troubleshooting this has been frustrating. 4. Overall Workflow Challenges: • I’m still learning how to handle error management in Power Automate. For instance, I’d like to log errors or notify myself when a file doesn’t process correctly, but I’m not sure how to implement that.

What I Need Help With: 1. OCR and AI Builder Guidance: • How do I ensure that AI Builder processes forms consistently and accurately, especially when the file formats vary? 2. Handling File Locks in Excel: • What’s the best way to prevent the Excel file from being locked or ensure the flow doesn’t fail when multiple triggers occur? 3. Error Handling Best Practices: • How can I set up the flow to handle errors gracefully? For example, logging failed file uploads or notifying me automatically. 4. General Advice for New Users: • If you’ve worked on similar projects, I’d love to hear about the tools, tips, or resources that helped you when starting out with Power Automate.

I’d also like to apologize for any mistakes in this post. English is not my first language, and I used ChatGPT to help translate my thoughts. Thank you for your patience and understanding!

I know this is a lot to tackle, but any advice would be greatly appreciated! Thanks in advance for helping a Power Automate newbie streamline this process.

View Poll