As you can see in my previous posts I use equal to and greater is then I tried but not everything older than 7 days is deleted.
Only with exactly 7 days ago, so 29-05-2019 will be deleted
I did a little more research and observed that we re doing this very wrong. Comparing dates is to be done in the similar format of dates and apparently the date coming from the excel is not properly formatted to compare with the date in flow. Can you share details on where is your date field coming from in excel?
HI @frixel So here is the thing, after saving the previous value in Excel using the update/create row action, this date is getting formatted somehow and is not returning properly in the next flow. Can you please make sure that the type is set to text in your column in excel sheet? We will then have a look at the flow with the extracted text values.
Also as we need to use the UTC date connector, can you make a minor change to the format of the other flow and get the date in the yyyy-MM-dd format?
So you see i set the receive colomn in Text.
I am not happy with the change in the date format because here in the Netherlands / Europe we use the date format dd-mm-yyyy
Is that realy needed?
why does "equal to" go well and 2 lines are removed, (okay too little because everything must be removed before 29-05-2019) And if I fill in "less then" is almost everything removed?
We use the dd-MM-YYYY in India too. It is just for the utc conversion i need it to be that way. Rather, let us keep it that way and use some variable functions in flow to format accordingly. (So do not change that)
Follow the steps:
Use the expression:
Replace "Description with the Received Date of your excel column" in the variable.
For the compose action, use:
test is the name of a variable i assigned
In the condition, the expression for the left one is :
And for the right one is
Rest you can follow. I tested this with a couple of dates and it works.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
The issue here is the data format from the Excel sheet. the tick function works only on the date time string as menstioned in the error. What you can do now is, select the entire column of your excel sheet and convert the type to text. Remove any pre existing data and populate the fields now. After this, check the data type by clicking on the cell, if it shows as text, run the flow with the modifications that we did. (Along with the tick function and comparision by splitting the array). If the flow fails, post the screenshot of the array split and compose outputs.
Hope this Helps!
Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020.
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Flow Community Video Gallery!