cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

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

Highlighted
Dual Super User
Dual 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!

Highlighted
Post Prodigy
Post Prodigy

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

Then i have the same error.

 

Flow4.png

 

Flow3.png

Highlighted
Dual Super User
Dual 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

 

Highlighted
Post Prodigy
Post Prodigy

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

Flow4.png

 

Flow5.pngFlow6.png

Highlighted
Dual Super User
Dual 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?

Highlighted
Post Prodigy
Post Prodigy

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

Highlighted
Dual Super User
Dual 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?

Highlighted
Post Prodigy
Post Prodigy

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

flow1.png

Highlighted
Dual Super User
Dual 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?

Highlighted
Post Prodigy
Post Prodigy

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

 

flow1.png

Highlighted
Dual Super User
Dual 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!!

 

Highlighted
Post Prodigy
Post Prodigy

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 *

 

Highlighted
Dual Super User
Dual 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. 

Highlighted
Post Prodigy
Post Prodigy

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

 

Highlighted
Dual Super User
Dual Super User

Re: Delete Rows older than 7 day`s

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

Highlighted
Post Prodigy
Post Prodigy

Re: Delete Rows older than 7 day`s

that is the one above

Highlighted
Dual Super User
Dual Super User

Re: Delete Rows older than 7 day`s

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

Highlighted
Post Prodigy
Post Prodigy

Re: Delete Rows older than 7 day`s

Hi @yashag2255 

Oké , sorry i hope you mean this part?

 

flow1.png

Highlighted
Dual Super User
Dual 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)

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Users online (8,958)