Forum Discussion
Use displayed value in a cell rather than the input function, for use in another function?
Oh, such better to discuss with small sample file with only few records to illustrate an issue.
Do I understood correctly what in
match(LookUpDateCell+Time(8,0,0), LookUpDateColumn, 0)
you compare datetime lookup value with LookUpDateColumn which has only dates? If so, it could be
..match(INT(LookUpDateCell+Time(8,0,0)), LookUpDateColumn, 0)Or LookUpDateColumn column is also datetime and you try to find exact time for the date?
By the way, didn't check now but as I remember in Power Automate there is a function like ConvertTimeZone or so, you may do such conversions within it.
Hello again Sergei - your advice about the time zone conversion tool in Power Automate did the trick!
I no longer need to use excel to convert between everything - so now it all works smoothly!Thank you so much.
scupacoffee , you are welcome
Hello! Thank you for your message. I should have thought ahead to include a sample file - I've attached it to this message, and I will edit the original post to include it as well.I have created one row of sample data, as the real data itself may be subject to privacy protections.
The goal is to be able to use the PST date for reference purposes, and as of right now I am at a loss for how to do so. It also appears that the "fix" I thought I had is ineffective... so I will remove that from my original post, too.
In the mean time, I will examine PowerAutomate further to see if the timezone conversion tool is available! Thank you.
