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

(0) Share

Report

Posted on by MCeron98

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!

@Pstork1

@faustocapellanj

@v-litu-msft

(sorry for bothering you guys!)

All responses (2)

Answers (1)

MCeron98 27 on at

Like (0)

Report

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

Many thanks!
Verified answer

Pstork1 66,820 Most Valuable Professional on at

Like (2)

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

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