I have problem with this. So the idea is i have an excel document on OneDrive with data is fed through Forms. Now i want to filter the data based on 'From' and 'Until' field date. The idea is from<=currentdate and until>=currentdate then a table is created to be used for mail.
So i use list rows present then filter array. But on filter array, the date from excel sent to the filter messed up changing into weird format like 44116 (supposed to be 10/12/2020)..Now how can i fix this?
@lessOrEquals(formatDateTime(item()?['From'], 'yyyy-MM-dd'), utcNow('yyyy-MM-dd'))
Solved! Go to Solution.
Hi there. Give this a go:
Basically, we're swapping out the current Excel "From" date, with the addDays and the number that's in the "from" field.
Keep us posted.
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
I've updated it using 'Apply to each' and 'Condition'
for the date ;
but it didn't seem to work..even though i filter the date, the data still considered true..
date in excel ; 20/10/2020
utcnow ; 19/10/2020
but the date with that date still considered true...or is condition didn't work?