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 ,
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
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
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
WarrenBelz
146,522
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,890
Most Valuable Professional