Power Platform Community Forum Thread Details

I've recently started to use Power Apps to capture scrap data from a production line. All the data so far has been captured in an Excel file from my org sharepoint and to make this process easier, I started learning about Power Apps. Each scrap unit has an unique ID starting from 1 to whatever number follows. I used this ID as my ID column for Power Apps.

For my App I'm trying to add a button that collects data from text field (containing defect, station, etc.) and I wanted the app to automatically add the subsequential number to ID when pressing the button to collect data. The formula is as follows:

Collect(Process_Scrap,{Station:Station.Text,Defect:Defect.Text,Unit:CountRows(Process_Scrap)})

When I try this, PowerApps returns an error saying that the Unit column is a Text data type and that I'm entering a Number a type. I tried changing the data type within PowerApps but it won't let me. I also formatted the column in Excel. I need help for this

Categories:

Connecting to Data

General Questions