Forum Discussion
Solved
Flow to look for blank fields in a SharePoint list - then email the row owner (person)
Hello folks, I am new to Power Automate and was hoping someone might be able to help. I have multiple SharePoint Lists that I manage, looking for help on a flow that will: - On a recurring basis ...
- Should be pretty simple to setup, just will take a bit of logic to build into the flow.
1. Create a schedule flow
2. Use Get Items from List sharepoint action with a filter of <Column 1> eq Null OR <Column 2> eq Null
3. Apply to Each action using the output of (2) - send an email to the owner or item found
That is the logic process you need to implement. Search for SharePoint REST query to workout the specific syntax or you could use a conditional action and perform the "If Column1 is Null" do and action also.
Have Fun!
Should be pretty simple to setup, just will take a bit of logic to build into the flow.
1. Create a schedule flow
2. Use Get Items from List sharepoint action with a filter of <Column 1> eq Null OR <Column 2> eq Null
3. Apply to Each action using the output of (2) - send an email to the owner or item found
That is the logic process you need to implement. Search for SharePoint REST query to workout the specific syntax or you could use a conditional action and perform the "If Column1 is Null" do and action also.
Have Fun!
1. Create a schedule flow
2. Use Get Items from List sharepoint action with a filter of <Column 1> eq Null OR <Column 2> eq Null
3. Apply to Each action using the output of (2) - send an email to the owner or item found
That is the logic process you need to implement. Search for SharePoint REST query to workout the specific syntax or you could use a conditional action and perform the "If Column1 is Null" do and action also.
Have Fun!