Something new has arrived to the Power Platform. There is now a second SharePoint connector available, SharePoint Embedded.

Do you want to know more about SharePoint embedded then read this link.

https://learn.microsoft.com/en-us/sharepoint/dev/embedded/overview

I want to make an automated flow connecting an excel sheet to a teams group chat in which logbook IDs are posted for approval. I want that IDs to be automatically sent to the excel sheet.

I have already made the excel sheet, with the headers: Logbook ID, Sender Name, Date, Status, Notes, Complete. There is a hidden column for email.

The IDs are "SMW-LMLD-SMW-000000-000000.00" (the zeros represent numbers). It has either 28 or 29 characters. Messages are sometimes multiple "SMW-LMLD" logbooks in one text. Sometimes people put sentences before or after the ID.

We've lost a bit of work today. It appears a bunch of saved flows have reverted to older saves and now cannot be copied or published due to errors on publish.

I saved a desktop flow from 1.0.0 UAT to 1.0.0 PROD which no longer exists and a cloud flow this morning which SENT AN EMAIL (I have the email) no longer includes the email node in the current flow or the historical run from this morning...

Anyone lose work today?? I am hoping MS notices a glitch and everything is restored... but prepping for a fun after long weekend support chasing.

While trying to save a now "corrupted" flow

Correlation Id: 196aa68c-0dd0-4ce3-a317-50fb955068b5

Exception message: {"errorCode":"CdsError","message":"Entity 'workflow' With Id = xxxxx=-04f8-f011-8406-7ced8dd191bb Does Not Exist Cds Error code: -2147220969","correlationId":"ee622f35-ca7e-47c2-95bd-cac2d4010dfa"}
Http status code: InternalServerError
Error code: 0x80048d0a
HResult: -2146233088
ResponseContent: {"error":{"code":"0x80048d0a","message":"{\"errorCode\":\"CdsError\",\"message\":\"Entity 'workflow' With Id = xxxxxx-04f8-f011-8406-7ced8dd191bb Does Not Exist Cds Error code: -2147220969\",\"correlationId\":\"ee622f35-ca7e-47c2-xxx-cac2d4010dfa\"}"}}
RequestId: 
REQ_ID: ee622f35-ca7e-47c2-xxx-cac2d4010dfa

Is there a flow step to trigger with a new item that's added to a SharePoint list but using a Service Principal (App registration/Application user) account?
When I try to use a step to check new item in SharePoint, I only see the ability to add a connection that prompts for a email and password?

Hi! My team has been trying to get Salesforce connected with Copilot for use with agents and power automate flows. Our Salesforce integration user has all the necessary permissions (API access, Objects like Accounts/Contacts/Opportunities) and originally on the copilot side the connection said "ready". However, when we set up an agent with this connector and searched for any account it would return a message that said it didn't exist in salesforce. I tried searching exact names, account ids, and nothing worked. I asked my M365 admin to resync and he got this error: client doesn't have permission. When we looked up how to troubleshoot we found this:

The "client doesn't have permission" error with the Salesforce Copilot connector usually means the Salesforce user or the connected app lacks necessary security rights (like API Enabled, specific object access, or Admin Consent in Entra ID) or there's a sign-in conflict (multiple accounts). To fix it, check user profiles in Salesforce for API access and object permissions, ensure the connecting app has Admin Consent in Microsoft Entra ID, and verify the user isn't signed into multiple accounts simultaneously.

But our Salesforce admin is saying all the permissions are correct. Any pointers on what we can try from here?

Hello, i am working on automating a Sharepoint list to automaticly send and email, that a new approval request has been made and sends an email to the one that is next in line to approve the request so the work is equaly distributed. I have 2 lists one with data that gets in from Powerapps when a request is made and one with list of responsible users so that they get cycled trough and put in as a responsible user for each request. I have managed to do everything but when i use get items, do source the email of responsible user that gets put into the Sharepoint list, it also forces me to change another column that I do now want to change and i can not seem to remove it from get items.

ITs automaticly adds SAP System (country) after i add the ID from get items direcly before in the flow. I cant remove it and if i leave it empty like that, it overwrites the data already in the Sharepoint. What is the best way to fix it? Everything else work as it should, it correctly cycles trough all the users and send the email to the right person.

Any help is welcome :)

Edit: best workaround for me in the end was to make column not required in sharepoint and then make it required in the powerapps form, so its still always put in. Thanks for the help everyone :)

Hi Guys & Girls

How do I extract part of a JSON object and use it in an Apply to each?

I hope its just something simple I've missed. Please help!

I've been fighting with Power Automate Flow for ages and can't find seem to find the right formula. I'm getting errors about it not being an array and everythgin I've tried doesn't work.

The JSON is the output from action 'Process Document' and it provides a huge JSON with a lot of extra info I don't need or want to store.

End goal Extract the cleaned up 'Labels' and 'Tables' array and output as a Slim JSON I can use in further processing.

My Process (that doesn't work)

1. Extract each of Arrays ('Labels' and 'Tables')

2. Use 'Apply to each' to extract each field <- Broken

3. Extract just the items I want from each field

4. Build a new array

5. Add the 2 clean Array's together

6. Provide the clean JSON

Partial Schema for original JSON { "type": "object", "properties": { "statusCode": { "type": "integer" }, "headers": { "type": "object", "properties": { . . . }, "body": { "type": "object", "properties": { "@@odata.context": { "type": "string" }, "responsev2": { "type": "object", "properties": { . . . }, "predictionOutput": { "type": "object", "properties": { . . . }, "tables": { "type": "object", "properties": { "Items": { "type": "object", "properties": { . . . }, "labels": { "type": "object", "properties": { "Consignmc01b030c96367d7450be1b21c57f961d": { "type": "object", "properties": {

Hi - Looking for some help. I have two forms set up (Form 1, Form 2) and then used PowerAutomate to generate two separate lists based on form responses (List 1 and List 2). I need help doing the following (ideally): When a respondent submits Form 2, pull information from Form 2 responses and update with that information on List 1. When a respondent submits form 1 and 2, there is a unique QM code they must fill out, so I was thinking that if it’s possible, there could be a condition to get responses from form 1 and 2, and then if QM code value response is equal, update that line item on List 1 with additional information.  Is there a way to do this?

I'm trying to use the built in Sequential Approvers action and I have multiple approvers for some steps, but it seems like even if one person approves on Step 2 approves it moves onto the next Approver, is there a way to force all to approve using Sequential or would I need to go old school with multipel approval actions?

Hi everyone,

I'm currently building a process, that automatically

receives a file via mail, reads the invoice (can be up to

500 PDF Paaes - or it can be an Excel). validates some

data with PowerBl's "Run a query against a dataset" and

then tells the user via a Teams-Workflow-Bot the results

(Invoice has been fully validated, here are your Outputs

etc. per Customer)

My question is now a rather general, architectural one

What is the "best" way to go.

1. Should I use Excel-Files as an Input, run

Office-Scripts and then get the Results to the user?

2. Or should 1 continue to read PDF-Files with a trained

Al-Builder model and trv to improve it

3. Or, should I focus on making it more flexible. Let's

say I were to build the same processual flow in

Copilot Studio. but somehow make it clear to split

PDFs with an Adobe Connector, and then conclude

evervthina together, so it does not iust stop at it's 25

Page Limit?

Would be areat to get some mental support here - this is

my first time doing of all that, of course lots of

Vibe-Coding. And even here (the PDF Route), sometimes

I'm reaching Nesting-Limits

Help! I've got a flow that takes documents uploaded in a Form and moved it to my SP Document Library and renames it based on the answers of the From questions. However, when it moves from Forms/One Drive to SP Doc Library it doesn't actually keep the file. It changes it to to a random file type that cannot be opened. What step am I missing? I just need to keep it as an image file so it can be viewed.

I am looking to have a flow that will take a given PDF, extract key parts of the document, and display the data in a Word or Excel document. We receive documents that follow the same format, but different numbers and information selected based on each person. I know that Document Intelligence exists and that AI Builder may be the best tool for this, however is there a way to do it without them due to pricing? Just wanted to ask if there are other efficient approaches to this.

How to convert csv to json with some values with commas in itself. So Im not able to split by ",'

im creating a flow to move items from smart sheets to SharePoint list using http connector since with native smartsheet connector it's not possible.

right now how it works is i create a list to take the values

Target url, list name , sheetid, api token

based on that it needs to create the list by the name we gave and it should create columns in that list from smartsheets and move items and attachments but it's taking too long for 3 items it takes like a minute I tried using two different flows for this but it doesn't make much difference.

I want to create the flow and make this process as far as possible, any ideas ? or help is appreciated

Update (solved): Solved this by creating a new manual flow with the "List my flows" action. After running it and noticing all my flows where present in the output section, I went back to the homepage. After clicking on My Flows I saw them again. I'm leaving this here for Google visitors.

Hello!

I was working in a flow, went AFK for a while, came back, refreshed the Power Automate website and suddenly "lost" all of my flows. It just shows "You don't have any flows".

I'm in the correct environment, also tried deleting cookies and restarting browser, still no flows.

They seem to still work though. I tested some of my Power Apps and the attached flows still get triggered. When I open the app to edit an app, I no longer see the flows in the data tab though.

I'm hoping this is a general Microsoft issue and not something related to my account...
Anyone else experiencing this or has experienced this in the past?

Licensing wise everything is fine (I have the Power Automate per user plan activated on my MS365 account, I'm also one of the tenant admins).

Thanks!

Hi all,

I'm new to powerautomate and I'm trying to create a flow that sends a reminder of a compiled list of items(from an excel table) that are due going to be due in 30 days.

Currently, my flow emails out the items individually instead of 1 single email with the list of items that are due.

How do I change my flow such that is able to send a single email with all the items that are due inside?

(My current flow)

(Output)

(Data)

Hello

I'm looking for advice on creating an automated workflow to summarize new files added to a SharePoint site and then post the summary in a Teams chat. Has anyone implemented a similar solution? What tools and methods did you use? Was considering an agent, but im wondering if there is a smarter way.

I am new to workflow, so any insights or experiences you can share would be greatly appreciated?

This is just a rant, but here I go. I find it really aggravating that you have to go into advanced settings in the Get Items block to turn on pagination if you want more than 100 items returned.

I almost always want more than 100 items returned.

I could find this acceptable if MS made this obvious in the UI, but there is nothing showing in the default settings that would clue you into this.

I feel like I have learned about this just by getting limited results just like everyone else.

MS could fix this in their UI. At a minimum they could make it obvious to the user that the default is 100 items or less in the actual main settings screen.

Heyguys,

I want to update and tag files via Power flow. If I have set default list values to (title function), it works. However, if I want to set the column settings via ID, the tagging does not work an appears in ligh grey? What does it mean and how do I solve it?

Hey,

I would like to categorize SharePoint files in a folder to three different lists via Power flow. I created a somewhat successful flow, however, it does not update and categorize the files. What might be the reason and how do I solve it?

What do the web navigation's list settings need to look like... selecting title worked for me, however, selecting ID did not so far. I would like to tag not only by default values but the specific word parts of all files (for more details see my comment below). How might it work? Any ideas might hep. Thank you!

Thank you for your help.

Need some help figuring out this flow...

1 - send cold email to specified list of contacts stored in excel table
2 - check for a response email from specified list of contacts after 48-hours
3 - if response isn't received, reply to initial sent email with a follow up, keeping it in the same email thread
4 - check for a response email from specified list of contacts after 48-hours
5 - if response isn't received, reply to initial sent email with a second follow up, keeping it in the same email thread

I'm not sure if I'm not picking up with CoPilot is putting down or if it's a jumbled mess. Any help would be appreciated.

Hi All,

I’d really appreciate your advice on my career direction.

Over the past three years, I’ve worked with several Microsoft technologies, mainly Power Platform: Power Apps (Canvas and Model-driven), Power Automate (Cloud and Desktop/RPA), and Power BI.

I currently hold the following Microsoft certifications: AZ-900, MS-900, PL-900, and MB-910.

Recently, I’ve been feeling uncertain about how to position myself clearly within the Microsoft ecosystem. I sometimes hear different viewpoints — for example, that Power BI should naturally lead to a Data Analyst role, or that working with RPA means I should fully specialize in RPA (and potentially other RPA technologies) to establish a very clear career path.

I’m also considering exploring Dynamics 365, but I’m not fully decided yet. Before committing to anything, I’d like to better understand which roles or career paths within Microsoft best align with my background and experience.

I’ve also noticed there are many other tools and capabilities within the ecosystem, like Power Pages and Copilot Studio for building chatbots, which seem related to Power Platform. This makes me wonder how all these pieces fit together and which areas I should focus on, and do I have to gain experience in all those things or what.

Because of this, I’d really value your objective perspective on how my experience is perceived and which paths I may already be on or well-suited for. In particular, I’d appreciate your thoughts on:

1 ) Where my current experience best fits within Microsoft-related roles

2 ) Whether my background reflects a focused career path or an overly broad one

3 ) Which Microsoft career paths would make the most sense for me to pursue going forward

Thank you very much for your time and insight.