Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Extracting text from SharePoint List

(0) ShareShare
ReportReport
Posted on by

Hello! I am brand new to Power Automate, and would love any help. Inside a list, I have a SharePoint List where users submit items. One of the columns, High-Level Summary, in the list includes "Multiple Lines of Text" and is where folks can submit notes.  I am trying to create an flow that

 

1. Is triggered by a new item being added to the list

2. Extracts the text from the High-Level Summary column of this new item.

3. Sends that text via email to a user.

 

I've tried different options, but I can't seem to extract the text. Here is my current flow...


Screenshot 2024-02-20 at 7.52.03 PM_Redacted.jpgScreenshot 2024-02-20 at 7.51.43 PM_Redacted.jpg


The closest I could get was an email that included this text...

 

Screenshot 2024-02-20 at 8.16.28 PM.png

Any pointers for what I'm doing wrong?

 

Thanks for any help!

  • Re: Extracting text from SharePoint List

    Hi , @sdandy_lion 

    According to your description, you have got the text from html in your flow and return the Json text string. And what value do your want to extract from the Json object?

     

    Best Regards,

    Yueyun Zhang

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard