Is it possible to show only Time in Powerapps from SharePoint database that the data is stored in date and time format?
Thank you very much
Solved! Go to Solution.
Hi @pollyzzz ,
Do you want to only show Time value from the Date Time type field in your SP list?
Based on the needs that you mentioned, I think the Text function could achieve your needs. I have made a test on my side, please try the following formula:
Set the Text property of a Label to following:
Text(Now(), "HH:mm AM/PM")
If you list your SP List records in a Gallery, and you want to display the Time value from the Date time field in this Gallery, add a Label in this Gallery, set the Text property to following:
Text(ThisItem.DateTimeField, "HH:mm AM/PM")
More details about Text function, please check the following article:
Best regards,
If is in a Textbox:(
Text(Textbox1,"hh:mm:ss")
In a Gallery label:
Text(ThisItem.Column,"hh:mm:ss")
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Yes, you can format date & time values using the TEXT function
Text(ThisItem.DateColumn, ShortTime24)
or
Text(ThisItem.DateColumn, ShortTime)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @pollyzzz ,
Do you want to only show Time value from the Date Time type field in your SP list?
Based on the needs that you mentioned, I think the Text function could achieve your needs. I have made a test on my side, please try the following formula:
Set the Text property of a Label to following:
Text(Now(), "HH:mm AM/PM")
If you list your SP List records in a Gallery, and you want to display the Time value from the Date time field in this Gallery, add a Label in this Gallery, set the Text property to following:
Text(ThisItem.DateTimeField, "HH:mm AM/PM")
More details about Text function, please check the following article:
Best regards,
User | Count |
---|---|
260 | |
110 | |
97 | |
56 | |
40 |