How to use Power Automate with an Asana form ?

English Forum Developers & API
1

Hello Everyone,

I’m Nzib Ziazi, a tech enthusiast. Using Power Automate with an Asana form, I’m struggling to extract specific form fields. All data appears in the “notes” field as plain text. Is this an Asana or Power Automate limitation?

Regards
Nazib Ziazi

2

Hi @Najib_Ziazi and welcome to the forum.

You’re correct, the form responses are stored in the task’s notes field.

If your Power Automate flow needs to extract specific question responses, I recommend parsing the html_notes property rather than the plain-text notes. The html_notes version preserves question titles within <strong> tags, which helps avoid issues where a response might accidentally match a question label.

Here’s an example parsing approach I’ve found effective in Power Automate (this extracts the response for “Question 1”):

first(
   split(
      last(split(body('YourInput'), '<strong>Question 1:</strong>')),
      '<strong>Question 2:</strong>'
   )
)

Essentially, this extracts the content found between the definitions of Question 1 and Question 2. Of course, it’s important to ensure that HTML is properly escaped in the resulting values, depending on your needs.

I hope this helps!

2 Likes
3

@Najib_Ziazi , I’ll just add that it is possible for form submission question responses to be mapped to what we call custom fields which are more structured. I’m not deeply familiar with Power Automate, but assuming it can fetch custom field values on a task. Whether or not the questions map to a custom field is a decision for the form creator.

2 Likes
4

Thank you both John_Baldo and Mikhail_Melikhov!! for your valueable reply.

Regards

Najib Ziazi