Unanswered

How to convert date-time formatted string from a custom API connector to a text property in a label?

(0) Share

Report

Posted on by willick

I have a collection (collectionLastUpdated) that contains a 'dtTime' property with a date-time formatted string value from an API. When I created the API connection in Flow, Flow assigned the value as a date-tme formatted string (not simply a string). I can't figure out how to display the date-time value in a text label. It seems I need to convert the date-time to a string or something but could not find a function to do it. Below is the code I currently have in the label text field (if a date-time value exists then show it, else show the text 'download collection data':

If(CountRows(collectionLastUpdated)=1,

First(collectionLastUpdated).dtTime,

"download collection data")

// sample data

"collectionLastUpdated": {"dtTime":"08/21/2018 13:24:45"}

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-zhta-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ willick

Could you please share more information about your issue?

Which format does “dtTime ”belong to, date-time or string?

I did a test on my side and it works fine.

Here are the screen shots:

1: Create a collection

ClearCollect(collectionLastUpdated,{title:1,dtTime:"08/21/2018 13:24:21"})

2: Display the dtTime string in a text label:

If(CountRows(collectionLastUpdated)=1,First(collectionLastUpdated).dtTime," download collection data")

If the “dtTime” column is a Date time type column, if you want to convert the dtTime column value into a string, I think the Text function could achieve your needs.

Here are some links maybe you can use:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

Hope this helps you.

Best regards,
Zheng

Was this reply helpful? Yes No
willick 62 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-zhta-msft, I should have clarified that this date-time value is coming from an API so the value that you are using is most likely string formatted and not date-time formatted as I am receiving. So my question probably applies more to MS Flow.

Was this reply helpful? Yes No