How can I write an Approver Comment (from email) to SharePoint List?

[koontz]

After I capture a comment from an approver in an email, how can I write that comment to a SharePoint list? I'm able to capture the comment itself with no issues (see screenshot), but for some reason I can't get the comment ("3:54pm TEST Comment") written to my SharePoint list.

I'm currently trying to use <Update item> inside of a loop <Apply to each 2 >. (I didn't add the loop, PowerAutomate did that automatically, and I can't remove the <Update item> step from the loop). This keeps failing no matter what I do. Any advice would be greatly appreciated.

It fails with this message:

[annetoal]

Since you've got it showing in your Compose, why not update the Comments line with the output of Compose?

If this helped, please mark it as a Solution.

Anne

[koontz]

Yep, that's what I'm trying to do. I think the issue is either the ID or Request ID. I'm not exactly sure.

[annetoal]

Try your ideas out and see which works best for you.

[ManishSolanki]

Hi @koontz 

Please use ID in place of 'RequestID' for Id column in 'Update item' action:

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[v-wenjuan-msft · Accepted solution]

Hi @koontz ,

The "Apply to each" shows up automatically as there are more than one object (which means more than one items) got retrieved from SharePoint, so if you want update them, you need to update one-by-one.

According to the error message displayed on your snap, the "Value" you inserted in Input of "Apply to each 2" is of "Null" type which cannot be verified. You can try to surround it with an array formula like this:

1. Type in "array()" in your expression bar

2. switch to "Dynamic content" part and insert "value" in:

Not sure from which action your "value" retrieved. If it doesn't work, please attach your whole flow with actions spread for further check (if possible).

and @ManishSolanki 's advice is right, you should replace "ID" there.

Have a nice day to you all~

Community Support Team _ Wenjuan Zou

If this post helps, then please consider Accept it as the solution to help the other members find it.