Unanswered

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

(0) Share

Report

Posted on by Oadr21

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,030 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
Oadr21 17 on at

Like (0)

Report

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

I'm using a dropdown list to enter the data

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (0)

Report
@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

Was this reply helpful? Yes No