Hi all,
I have a flow with my PVA topic which pulls a date from excel, but it is returning it as a number.
After my 'Get a row' action I want the date to return as a date, not a text string.
It is the "W/C Date" in the output above that I am trying to format.....
I know how to format this in power automate, but the return values section doesnt allow formulas to return a value.
I am fairly certain it will be in a compose action, but cant get any formula that I try to work.
Can anybody help with a solution for this?