Answered

Update sharepoint item with custom text if approval comment is left blank

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've got an approval flow that uses 'Start and wait for an approval'. When the approver approves or rejects the flow the relevant sharepoint list is updated, including capturing the comment they might have added.

However, when an approver leaves the 'Add a comment (optional)' field empty rather then leaving the field empty I'd like to update the relevant sharepoint item with a default text, something like 'No comment added'.

Thought a simple expression like an if statement would do the trick but it doesn't allow me to. Any suggestions on how to accomplish this?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Gristy 2,429 on at

Like (0)

Report
Copy link

Link copied!

if(empty(body('Start_and_wait_for_an_approval')?['responses'][0]?['comments']), "No Comment", body('Start_and_wait_for_an_approval')?['responses'][0]?['comments']))

Try something like this. May not be exactly correct syntax

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please try to use the following configuration:

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks - I've tried several variations on the code you suggested but it doesn't seemt to accept that.
Might be somethign to with that if you select the 'Responses Comment' field it shows as 'Items(Apply_to_each)?['comments']' rather than the 'body('Start_and_wait_for_an_approval')?['responses'][0]?['comments']' you have used. Also, as soon as I select an expression, the option to select 'Responses Comment' disappears from the list of dynamic fields to choose from.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, yes that works. Ideally just adding an expression woud've been simpler but this works fine. Thanks!

Was this reply helpful? Yes No