web

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

News and Announcements icon

Power Platform CommunityForums Power Automate When I flag an email, ...

Power Automate

Answered

When I flag an email, check if Conversation Id is already written in an excel table. If not, write it

(0) Share

Report

Report

Posted on by MCeron98

27

Hi all!

Im trying to run a simple workflow in which I have an excel table with a column named ¨ConversationID¨, which has unique values. When I flag an email, the flow checks if the conversation ID is already inside my excel table, if not, write it. However im having trouble defining the condition. I tried using

length(outputs('Get_items')?['body/value']) equal to 0

equals(length(body('Get_items')?['value']), 1) 0 (the ID does not exist), or 1 (the ID exists)

However I run into this error message:

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Get_items' referenced by 'inputs' in action 'Condition_2' are not defined in the template

Thanks a lot!

@faustocapellanj

(sorry for bothering you guys!)

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Pstork1 69,657 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
You are referencing Get_Items which is SharePoint. You should be using

ength(outputs('List_rows_present_in_a_table')?['body/value']) equal to 0

Was this reply helpful? Yes No
MCeron98 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks!

Was this reply helpful? Yes No

Join the conversation