cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Julien2
Super User
Super User

Check for null values columns and send reminder

Hello,

 

I am planning to create a scheduled workflow that triggers every 2 hours which will check the SharePoint list entries and send a reminder email about the missing values that are not filled by the user meaning the columns that are null. (Up to 25 field should be checked)

 

Example:

Julien2_0-1670577948395.png

Assume that the user didn't fill the Description or Quantity or Unit Price and he submitted the request. The workflow should fund this entry and send the email.

 

The above example is showing 3 fields but in a real scenario where we have  more than 25 fields and we cannot do all of them as required so how can we handle it in the "Get items" adding 25 OR condition or there is a better way to achieve that?

 

Any help is greatly appreciated.

 

Best regards,

Julien

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @Julien2 

 

Declare an array with all the field names. Dynamically access the field names under one IF condition. Here it is.

 

image.png

image.png

 

Above expression is as follows:

 

split(variables('FieldSchemaNames'),',')
image.png
 
The second apply to each loop is mapped from the split() compose earlier.
 
Inside the second loop compose expression is as follows:
 
items('Apply_to_each')?[item()]
 
For the IF condition expression I am checking the length().
 
length(outputs('Compose'))
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

2 REPLIES 2
abm
Super User
Super User

Hi @Julien2 

 

Declare an array with all the field names. Dynamically access the field names under one IF condition. Here it is.

 

image.png

image.png

 

Above expression is as follows:

 

split(variables('FieldSchemaNames'),',')
image.png
 
The second apply to each loop is mapped from the split() compose earlier.
 
Inside the second loop compose expression is as follows:
 
items('Apply_to_each')?[item()]
 
For the IF condition expression I am checking the length().
 
length(outputs('Compose'))
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Julien2
Super User
Super User

Hello @abm ,

 

Thank you so much for providing an example.

 

I will replicate the same scenario and let u know if any assistance needed.

 

Best regards,
Julien

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,085)