SOLVED

Flow to look for blank fields in a SharePoint list - then email the row owner (person)

%3CLINGO-SUB%20id%3D%22lingo-sub-3354487%22%20slang%3D%22en-US%22%3EFlow%20to%20look%20for%20blank%20fields%20in%20a%20SharePoint%20list%20-%20then%20email%20the%20row%20owner%20(person)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3354487%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20folks%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20Power%20Automate%26nbsp%3B%20and%20was%20hoping%20someone%20might%20be%20able%20to%20help.%20I%20have%20multiple%20SharePoint%20Lists%20that%20I%20manage%2C%20looking%20for%20help%20on%20a%20flow%20that%20will%3A%3C%2FP%3E%3CP%3E-%20On%20a%20recurring%20basis%3C%2FP%3E%3CP%3E-%20Go%20to%20a%20specific%20list%20on%20a%20SharePoint%20site%3C%2FP%3E%3CP%3E-%20In%20all%20these%20lists%2C%20each%20row%20has%20an%20owner%20-%20a%20field%20set%20up%20as%20a%20person%20or%20Group%3C%2FP%3E%3CP%3E-%20If%20there%20is%20missing%20data%2C%20in%20two%20other%20specific%20fields%20in%20that%20row%2C%20i.e.%20if%20X%20field%20and%20Y%20field%20are%20blank%3C%2FP%3E%3CP%3E-%20then%20send%20an%20email%20to%20the%20person%20associated%20with%20that%20row%20in%20the%20list%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3354487%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3354651%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20to%20look%20for%20blank%20fields%20in%20a%20SharePoint%20list%20-%20then%20email%20the%20row%20owner%20(person)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3354651%22%20slang%3D%22en-US%22%3EShould%20be%20pretty%20simple%20to%20setup%2C%20just%20will%20take%20a%20bit%20of%20logic%20to%20build%20into%20the%20flow.%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Create%20a%20schedule%20flow%3CBR%20%2F%3E2.%20Use%20Get%20Items%20from%20List%20sharepoint%20action%20with%20a%20filter%20of%20%3CCOLUMN%201%3D%22%22%3E%20eq%20Null%20OR%20%3CCOLUMN%202%3D%22%22%3E%20eq%20Null%3CBR%20%2F%3E3.%20Apply%20to%20Each%20action%20using%20the%20output%20of%20(2)%20-%20send%20an%20email%20to%20the%20owner%20or%20item%20found%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20is%20the%20logic%20process%20you%20need%20to%20implement.%20Search%20for%20SharePoint%20REST%20query%20to%20workout%20the%20specific%20syntax%20or%20you%20could%20use%20a%20conditional%20action%20and%20perform%20the%20%22If%20Column1%20is%20Null%22%20do%20and%20action%20also.%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20Fun!%3C%2FCOLUMN%3E%3C%2FCOLUMN%3E%3C%2FLINGO-BODY%3E
New Contributor

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

- Go to a specific list on a SharePoint site

- In all these lists, each row has an owner - a field set up as a person or Group

- If there is missing data, in two other specific fields in that row, i.e. if X field and Y field are blank

- then send an email to the person associated with that row in the list

 

Any ideas?

 

Many thanks

1 Reply
best response confirmed by Sandylala0202 (New Contributor)
Solution
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!