Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Data showing in Power Apps Data Table but not on Sharepoint list

(0) ShareShare
ReportReport
Posted on by 17

I have a Sharepoint list connected to my app, when I collect the data within a form on my app, the data displays on my previewed data table. But when I go check on the SP list, I only find the ID created on my list but no data populated.

 

My SP List has a lookup column that looks for an entered number value and returns a description.

 

Help please.

 

Also, how do I remove the extra decimals added to my data table?

Oadr21_0-1709247173953.png

Oadr21_1-1709247200704.png

 

  • WarrenBelz Profile Picture
    146,522 Most Valuable Professional on at
    Re: Data showing in Power Apps Data Table but not on Sharepoint list

    @Oadr21 ,

    I thought you only want to show it correctly in the Data Table content. If SharePoint is expecting a Number, that will not work. You can try

    Round(DataTableName.Selected.PIC_Code_Field,0)

    but I have seen this glitch before.

     

    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.

    MVP (Business Applications)   Visit my blog Practical Power Apps

     

  • Oadr21 Profile Picture
    17 on at
    Re: Data showing in Power Apps Data Table but not on Sharepoint list

    It says that the data source expects a 'Record' in the column and that I'm using a text type.

    Oadr21_0-1709249343878.png

     

    I'm using a dropdown list to enter the data

     

  • WarrenBelz Profile Picture
    146,522 Most Valuable Professional on at
    Re: Data showing in Power Apps Data Table but not on Sharepoint list

    Hi @Oadr21 ,

    Try

    Text(ThisItem.'PIC Code',"####")

     

    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.

    MVP (Business Applications)   Visit my blog Practical Power Apps

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

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,522 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,890 Most Valuable Professional

Leaderboard