Scheduled Power Automate based on SharePoint List Date

Question

I am trying to create a workflow with power automate that is scheduled to go out on weekdays. When I create the Get items, I want to have the filter query to grab from my sharepoint list for a date column if the date column matches today. After power automate retrieves from the date column and it matches today, I want to apply to each for approval permissions. I can't seem to get the Get items function to work to even test the approval workflow. Can you please assist?

Answer 1

Dear @Angela Dittmer,  

Welcome to the Q&A Community.    

I understand how inconvenient it can be when the Get items filter doesn’t behave as expected and blocks the entire approval flow from being tested. 

Since my current category primarily focuses on Microsoft 365 products, and your concern relates to Microsoft Power Apps, I want to ensure you receive the most accurate and effective assistance. For this reason, I recommend posting your question in the Microsoft Power Platform Community Forum. In this forum, you'll get the most qualified group of respondents, and other partners who read the forums regularly can share their knowledge or learn from your interaction.    

I apologize for redirecting you to a different community, as the members of this category focus on Microsoft 365 concerns and have limited knowledge about Power Apps. To help you get quicker and better assistance, I am guiding you to the appropriate resource.  

As community moderators, we kindly ask for your understanding that our access to internal development details is limited. Our primary role is to guide users toward the appropriate resources and support channels. While we may not have visibility into performing deeper backend analysis, we’ll continue doing our best to support you within the scope of our responsibilities.     

Thank you once again for your precious time and engagement.  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.