web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Catch duplicate list i...

Power Automate

Answered

Catch duplicate list items error in the flow

(0) Share

Report

Report

Posted on by xsomej33

Hi all,

Is there a way how to catch duplicate list items error in the flow and if found, not fail the flow but end it?

I have a column in the SharePoint list, where I'm enforcing unique values:

Now the flow fails (creating a new record on the list based on some condition) if there already is an item with the same value in that column:

Can I somehow catch that error and not fail the flow in such case?

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Sutherland Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Xsomej,

You could set configure run after to distinguish whether sharepoint actions failed due to 'duplicate' value with expression> actions('<Name of the action>').error.message
to keep you flow running to the end. While be note that the whole flow run status still would display as failed even it finished all operations.
Related community post for reference>
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Get-Error-code-in-flow/idi-p/278687
https://powerusers.microsoft.com/t5/Using-Flows/Get-error-message-for-the-action-on-failure/td-p/311558

Was this reply helpful? Yes No
xsomej33 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Johnnyg,

Thanks for your tip. Could you please show me the full expression syntax?
For this one:
actions('Create_item_in-pre-assessment_list').error.message
It's throwing the error below:

Was this reply helpful? Yes No
Verified answer

xsomej33 on at

Like
a
(0)

Report
Copy link

Link copied!
I was able to fix that myself using the following syntax:

actions('Action_Name').outputs.body.message
I also used that in the Compose action to get the error message as a string.

Was this reply helpful? Yes No

Join the conversation