Convert a text(input) type to record type?

(0) Share

Report

Posted on by DennisTheMenace

Hi everybody,

I haven't seen a solution to this specific question.

My scenario:

A freight is a collection that contains a maximum of 2 items. Users can add items to the freight and can order the freight.

The collection 'Freight' contains:

- Items: Item_dropdown_3.Selected.Value; (The item dropdown)
- CubicM: CubicM.Text; (The Cubic M text input that can only be a number)
- Bunker: Bunker_dropdown_3.Selected.Title (The bunker dropdown)

When the user presses the order button, the collection and other items get patched to a sharepoint list.

I use First(Freight).Item to specify the first item.

And I use First(Freight).CubicM to specify the amount of Cubic meters for the first item.

The problem:

The CubicM (cubic meters) column in the sharepoint list is a Record type. But the CubicM column in my collection is a Text type.

Is there any way to convert First(Freight).CubicM to a Record? Or change the CubicM: CubicM.Text in the collection to a Record type?

Thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,312 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @DennisTheMenace ,

What sort of Record type is 'Cubic M' and why is it this type?

Was this reply helpful? Yes No
DennisTheMenace 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there!
CubicM in the sharepoint list needs to be a record type instead of text. Which has to do with the "" when conferting it to an .csv file. However, CubicM in the collection Freight is a text type (I think because I use a Textinput). It's a simple Textinput that has been set to numeric (Aantal translates to number).

When adding it to the collection I use: CubicM: CubicM.Text; When I press on CubicM.Text I get the following:

So maybe a different sollution to my problem: is there a way use the Textinput, setting it to number and have a data type: number instead of text?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,312 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @DennisTheMenace ,

I think I may have asked the question the wrong way - what type of field is it in SharePoint -several different types can be a record. Can you please share a screenshot of you field definition in List Settings.

To answer your other question - yes - that is by far the best path. Numbers are displayed in Text inputs are are simply referred to as Value(TextBoxName.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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DennisTheMenace 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your solution.

Value(TextBoxName.text) seems to be doing the trick. I now get a Number type instead of a Text type from the text input field.

Was this reply helpful? Yes No