Greyed out Condition on my Flow

[ZionLion]

Hi community! Im very new still trying to figure out power automate on my own. The project I have is to take emails received and transfer the email information to a SharePoint list but there should be only one item created for each unique email address.

So, what I'm trying to achieve at this stage is for my flow to detect if the item with that email address exist on my list already if it does update the item where the necessary information will be updated/appended, this part works fine (at the right of the condition). But for the condition where N equals to 0 which means there isn't any item created my "Create item" is greying out and the item isn't being created. I read two or three other threads about it telling me to check the source or saying other things I didn't really understood or could emulate to fix this. I would appreciate your input on my case because I don't understand what's going on specially when one part of the condition is working so the source seems fine?

Thank you.

[v-dezhili-msft · Accepted solution]

Hi @ZionLion ,

If you want to create new item when the email address is not in your SharePoint list, you don't have to use the Apply to each action again.

I have a test for your reference.
In my scenario, I want to save emails with different subjects, and update the SharePoint list when I receive emails with the same subject.

Best Regards,

Dezhi

[ZionLion]

Oh yes I structured the "Get Items" filter query exactly as you did (but instead comparing: Title eq '[From]'), even though I forgot to show it. Your solution worked! for some reason the flow was "applying to each" automatically when I would use "Create item" but I manage to delete it and make it again and it worked. Also thank you for simplifying the part I was using a variable since it was not working when I tried to compare the previous results directly. Thank you very much.