News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows How to formatt datetim...

Power Automate - Building Flows

Answered

How to formatt datetime-values in "Select" statement

(0) Share

Report

Report

Posted on by UweGrunewald

56

Hi there,

I have a SharePoint list with time-recordings. From Date/Time, To Date/Time and Job done.

I want to to create a timesheet as PDF from this list, which works fine, execpt the formatting of the date/time values.

IF I try to use and expression, that formatts a date/time value to say 'hh:mm' (

formatDateTime(outputs('Get_item')?['body/Von'], 'hh:mm' )

I get an error "

Correct to include a valid reference to 'Get_item' for the input parameter(s) of action 'select'"

Anyone any ideas?

Best, Uwe

I use the select function. I I Screenshot 2023-01-30 082451.png

All responses Img

All responses (2)

Answers Img

Answers (1)

UweGrunewald 56 on at

Like (0)

Report

Re: How to formatt datetime-values in "Select" statement

You saved my day. A million thx
Verified answer

v-chengfen-msft on at

Like (1)

Report

Re: How to formatt datetime-values in "Select" statement

Hi @UweGrunewald ,
Please try:
formatDateTime(item()?['Von'], 'hh:mm' )

Best Regards
Cheng Feng

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans