Answered

Issues Patching and Submitting new form entries with 2 people picker fields in PowerApps, to SP List

(0) Share

Report

Posted on by po452011

Hi I am new to PowerApps.

I am updating my PowerApps application, with an option to submit New requests via a PowerApps form. This new form will be an upgrade from my previous data entry method which utilized an MS Form. I am updating the system to utilize a custom PowerApps form, in order for me to leverage MS Active directory in 2 people picker fields on the form.

My goal is to have the ability for my stakeholder to be able to submit new requests via the custom form, which has 2 people picker fields, and have the form patch the new record to my SP List. (All requests via the new form are new records).

Below is the custom form and the SP list is should write to.

I am having an issue patching and I am receiving this error :" invalid argument type. expecting a table value but of a different schema, missing column. Your formula is missing a column 'Value' with type of 'Text'"

I have double checked that my SP list are choices and double checked that the source and syntax of my Active directory is correct.

And also used this link as a resource, with no luck: https://www.youtube.com/watch?v=bmft4JFWJiY&t=327s

Any suggestions/recommendations on how to resolve this issues will be appreciated.

Categories:

Connectors

General Questions

All responses (2)

Answers (1)

po452011 6 on at

Like (1)

Report

Re: Issues Patching and Submitting new form entries with 2 people picker fields in PowerApps, to SP List

Hi @FLMike , Thank you for your reply. Following your insights I did some troubleshooting and indeed found the issue was my Sharepoint list column.. I had set to choices instead of People or Groups. Once I created a new column with with People or Groups, the code resolved itself.
Verified answer

Michael E. Gernaey 41,398 Super User 2025 Season 1 on at

Like (0)

Report

Re: Issues Patching and Submitting new form entries with 2 people picker fields in PowerApps, to SP List

HI @po452011

This usually means that somewhere you have the collection defined as something else, or that in some other place you put a different data type.

Can you please show the Collection where its defined and also this picture above, can you make one without the highlight please

I would recommend opening the project. Click in any grey area of the designer but not on a form.

Then do CTRL F and type in the name of your collection. It should bring back a list of every use. Click them 1 by 1 and verify that you are in fact using the same datatypes everywhere.

If you aren't thats the issue.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey