Saving a Number as a String in Sharepoint from a canvas app.

(0) Share

Report

Posted on by AngusWalker

168

I have a SharePoint field I wish to store the minutes of a time. Because it can be 00 or 05 I have made the field a string:

This works fine if I enter the data straight into the list:

However, when I save the value from my Canvas App, even forcing the value to be a string as follows:

Patch(
    Offices, 
    Offices_Gal.Selected, 
    {
        Timezone:
        {
            Value: Timezone_Combo.Selected.Timezone,
            Id:
            LookUp(
                Timezones,
                ID=Timezone_Combo.Selected.ID
            ).ID
        },
        HH: Value(HH_Combo.Selected.Value),
        MM: Value(Right(Concatenate("00", MM_Combo.Selected.Value),2))
    }
);

It always results in it being converted to a number, e.g:

Additionally, there is no number in the combo box that is being selected either. Everything is a string:

It just wants to convert numeric strings to numbers.
Does anyone have any Idea how to force this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Lisa3 46 on at

Like (0)

Report

If you want it to go into the list as a string, you don't need to convert it to a value. Try patching it like this and it should show both characters in the list:

{MM: MM_Combo.Selected.Value}

Was this reply helpful? Yes No
AngusWalker 168 on at

Like (0)

Report

@lisa3 That's where I initially started from.
I forced it to a string because the basic {MM: MM_Combo.Selected.Value} always saves it as a number.

Was this reply helpful? Yes No
Suggested answer

SebS 4,592 Moderator on at

Like (0)

Report
Hi,

You wrap HH_Combo.Selected.Value in Value() <--- this function will change String to a number if the string represent number just drop the Value() and you will be ok if you want to force something to become String you cast it as Text()

Patch( Offices, Offices_Gal.Selected, { Timezone: { Value: Timezone_Combo.Selected.Timezone, Id: LookUp( Timezones, ID=Timezone_Combo.Selected.ID ).ID }, HH: HH_Combo.Selected.Value, MM: Right(Concatenate("00", MM_Combo.Selected.Value),2) } );

Was this reply helpful? Yes No