Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Power Platform Community / Forums / Power Apps - Power Apps Pro Dev & ISV / Send data in Number co...
Power Apps - Power Apps Pro Dev & ISV
Suggested answer

Send data in Number column of SharePoint list using Patch Function from Canvas app

(0) ShareShare
ReportReport
Posted on by SR-02111122-0 53
Hello Everyone,
 
Using Patch function I am sending data into SharePoint list from my gallery below is the image of table that I created using gallery
 
Problem:
the issue that I am facing is that I am unable to send data into Number column of SharePoint list, this is the formula for quantity column
(
Patch('Line Items',ThisItem,{Quantity:TextInputCanvas4_2.value})
)
Price column formula
Patch('Line Items',ThisItem,{Price:TextInputCanvas4_3.Value})
 
but I am able to send the data for Vendor, Item & Description column using these formula's
Patch('Line Items',ThisItem,{Description:TextInputCanvas4_4.Value})
 
Please let me know if anyone know how to resolve.
Thanks for support
Categories:
Power Platform Build Tools
  • Suggested answer
    SebS Profile Picture
    SebS 4,149 on at
    Send data in Number column of SharePoint list using Patch Function from Canvas app
    If user for example enter $10 or you adding the $ you can do it that way 
     
    Patch(
    'Line Items',
    ThisItem,
    {
    Quantity: Value(Substitute(TextInputCanvas4_2.Text, "$", ""))
    }
    )
     
    So before Patching and converting to number it will remove $
  • SR-02111122-0 Profile Picture
    SR-02111122-0 53 on at
    Send data in Number column of SharePoint list using Patch Function from Canvas app
    Thanks that works. Can please let me know one more thing, In Price column I also want to include $ sign in my text input field. 
  • Suggested answer
    SebS Profile Picture
    SebS 4,149 on at
    Send data in Number column of SharePoint list using Patch Function from Canvas app
    Hi,
     
    You need to wrap the text control in Valu() to make sure it will cast it as number
     
    Patch('Line Items',ThisItem,{Quantity:Value(TextInputCanvas4_2.value)})
     
    Hope that helps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard

Featured topics

Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)

Product updates

Microsoft Power Platform Community release plans