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!
Patch(
'SL-SPList';
Defaults('SL-SPList');
{
GUID: NewGUIDString;
LeiPos: ThisItem.LeiPos & "cc";
Dept: ThisItem.Dept;
Rolle: ThisItem.Rolle & "cc";
'Vor- Nachname': ThisItem.'Vor- Nachname' & "cc";
Firma: ThisItem.Firma;
CustomFields: LookUp(
'SL-SPList';
GUID = "F877C6DDFC734DA2964DD253C18FF621"
).CustomFields
}
);;
The CustomFields was only recognised after 30 hours. I didn't change the code
Can you supply the code for your patch function? In the end my error was one of formatting as opposed to any actual code problems.
Good Morning,
I have this problem as well.
The galleries do recognise the new column, but the Patch functions don't.
Changing back to old columns makes the error vanish, just changing the patch function to the new column name makes the error reappear. The Errors are in line with Powertrons. Even changing the datasource JSON doesn't help!
I already waited 22 hours to get the recognition of Powerapps of the sharepoint column change.
Please help!
Best Regards
Maarten
Exactly why I asked but I am glad you spotted it yourself.
Please mark this as resolved.
That is what I was going to say and suspected that was the case. Hence I asked for the screenshot. Please can you mark this as resolved?
Genuinely not sure if "Dropdown1.Selected" is correct as the Checker isn't getting beyond the column name.
Edit : I noticed the issue myself after taking a screenshot and checking it. When adding the "Role:" column I had forgotten to move my "Curly Close" from after the "Title:" column. With that moved the formula is no longer erroring.
Can you send a picture of the formula but not with the error hovered over it. I think I know the issue but need to see this to confirm.
Even when trying to patch it that way the column name is not recognized :
You are patching a SharePoint Choice field?
This does not require a LookUp, you can patch a choice column like this:
Role: {Value: "Administrator"}
You are patching a SharePoint Choice field?
This does not require a LookUp, you can patch a choice column like this:
Role: {Value: "Administrator"}