Flow send emails to the user everyday . uploaded files required fields are empty

(0) Share

Report

Posted on by Yoursnani

367

I am New to flow ,

My organization required one flow that can remind everyday. User need to field the empty fields in SharePoint list

my scenario is

I have library and it has required fields in it.if I have upload 100 files at ones forget to not complete the filling required fields.

My flow need to remind everyday morning that he has to complete field fill

How can we achieve this . please help me

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

v-JessicaG-msft on at

Like (0)

Report

Hi @Yoursnani ,

You could build a scheduled cloud flow and use the "Get files (properties only)" action in the flow to check if the required fields are empty. I have test for your reference, please try the following workaround:

Best Regards,

Jessica Gu

Was this reply helpful? Yes No
soundharya 249 on at

Like (0)

Report

You can initialize array variable, get the file properties and check if your required field is empty or not
If it is empty then store the Display name of the created by user in Users array
Next add an compose step to get unique display names

union(variables('Users'),variables('Users'))

then apply each of the unique output to send the email, in the email you can create a link to the view as below
Required field and its value as empty, author is nothing but created by user and its display name which is current item
When user navigates to the link in the email, he will see all the records that are required field is empty and created by him

Was this reply helpful? Yes No
ursNani 215 on at

Like (0)

Report

@Soundharya

I am Facing error Could you please Help me .

Was this reply helpful? Yes No
soundharya 249 on at

Like (0)

Report

In email action, in To what you are giving? you have to give item()

Was this reply helpful? Yes No
ursNani 215 on at

Like (0)

Report

@Soundharya

This is the my flow . and its getting error

Was this reply helpful? Yes No
soundharya 249 on at

Like (1)

Report

You are passing users array, you need add apply each and add email inside it with item() in To

Was this reply helpful? Yes No
ursNani 215 on at

Like (0)

Report

Thank you @Soundharya

its worked. but i want added that user Name name in mail body. but i am getting only mail id

how can get same user name in mail body .

Thank you

Was this reply helpful? Yes No
soundharya 249 on at

Like (0)

Report

Created by display name attribute you can use

Was this reply helpful? Yes No