web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Power Automate - Plann...

Power Automate

Answered

Power Automate - Planner - Read Additional Lines from Notes/Description Field

(0) Share

Report

Report

Posted on by richardsharma

16

Hi,

I am new to Power Automate, recently I had seek assistance with reading content from the Notes/Description field within Planner using Power Automate (Solved: Email to Submitter of Forms - Power Platform Community (microsoft.com)

The solution to this flow was to use

trim(first(split(trim(outputs('Get_task_details')?['body/description']),decodeUriComponent('%0A'))))

This as I understand it reads the first line within the Notes field.

I was wondering if something similar would be able to also ready other lines within the field? Eg. 4th Line or anything after a certain keyword.

Thanks,

Richard

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @richardsharma ,
If you want to extract the fourth line in the Notes field, modify the expression and change "first" to [3].
trim(split(trim(outputs('Get_task_details')?['body/description']),decodeUriComponent('%0A'))[3])
If you want to extract anything after a certain keyword，
trim(split(trim(outputs('Get_task_details')?['body/description']),'keyword')[1])

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
richardsharma 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,

Thank you very much for your assistance, this works exactly how I wanted it to.

Kind regards,

Richard

Was this reply helpful? Yes No

Join the conversation