Hello everybody. I am pretty new to the Power Platform and still learning the ropes. I created a custom form for a SharePoint List through the Integrate --> Power Apps --> Customize Forms option that does not work correctly. When a new item is created, and the Form is submitted successfully, it shows "Required info" in the column, not what was selected on the form.
Here is what my Form looks like (no anger faces saying there is an error):
The Contractor, Current Status & Forester fields are Choice columns on the SP List. The General Foreman & Circuit ID columns are Lookup columns on 2 additional separate SP Lists in the background. Here are the functions I have in the Items fields.
Contractor Field (works just fine)
General Foreman Field (errors every time)
Circuit ID Field (errors every time)
I have fooled around with this for a few days now, and am ready to give up. I hope somebody can help me figure this out.
Thanks in advance.
It looks like you changed the pre-configured Items formula in those General Foreman and Circuit ID. I believe the issue is that the selected record in those fields don't have the values that the lookup column is expecting.
To test this out you can remove those data cards from the form and then add them back. This will reset the data cards to the pre-configured configuration. Then test creating an item and seeing if you still get "Required info" in SharePoint.
Sorry for the long pause between posts, hectic at year end work. Your suggestion did work, but how would I go about filtering the General Foreman & Circuit ID dropdowns based on the selection in the Contractor Field? After removing the data cards and adding them back in, it now lists everybody on the source list. We have multiple contractors that work with us for the same work. When adding a new item, I want to filter out the information in the General Foreman & Circuit ID so that the lists are not so big.