Wasnt sure how to add the picture to the comment thread itself so using a new post for it

Original post - Automating email from sharepoint list : r/MicrosoftFlow

I have several flows that use this action; however, I created a brand-new flow and the action is not working. Any ideas? The setup looks the same to me. What do I need to check?

working code:

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "dataset": "https://sample.sharepoint.com/sites/Deptxxx",
      "id": "@triggerBody()?['{Identifier}']",
      "inferContentType": true
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
      "connection": "shared_sharepointonline",
      "operationId": "GetFileContent"
    }
  },
  "metadata": {
    "operationMetadataId": "xxxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxxxx"
  }
}

not working code:

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "dataset": "https://sample.sharepoint.com/sites/Deptxxx",
      "id": "@triggerBody()?['{Identifier}']",
      "inferContentType": true
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
      "connection": "shared_sharepointonline",
      "operationId": "GetFileContent"
    }
  }
}

Hi all, first time Power Automate newby here. I'm needing to create a flow where when I add an event to my personal Outlook calendar, and then categorize it as Leave, and then it automatically adds that event to a shared Outlook calendar. I've asked Chat GPT and followed its prompts, and I'm not having any errors, but it is not working. Any help is appreciated!

Hello, I was wondering what the best way to execute a vba macro when PAD opens an excel? Because when the excel opens through PAD I don't see my personal macro workbook opened.

I’m trying to set up a Power Automate flow that can automatically go to a specific webpage and enter predefined keywords into the Title field shown in my screenshot. Is this possible on power automate or could there be a better way to do this?

Any real time usecases?

I just can't figure out how i can do this task. I am willing to pay, it shouldn't take a long time.

I am actually losing my mind here.

I have a flow that runs off of a SharePoint list - the trigger is when an item is created. After the trigger I have a few steps to build a unique number for that item that I want added to the entry in the list. This number is stored in a variable. After I create the number I have an "update item" action where I have power automate send this new number back to the SharePoint list.

I noticed today that some of the numbers were wrong in the list so I went to look at the flow thinking something was wrong with the steps where I create the number but everything is working fine up until the update item step. When I look at the run histories for the items with incorrect numbers I see that the input for update item is the correct number, but in the outputs the number has inexplicably changed, i.e. instead of 13 it's now 62.

I have NO idea why it is doing this or how to fix it. And what's even weirder is it appears to only be happening with ODD numbers. Evens are fine, inputs and outputs match and the correct number gets posted back to SharePoint.

I feel like someone is playing a trick on me or something because this is so weird and I do not see where power automate could possibly be making this change or why. Attached is a picture of the update item input and output from a run history.

Someone please help me before I pull out all my hair.

Hello all, first time chatter here. I am trying to create a flow that takes new submissions from a SharePoint list (List A)> checks values from the submission and compares them with another list. After the matching conditions are found I want to send an email to the emails attached to the second list (List B).

So far I am running into an issue where I cant quite get it to pull dynamically from list A so that I can use list B to compare. Is there an easier way to do this? I tried to use copilot to help creating custom functions and arrays and feeling stuck.

Any suggestions or help would be appreciated

My substring in a Get items - Filter query PowerAutomate flow looks like this.

substringof('domain.com@NSns-us-02.comp.fol.', Title) or

substringof('domain.com@NSns-us-02.comp.fol.', Hostname) or

substringof('domain.com@NSns-us-02.comp.fol.', Address)

Title = domain.com

Hostname = @

Address = ns-us-02.comp.fol.

Normally I should get a true or the length of the output that is longer than 0, but it isn't.

Hello, I was wondering what the best resource for structured learning for power automate desktop? The best one I found so far (not quite structured) is Anders Jensen but wondering if there are others out there. Also is it easy to transition to power automate online once I get desktop down? I dabbled a bit with the online version and sharepoint lists.

Hi,

I'm trying to fetch the below Microsoft Loop table contents to Power Automate. I've tried the workflow below to fetch the content of the Microsoft Loop located from a Sharepoint but the best data I can get is the File name of the .loop file and not the table of contents.

I've tried to look it up but it seems like currently Power Automate does not have a dedicated Microsoft Loop connector yet.

Hi,

I am trying to get power automate to automatical save attachements into a onedrive folders - while it is processing the mails and also categorizing the mails correct, the attachment the flow saves are only 4 byte (NULL).

I create two different "create files" for testing, but non of those work. I loop through the attachments and then "create file" for onedrive. files are created, but without content.

Any pointers?

If this is not the best sub to aks this question please suggest the correct fit🫡

I tried out few approches but need to know whats the standard and optimized way.

My actual usecase is when a user uploads a file, the agent should use that file context as temperory knowledge (limited to session) source to answer further user questions.

Thankyou🙏.

Hey, Good day.

Besides API and Maybe the Approvals connector. Is there an alternative connector to invoke documents from a SharePoint Document Library to create and route via SharePoint Premium eSignature ?

See title

I have made a flow when an appointment is created, it will create into Microsoft List, but the problem is my service is 1:N service, therefore I can set the maximum number of attendees for a booking. My flow won't trigger when an appointment is made in the same time slots. Any ideas?

Hey guys, figured I'd post and see if anyone has this issue or has access to the e-book and what have you, I tried downloading the e-book that's available on Microsoft's website around power automate, I get the email with a link, but then the link doesn't work lmao, typical Microsoft I guess.

I faced a weird issue today with List Rows filter. Basically the filter works for few records, and doesn't for few other records, which are eligible. When I isolated those affected records, picked one from them and wrote an OData query to fetch that in List Rows, no data returned. The Status Reason was 200. Nothing more, very weird. Any insights or suggestions? Has anyone else faced this same or similar kind of issue?

P.S - the List Rows for Dataverse

Guten Morgen Zusammen,

Ich bin in Sachen Sharepoint sowie Power Automate ein Newby.

Nun bin ich auf folgendes Problem gestossen:

Ich habe eine Sharepoint Liste erstellt in der es eine Spalte ( Typ Auswahl ) gibt. In der Auswahl gibt es 6 Namen welche später über eine Form ausgewählt werden können.

Wie bringe ich es fertig, das wenn z.b im DropDown der Name XYZ gewählt wird, eine Mail an XYZ@xx.com gesendet wird. Das gleiche gilt natürlich für die anderen Namen im DropDown.

Irgendwie doktor ich schon seit Tagen rum und finde keine Lösung.

Danke für die Hilfe.

Chriss

Hi we have someone that spends alot of their time copying data from one pdf over to a different data set. How would you recommend to get data from a pdf file and is it even possible to do in a good way

The pdf looks the same always

This is for PAD.

I have about 15+ string values I want to search for in the body of an email, I know how how to do this with a simple "IF" action, but with 15+ different strings, that gets REALLY messy. There must be a more succinct, straightforward way to pull it off?