So as the title, I have a sharepoint list which had 2 columns, <Name> and <Reason for Adding>. I had a PowerApps list setup to add to these columns, Name from a People Picker and Reason for Adding from a text box. This worked fine.
I then went to add a third column to the Sharepoint, a choice column. The idea was to add a Role, and have this selectable from a Choice column. I have a dropdown in my powerapps form with the following formular in Items :
Choices([@'ServerOrderForm-AdminList'].Role)
This works fine, and I see the following choices in the dropdown when the program is active :
These are the correct choices as setup in Sharepoint. If I change these columns in Sharepoint and Refresh the data source, they update in this dropdown. Happy days, link working fine, right?
Wrong.
When I try to update my Patch statement to include this new column I see the following :
All the advice I've found for this issue suggests refreshing the data source, or adding and removing the data source. I've tried this - however even if that did work, why does one part of my powerapps form find that column fine, but another part of it doesn't? Why does my Patch statement not recognize that there is a Role column there? I thought it might be because it was a choice column and I needed to do Lookup() instead of just straight patching, but that doesn't work either :
I've been slamming my head into a wall with this all afternoon, and I really want this win before the weekend 😄
Halp!
