Filter Get Items with O Data

[tlevine]

Hi Community - 

I am having some issues when trying to filter my Get Items step. I am storing data in a Sharepoint List which is populated with submissions from PowerApps. The data is stored in a field called "Submitted Date" in the Sharepoint List as a Single line of text. Examples of the data would include 9/28/2020, 10/1/2020. I am looking to filter the Get Items step to capture any requests that happen within a specific week. At that point, I can take the data and send it to my team in an email (I have this part figured out).

I am not sure if this is impacting the current situation but no dynamic content is available when trying to filter. In the past, I have been able to filter using something along the lines of 'Title' eq "Dynamic Content Field". Also, unclear if the data being stored as text is a major issue here.

Thanks all for the support in advance.

[v-alzhan-msft]

Hi @tlevine ,

Could you please share the screenshot of the configuration of your flow?

What the special week that you mentioned? 

You could take a try to refer to screenshot below to create the flow:

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tlevine]

thanks for the quick reply, @v-alzhan-msft - how can i ensure that the date is dynamic? the code that i use in powerapps to find the Monday of the current week is Today() - Weekday(Today(), MondayZero). I then use Today() + 7 - Weekday(Today(), MondayZero) to determine the Monday of the following week. basically, this is what i want to do in order to establish my range for the filter

[Amanthaper]

Hi,

You can use these 2 functions to get:

1. Monday this week:

adddays(utcNow(),mul(sub(int(dayOfWeek(utcNow())),1),-1))

2. Monday next week:

adddays(utcNow(),sub(8,int(dayOfWeek(utcNow()))))

This gets:

Then do either:

Or to jump ahead 7 days from the current day use adddays(utcNow(),7)

Hope this helps,

Aman T

------------------------------------------------------------------------------------------------------
If my post helps you with your problem or answers your question, please mark it Solved or Answered. This helps anyone with similar challenges. If you like my response, please give it a Thumbs Up.
------------------------------------------------------------------------------------------------------

[tlevine]

Hi @Amanthaper  - thank you for the suggestion, i see that my variables work properly and assign the correct dates to them. however, the flow still fails when trying to execute the query. could this be due to my field called 'PWD' (this field contains the dates) is stored as text in my sharepoint list?

[Amanthaper]

What's the error? Can you share a snip of your flow?

The date format should already be text but try this with both functions: 

string(adddays(utcNow(),mul(sub(int(dayOfWeek(utcNow())),1),-1)))

[tlevine]

hi @Amanthaper  - this is the error I am currently receiving

i will try to update my variables using the next format you provided, will advise on results

[tlevine]

It looks like the dates are being recognized properly with each variable.

This is the filter query result with the error I receive from Get Items:

PWD' ge '2020-10-05T01:55:09.5913172Z' and 'PWD' le '2020-10-12T01:55:09.6381941Z'

[Amanthaper · Accepted solution]

That syntax looks wrong. It should be:

PWD ge '2020-10-05T01:55:09.5913172Z' and PWD le '2020-10-12T01:55:09.6381941Z'

Please remove the ' from both PWD

[tlevine]

Thank you for your help in finding the solution. @Amanthaper