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?
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.