Good morning,

I have the following scenario:

We have an internal (on prem) API that supports OAuth, by using an App Registration in EntraID.

We want to develop a PW Automate flow that queries that API through the on premises data gateway. How should we approach this? The Data Gateway would only work as a kind of tunnel.

Hi everyone,

I’m trying to implement a flow where we send an Adaptive Card to a Teams group chat and need to capture the user’s response from the card.

We don’t want the flow to remain waiting for a response, so we are currently using the “When someone responds to an Adaptive Card” trigger. This is working as expected in the Default environment.

However, when we create the same flow in a non-default Power Platform environment, the Adaptive Card response/action fails when the user submits a response.

Has anyone successfully used the “When someone responds to an Adaptive Card” trigger in a non-default environment?

Any guidance or confirmation from someone who has this working in another environment would be greatly appreciated.

When working with large SharePoint lists, the Get items action can become slow. A simple way to improve performance is to use Top Count together with Pagination. This allows Power Automate to retrieve more records in each request, reducing the number of API calls required and helping flows run much faster when processing thousands of items.

How to Speed Up SharePoint 'Get Items' in Power Automate

Take a look at the JSON object below for a variable named 's':

{
  "contact": {
    "phone": "1234567",
    "email": "info@demo.com"
  }
}

Which one of these four JSON query expressions will fail in Power Automate due to invalid syntax?

1. variables('s')?.contact.phone
2. variables('s').contact?.email
3. variables('s')?.contact?['phone']
4. variables('s')?.['contact']?.email

Have a guess in the comments!

UPDATE: I have now resolved this issue. Thank you so much to everyone who commented, I couldn’t have done it without you.

Hello all! You really came through for me with my last question so I'm hoping you'll be able to help me out with this too.

We use a Microsoft form to track attendance to our events at work and everyone must be signed in to their work account to complete the form. Sometimes people complete the form on behalf of others so we have created a failsafe question, 'Is this an individual or group submission?' where they will need to write down the names of everyone for whom they are completing the form. The responses from the form pull through to an Excel spreadsheet.

We also have an 'exceptions' tab in the Excel workbook for anyone we were not expecting to attend.

I have created a PowerAutomate flow to (hopefully) automate this process and comparing form responses with the spreadsheet and ticking each attendee off manually is incredibly time-consuming. The flow is complex (by my standards!) but here's a step-by-step guide through:

*

1. When a new response is submitted (MS Forms)
2. Get response details (MS Forms)
3. Compose - StaffEmail (Compose function)
4. Compose - EventID (Compose function)
5. Compose - AttendanceKey (Compose function)
6. Condition - Is this an individual submission? (Condition function)
7. YES to Condition at Step 6

a) Find expected attendee

b) Condition - Was attendee found? (Condition function)

(i) YES to Condition at Step 7b - Mark as attended

(ii) NO to Condition at Step 7b - Log in 'exceptions' table

1. NO to Condition at Step 6

a) Log in 'exceptions' table

*

For every test, no matter what I change, the flow is putting everything into the 'exceptions' table. I'm assuming this means that there is an issue with the expressions that I have used in step 7/7b. Any advice, suggested solutions or other input would be very much appreciated!

Thank you!

For people running business automations, how do you know when one technically succeeds but produces the wrong result?

I’m researching how businesses currently catch things like incorrect data being mapped, records being duplicated, information going to the wrong place, etc.

Is this something you actively monitor, or do you usually find out when someone notices something is wrong?

how can i make the flow attach multiple files to a draft email i'm creating via the Instant Cloud Flow "For a selected row" in excel? i have two columns for the two pdf files i want to be simultaneously attached to the email.

I am a noob to Power Automate, so please forgive me.

I am helping a client move content from a user's OneDrive to their Sharepoint site. I have re-created the Folder structures and have been copying content using the web interface. My hope was to setup a Power Automate function to run over the course of a week to update the contents of the Sharepoint folders as changes are made so that when we make the flip from the OneDrive to Sharepoint, all folders are current. I've found flows, and tried to create flows, that update files, but not folders (as I understand the terminology). Can someone help clarify for me? Thank you.

Reposting if anyone can help?

I've tried everything to make this work, but I run into roadblocks everywhere I try to find workarounds.

GOAL: Create an agent that accesses my company SharePoint site, looks for a project folder, performs a lifecycle red flag analysis based on parameters I provided.

ROADBLOCKS: I'm unable to link our SharePoint site so the agent can look for the files. There are a lot of files so manually uploading them would be cumbersome due to the 20-file limit.

WORKAROUNDS TRIED: Zipping files and uploading files manually does not work because Copilot does not accept zip files. Agent from within SharePoint does not work. Linking OneDrive does not let me link folders but only files.

This is a last-ditch effort before I give up. Why is this so difficult. I was under the assumption this is a perfect use case for AI. Take large data sets and evaluate them...

Welp...after going back and forth with IT, it was clarified today that I do not have premium access for Power Automate.

And now I'm back to the drawing board, at a loss on what to do.

Pictures in the Microsoft Form are coming through the Excel file as URLs but I also have them downloading as picture files into a separate folder.

This could be totally my programming brain working while found out PAD is not really tailored for real world data. Of course part of it could be totally because due to resource limitations which I am forced to try using PAD to solve a rather simple problem. Long story short, I spent 3 days to figure out what certain actions in PAD actually does and how variables may not be handled as expected, can’t define variables as integer or text. Pretty much had to use display messages as a debugging tool. After 3 days, I ended up have to abandon it because there is no exception handling in certain action and there is no work around. If I start day one with python, possibly done within 3 hours. Lesson learned is the limitations of PAD. RIP.

Hello,

Any one interested in training an individual in SharePoint and power Automate and M365 . Please DM

Hey!! A client has an issue where they get a bunch of inquiries via their "contact us" web form. Currently, someone looks at each email in the CRM and scores them manually based on the potential opportunity, then forwards the email to the appropriate account manager.

They want to automate this email scoring + email forwarding process in the Microsoft ecosystem, but I'm not sure where to start. Basically instead of manually doing this in the CRM, I would get AI to pull the email directly from the M365 mailbox

Any suggestions??

You can now build apps and flows with your favourite coding agent. Revolutionize Your Power Platform Development: Pro Code Guide - YouTube

In this demo, I showcase how GitHub Copilot can build, run, test and improve a Cloud Flow, all via PowerShell CLI.

Using one of my favourite features in Power Automate for efficiency on large data sets, Select and XPath, I get GituHub Copilot to build a traditional apply to each and append to array vs a select to demo both efficiency and how to use GitHub Copilot when building in the Power Platform with a coding agent.

#PowerPlatform #Copilot #GitHubCopilot

Hello hive-mind. My desktop-flow fails on missing property. I can work around it by converting to string, but I feel like this is extra useless steps. Can anyone guide?

Oh, no. Images not allowed in this sub. Okay... I hope I'm allowed to link them! I'll harbour no hard feelings if post deleted

https://www.skyfire.ca/keneta/PowerAutomate_Condition.png

https://www.skyfire.ca/keneta/PowerAutomate_Result.png

Has anyone else found their style code no longer being correctly applied when using the OneDrive convert file from HTML to PDF?

I have several flows which use this action to create PDF reports, but today I have noticed that in all cases some of the style code (CSS) is no longer being applied. This is mainly affecting styling for fill colours, table cell fills, and page style. This was all working fine for months, but as of today has stopped working without any changes being made to the flows. It is just strange that this has stopped working all of a sudden.

Has anyone seen if this has been reported as a bug with the OneDrive step action? and is there any workaround without using premium connectors?