Hi @Bhanu2023 ,
Here's one way to do it; the was successful in my tests when an item updated successfully and when an email needs to be sent out because one or more P1-P5 items were missing/blank. Here's the flow:
My filter query in List 1 Get Items is comparing List2 (Title and ProjectID) to List1 (Title and ProjectID) - in your case you would be comparing ID and ProjectID's but same concept. That's going to pull back the one item in List1 that matches List2.
Next I have a condition that says, if any of the items P1-P5 are empty, return true or false.
The expression is empty(dynamic List1_P1) - for P1 as an example.
So, if any of the items P1-P5 are blank, we send an email to someone asking them to go update List1 with the missing information. If they have any value, other than null, we will update the item in List1 with the content from List2 as shown below.
Below "1" means dynamic content from List1, "2" means dynamic content from List2.
Again, in my test, I was able to see an email go out and also see List 1 get updated with List 2 item was created.
Here's the entire flow:
