I have a really simple workflow to send an email when a sharepoint form is created AND approved. I've tested it out a million times now and it runs and sends emails successfully. Yet when actually used in action it refuses (sometimes) to send an email with the condition's expression coming back as False. how can i fix this to make it more stable?
I am having the same issue. I have a condition looking for a department number. I probably have 20+ items a week run through the process and 4 or 5 return false. Then when I go in and hit resubmit it runs properly and flags the department number as true.
Thank you i didn't think of that!
"save it (so now it is in a pending state) then approve it"
Your flow is only triggering right now when an item is Created, not when it is Modified - so it will not trigger when you approve it.
If it will only ever be created and THEN updated to Approved (far more likely!) then you should change your trigger to 'When an item or a field is modified'. I think this will solve your issue.
im not sure i can send the outputs as it has company info on it but in testing i would make a sharepoint form, save it (so now it is in a pending state) then approve it and an email will go out. part of that output says
{ModerationStatus}":"Pending"
yet the sharepoint was approved
Can you show the outputs from your "When an Item is Created" where you're receiving a "False"?
My thought is that an item is being saved, and hitting this, before the user gets to the Status to set it.