Convert a text(input) type to record type?

Like (0) Share

Report

Posted on 13 Nov 2021 18:18:17 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:

General Questions

Dataflows

All responses (4)

Answers (1)

DennisTheMenace 9 on 17 Nov 2021 at 17:23:39

Like (0)

Report

Re: Convert a text(input) type to record type?

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.
Verified answer

WarrenBelz 148,929 Most Valuable Professional on 13 Nov 2021 at 23:18:33

Like (1)

Report

Re: Convert a text(input) type to record type?

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
DennisTheMenace 9 on 13 Nov 2021 at 22:41:51

Like (0)

Report

Re: Convert a text(input) type to record type?

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?
WarrenBelz 148,929 Most Valuable Professional on 13 Nov 2021 at 21:17:45

Like (1)

Report

Re: Convert a text(input) type to record type?

Hi @DennisTheMenace ,

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