Hi,
I am using the below flow to add / update excel data in a SharePoint list
(1)
(2)
(3)
(4)
Issue is in point 3. Whether record exists in list or not create item always gets executed. Need help.
Regards
Hi,
I am using the below flow to add / update excel data in a SharePoint list
(1)
(2)
(3)
(4)
Issue is in point 3. Whether record exists in list or not create item always gets executed. Need help.
Regards
Hi @creativeopinion . The issue was traced in the Filter query. Thank you very much.
@Sam70 I would recommend putting your expression for the item count into a Compose action right before the Condition action. The issue with using the Condition action only is it returns a true/false value only. It doesn't show you the result of your expression. Using a Compose action will help you to troubleshoot your issue.
This way you can confirm the number of items being returned from the Get Items action. If the Create item is always being executed this means your Get Items action is returning zero items. Your Filter Query may need to be adjusted if you are expecting the Get Items action to return items.
Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅. Consider giving me a 👍 if you liked my response! |