Answered

Channel post starts with TODO and chat details

(0) Share

Report

Posted on by whissi

Hello.

I have a challenge in the (Create a Planner task when a channel post starts with TODO) I want to be able to specify from the chat all info in the TASK for example if I type {TODO Test this Item @Xuser /test the button and get back to me / #Important } then the Power Automate will take the above and use the "Test this Item" in the task Subject and the @User will be the assigned to and the /test the button and get back to me/ will be the description and # will be the priority while the stating date will be the date and time the task was created. Or any other way to specify what to use.

Any help will be much appreciated.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @whissi ,

Maybe you could try to optimize the input statement and then extract the value of each field by expression.

I have made a simple test for your reference.

User Name:

trim(split(outputs('Html_to_text')?['body'],'/')[2])

Task Title:

split(outputs('Html_to_text')?['body'],'/')[1]

Description:

split(outputs('Html_to_text')?['body'],'/')[3]

Priority:

if(equals(replace(replace(split(outputs('Html_to_text')?['body'],'/')[4],decodeUriComponent('%0A'),''),'#',''),'Important'),3,9)

Result Screenshot:

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
whissi 43 on at

Like (0)

Report
Copy link

Link copied!

You are my hero 👍 - Thank you so much

Was this reply helpful? Yes No
whissi 43 on at

Like (0)

Report
Copy link

Link copied!

Just a question, regarding the priority, if I put low or urgent will it take it automatically or do I need to do some more functions

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @whissi ,

Maybe you could try the following expressions:

if(equals(replace(replace(split(outputs('Html_to_text')?['body'],'/')[4],decodeUriComponent('%0A'),''),'#',''),'Urgent'),1,if(equals(replace(replace(split(outputs('Html_to_text')?['body'],'/')[4],decodeUriComponent('%0A'),''),'#',''),'Important'),3,if(equals(replace(replace(split(outputs('Html_to_text')?['body'],'/')[4],decodeUriComponent('%0A'),''),'#',''),'Medium'),5,9)))

Here is a link for your reference.

https://sharepains.com/2022/01/10/task-priority-in-microsoft-planner/

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
whissi 43 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yujincui-msft Sorry for troubling you but you are the only that got to help me.
If i need to add 1 more section. Select a Bucket for example after the Propriety I add the bucket name so it goes directly to that bucket how can it be added.
Thanks again for your help

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @whissi ,

You could create a flow to get all the bucket names and bucket ids.

Then you could use the expression to extract the Bucket name from the message, and finally apply the following expression.

if(equals(value,'bucketname1'),'buckid1',if(equals(value,'bucketname2'),'bucketid2',null))

Best Regards,

Charlie Choi

Was this reply helpful? Yes No