Skip to main content

Notifications

Power Automate - General Discussion
Answered

How to read sharepoint columns in Power Automate?

(0) ShareShare
ReportReport
Posted on by 64

I have word documents in my SharePoint library, there are different owners for each document and i want owners to review those documents every 90days (Quarterly)and take necessary action or clean up. To do this, I want a power automate flow where it sends an email on the dates mentioned in Reminder column. Please help how to do that?

  • Verified answer
    HarikaVL Profile Picture
    HarikaVL 64 on at
    Re: How to read sharepoint columns in Power Automate?

    Hello @v-liwei-msft,

    Yes, timezone was the issue and i had created a string variable for "Reminder" and applied a condition Reminder equals to 

    "convertTimeZone(variables('Remainder'),'UTC''India Standard Time''dd-MM-yyyy')" and it worked.
    HarikaVL_0-1668414848361.png

     

     

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: How to read sharepoint columns in Power Automate?

    Hi @HarikaVL 

     

    This problem is caused by a time zone issue.
    The SharePoint date column time zone is the time zone of the region in the site settings, and flow converts it to the Utc time zone.
    I recommend you to use the convertFromUtc function to change the timezone:
    convertFromUtc(items('Apply_to_each')?['reminder'], '<destinationTimeZone>', 'yyyy-MM-dd') and
    convertFromUtc(utcNow(), '<destinationTimeZone>', 'yyyy-MM-dd')

    Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

     

    Best Regards,

    Levi

  • HarikaVL Profile Picture
    HarikaVL 64 on at
    Re: How to read sharepoint columns in Power Automate?

    Hello @v-liwei-msft,

    I have implemented flow as you mentioned above, i am not getting any error while testing but i am not receiving the notification as well.

    According to below screenshot, flow should send a notification for today date.

    HarikaVL_0-1667989774390.png

    but the condition is not satisfying and showing false 

    HarikaVL_1-1667989869262.png

    I used same conditions as mentioned 

    formatDateTime(items('Apply_to_each')?['Reminder'],'yyyy-MM-dd') and 
    utcNow('yyyy-MM-dd'). 
    Did i made any mistake or what is causing the issue?
  • HarikaVL Profile Picture
    HarikaVL 64 on at
    Re: How to read sharepoint columns in Power Automate?

    Hello @v-liwei-msft,

    Thank you so much for the quick response. I will implement the solution you suggested. Will update you after testing the flow. You are genius 🙂

     

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: How to read sharepoint columns in Power Automate?

    Hi @HarikaVL 

     

    1. You can create a Recurrence flow.
    2. use get files get files in the library.
    3. Use conditions to judge Reminder if it is equal to today's date, if it is equal, send mail to the owner of the corresponding document.

    vliweimsft_0-1667894211405.png

     

     

    Best Regards,

    Levi

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard