Unanswered

Overwrite excel table

(0) Share

Report

Posted on by Pcanimal

Hi,

I've got 2 excel files which are identical. Essentially, they contain the name of the person on call for a certain date.

The reason I've got 2 files is to enable users to add comments to a local version which is not seen in the live one.

However to replace the table I've written a flow which lists all the rows in each file and then uses a apply for each to delete a row in the live version before replacing them with the local one. This seems very ineffective. I'm not sure if update a row is a better way to go? I hold about 400 rows of data.

My table looks like this;

Date: Name: Telephone Number:

In reality I would only want to update the next 60 days including today. I just don't know how to set that query in the odata filter? Can anyone help or maybe suggest a better way please?

I have the same question (0)

All responses (5)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Overwrite excel table

Hey @Pcanimal

You can write something like this:

Datecolumn ge 'addDays(utcNow(),-60,'MM-dd-yyyy')

Or

utcNow('MM-dd-yyyy') le 'addDays('ColumnName',60,'MM-dd-yyyy')

Just make sure there is no space in the date column's name.

For example:
The date column's name is
Last Date, this will not work.
LastDate will work. If you have space in between rename it in the excel without space.

Keep the date format similar as in excel. Prefer MM-dd-yyyy in excel too otherwise it will give ISO error.

Check this link out too:

https://www.enjoysharepoint.com/power-automate-list-rows-present-in-a-table-filter-query/

Was this reply helpful? Yes No
Pcanimal 66 on at

Like (0)

Report

Re: Overwrite excel table

Thank you. I've written the UTCNOW one into the filer (no expression just typed) and i get this error:

Syntax error at position 44 in 'utcNow('MM-dd-yyyy') le 'addDays('Date',60,'MM-dd-yyyy')'.
inner exception: Syntax error at position 44 in 'utcNow('MM-dd-yyyy') le 'addDays('Date',60,'MM-dd-yyyy')'.
clientRequestId: c6b5a260-6813-4944-af18-e4d99d6d71a2

In filter query I've put this
utcNow('MM-dd-yyyy') le 'addDays('Date',60,'MM-dd-yyyy')'

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Overwrite excel table

You will have to write expression, just typed won't work. So just write my 1st filter query that I have mentioned above, 2nd won't work.
My bad, sometimes my mind does not work.

Was this reply helpful? Yes No
Pcanimal 66 on at

Like (0)

Report

Re: Overwrite excel table

Hi i am still struggling with this one:
I've added it like this:

nvalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.

What am i doing wrong pleasE?

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Overwrite excel table

@Pcanimal
First time seeing this error. Everything seems correct. Found a link to a previous post for this. Check it out if it helps.

https://powerusers.microsoft.com/t5/Building-Flows/Excel-List-of-row-Odata-filter/td-p/549665

Was this reply helpful? Yes No