Hello, I am trying to build power automate flow when 'PO number' exists in list, then update content if not create record to the list.
Excel file contain some empty date field and I want to power automate to create record with empty field.
to let power automate accept empty field, I used expression
if(empty(triggerOutputs()?['PO_APPROVED_DATE']),null,formatDateTime(triggerOutputs()?['PO_APPROVED_DATE'],'dd/mm/yyyy'))
Flow runs with success (and somehow it repeats run 2 times with all success) but skips whole process with 'If No'
total 1102 record is run but in the sharepoint list, I only see some 800 record and new records are not added...
Can someone help?
Thanks
