cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

I have the entire column of the excel sheet convert to text.

 

Flow1.png

 

Flow2.png

Super User
Super User

Re: Delete Rows older than 7 day`s

@frixel earlier you were just getting date and now you are sending time also in that. and that is why the error is coming. You can use the below expression in place of the split function to run it properly

 

split(first(split(items('Apply_to_each')['Received Mail'],' ')), '-')

tetetet.png

Make the change of expression in the set variable action as shown above. 

 

Hope this Helps!

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

Then i have the same error.

 

Flow4.png

 

Flow3.png

Super User
Super User

Re: Delete Rows older than 7 day`s

Hey @frixel 

 

Can you update all the expressions in the consecutive steps, just click on the expression and click update. Run the flow and check the values then. I am able to get it right:vas.png

 

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

Flow4.png

 

Flow5.pngFlow6.png

Super User
Super User

Re: Delete Rows older than 7 day`s

Hey!

 

Looks like there is an error in the condition that you are applying. See the screenshot below: You do not have to put the array in the ticks function istead put the compose output: 

tCop.png

 

tCop2.png

 

Can you share a screenshot of what you put there just to rectify?

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

When i do this as you let see. it deletes all the date`s, evenso the dates from yesterday etc.

 

flow1.png

Super User
Super User

Re: Delete Rows older than 7 day`s

@frixel 

 

Can you share a screenshot of the condition and the variables you put in the condition from the flow?

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

flow1.png

Super User
Super User

Re: Delete Rows older than 7 day`s

Can you share all the expressions that you are using in this? the compose and the conditon actions?

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

flow1.png

Super User
Super User

Re: Delete Rows older than 7 day`s

Hey @frixel 

 

In the flow, Action Set Variable: 

split(first(items('Apply_to_each')['Received Mail'],'*')),'-')

Replace the * with a space key (blank space)

 

Hope this Helps!!

 

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

i don`t see there a * in my expression, where did you see it?

 

When i replase the expression

split(first(split(items('Apply_to_each')['Received Mail'],' ')), '-')   in "set variable" 

with what you suggest

split(first(items('Apply_to_each')['Received Mail'],'*')),'-')

Without the * and with a space the flow say`s  no valid expression. Also with the *

 

Super User
Super User

Re: Delete Rows older than 7 day`s

Hi @frixel  I just put a * for showing that you should add a space over there. In the original formula of yours, just hit a space button over there so that the split function works properly. 

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

hi @yashag2255 

 

Oke, i changed it with a space but no difference in the flow.

ALL day`s  will just removed!

It like to go good so first day`s will removed but 20 sec later ALL day`s will be removed.

 

flow1.png

 

Super User
Super User

Re: Delete Rows older than 7 day`s

Please share a screenshot of the excel delete a row action from the flow.

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

that is the one above

Super User
Super User

Re: Delete Rows older than 7 day`s

Hey @frixel  That is the output part, I wanna check the flow design part

frixel
Level: Powered On

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

Oké , sorry i hope you mean this part?

 

flow1.png

Super User
Super User

Re: Delete Rows older than 7 day`s

Hi @frixel , The problem is you are doing another apply to each in the yes tab of the condition loop. 

 

See the screenshot below:

yey.png

You do not have to add another apply to each loop. it should be just delete the row option. (as the apply to each is already there in the parent action)

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 464 members 4,775 guests
Please welcome our newest community members: