Answered

Avoid List items duplication from categorizied emails

(1) Share

Report

Posted on by Larry_57330

Hi there,

I want to build a flow for the management of our shared mailbox. what happened is that email that required action are often overlook. So I want to create a list item in a "do to" list from emails have been categorized.

So I've build a scheduled flow that check every 15 mins all the emails in the mailbox that have been categorized as "to do" and create a item in a list.

So far so good, but the hiccup is that it duplicates items are it looks at all the emails that have a category. Even the ones that have been already considered.

I'm wondering how I can avoid this duplication 🤔

Any idea ? Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Tomac 4,048 Moderator on at

Like (1)

Report
Copy link

Link copied!

In your list, record the Conversation ID for the message. Then before adding an email, first use a Get Items action looking for that Conversation ID and if the length of the results is 0, then create the new item.

1 people found this reply helpful.

Was this reply helpful? Yes No
Larry_57330 21 on at

Like (0)

Report
Copy link

Link copied!

@Tomac

Thanks for the feedback, everytime I get an error:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')?['conversationId']' is of type 'String'. The result must be a valid array.

Was this reply helpful? Yes No
Tomac 4,048 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Larry_57330 Can you post a screenshot of your flow with the actions expanded in edit mode so I can see exactly what you're working with?

Was this reply helpful? Yes No