How to filter array on Excel time column?

(0) Share

Report

Posted on by raks

Hello,

I have a flow that treat the answers of multiple forms to put them in a SharePoint List.

This flow is run 4 times per day and I'd like to filter the column "Completion time" on the last 6 hours.

So I made this action:

After execution, the answers given the same day but more than 6 hours are always treated. Is there another function that I have to put on the Excel column?

Thanks for your help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Unknown geen idee 1,757 on at

Like (0)

Report

Dear Raks,
I have been successful in using office scripts to sort tables in Excel, suggest you give it a try.
https://powerusers.microsoft.com/t5/Building-Flows/auto-sorting-an-excel-table/td-p/1334925

Happy flowing,
Koen

Was this reply helpful? Yes No
Verified answer

raks on at

Like (0)

Report

Thanks for your answer. Finally, it was only a problem of time zone.

Was this reply helpful? Yes No