Hi @Shannon_Marceau,
Would you like to check the empty of SharePoint list within a Microsoft Flow, or in PowerApps?
If only for Microsoft Flow, would you please share your Flow configuration?
I will share an example here.
1.We add the SharePoint->When an Item is created Trigger, then add a Compose Action,
2. Under Compose Input, input the following to check whether Email field is empty:
"@if(empty(triggerBody()?['Email']),2,1)"
3. After Compose Action, add a switch, use Compose Output as the value
4. Case one value set to 1, case two set to 2,
5.Under Case one with the Value set to 1, add the Send an Email action, save your flow
If the Email field is not empty, then Case one would be triggered, which will then trigger the Send Email Action.
You may take a look at the following thread as a reference:
Calculate variable by Compose
Additional reference:
Workflow Definition Language
If within PowerApps, formula should be:
If(IsBlank(lookup(list, formula to lookup the special value)),2,Office365.SendEmail("EmailAddress","Subject","Body"))
Which would need to add the Office 365 Outlook Connection first.
Formula reference:
IsBlank and IsEmpty functions in PowerApps
Please reply back if you need any further assistance.
Regards
