Forum Discussion
Edit item - not all field filled in.
I have customized SPO form when a new item is creating in the list.
When I want to edit fully filled in item, not all fields have data inside.
Could someone advise how to solve this kind of problem?
Two fields that auto-populate get data from excel file based on badge number.
- If that's a form control, select the field cards there and there should be a "Default" property. That needs to be set to field, it should really need to be a filter if you are pulling data directly from the document it should just be a ThisItem.Columnname or just Columnname unless you are doing extra filtering.
If you could post a bit more about your sheet and the default / items etc. properties of a few of those controls.
Hi Freenit,
Can you explain how the two fields that auto-populate get data from excel file based on badge number? Is it a Flow?
Norm
Excel located at OneDrive. I use the "Import from Exel" connection in PowerApp.
Then in the two auto-populated fields I use the LooKup(Filter()) formula to get data based on badge number.
- If that's a form control, select the field cards there and there should be a "Default" property. That needs to be set to field, it should really need to be a filter if you are pulling data directly from the document it should just be a ThisItem.Columnname or just Columnname unless you are doing extra filtering.
If you could post a bit more about your sheet and the default / items etc. properties of a few of those controls.
