web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow send emails to th...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 367

Hi 

 

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:
I have the same question (0)
  • v-JessicaG-msft Profile Picture
    on at

    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:

    vJessicaGmsft_0-1643019970067.png

    vJessicaGmsft_1-1643020065372.png

    vJessicaGmsft_2-1643020111476.png

     

    Best Regards,

    Jessica Gu

     

     

  • soundharya Profile Picture
    249 on at

    You can initialize array variable,  get the file properties and check if your required field is empty or not

    Soundharya_0-1643043629868.png

    If it is empty then store the Display name of the created by user in Users array

    Soundharya_1-1643043678173.png

    Next add an compose step to get unique display names

    Soundharya_2-1643043719973.png

     

    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
    Soundharya_3-1643043838062.png

    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

    Soundharya_4-1643043936097.png

     

  • ursNani Profile Picture
    215 on at

    @Soundharya 

    I am Facing error Could you please Help me .
    Screenshot 2022-01-25 183537.jpg

  • soundharya Profile Picture
    249 on at

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

  • ursNani Profile Picture
    215 on at

    @Soundharya 

     

    This is the my flow . and its getting error 

     

    Screenshot 2022-02-02 163317.jpgScreenshot 2022-02-02 1633421.jpg

     

  • soundharya Profile Picture
    249 on at

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

  • ursNani Profile Picture
    215 on at

    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 

  • soundharya Profile Picture
    249 on at

    Soundharya_0-1644316864156.png

    Created by display name attribute you can use

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard