Text from form gets converted into random number like 1626782880000

[thebigmic]

Form and formularesults in sharepoint

I have a powerapps form linked to a sharepoint list.

I need to take the output of those 2 dropdown lists and put it in the list in that format, I keep hitting my head against the wall. Why did the text from the form convert to that type of output(pic2), in theformula I can see the output that I need, but for some reason I keep getting that semi random string of numbers.

Please help, I want to pull my hair out!

[zmansuri]

Column type in sharepoint?

[thebigmic]

Single line of text

[WarrenBelz · Accepted solution]

HI @thebigmic , 

This should work

Text(
    HourValue1.Selected.Value,
    "##"
) & ":" & Text(
    MinuteValue1.Selected.Value,
    "##"
)

Assuming of course the field in SharePoint is a Single Line of Text.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[v-qiaqi-msft · Accepted solution]

Hi @thebigmic,

Do you mean that the 'Start Time' column is a single-line-of-text to save your concatenated string?

Could you please share a bit more about your scenario?

I have a test on my side, please take a try as below.

I generate an Edit Form based on the data source directly, the control corresponding to the 'Start Time' column is a TextInput within the form. I delete it and replace with two Dropdown, one for HourValue1 and another for MinuteValue1.

Please check the screenshot as above. Here is the test result.

[thebigmic]

@WarrenBelz @v-qiaqi-msft Hi, thanks for the replies! I found a somewhat dirty workaround, I deleted the original data cards and added new ones based on the same Start Time column from SharePoint, then basically did what @v-qiaqi-msft suggested, but with only 1 dropdown list with the times in 5 min increments (I think I'll get carpal tunnel from it). I also tried @WarrenBelz suggestion, but I was getting the same type of output(It has to be some kind of bug). I think both solutions could work if PowerApps wasn't bugged out.

#For future people whit the same problem as me, try deleting the data cards and do what Qi and Warren suggested!#