Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

(0) ShareShare
ReportReport
Posted on by

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 : 

 

Powertron_0-1654879077016.png

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 : 

Powertron_1-1654879194366.png

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 : 

Powertron_2-1654879307820.png

I've been slamming my head into a wall with this all afternoon, and I really want this win before the weekend 😄

 

Halp!

Categories:
  • Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    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

  • Powertron Profile Picture
    Powertron on at
    Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    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.

  • Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    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

  • MVP-Phipps Profile Picture
    MVP-Phipps 3,447 on at
    Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    Exactly why I asked but I am glad you spotted it yourself.

     

    Please mark this as resolved.

  • MVP-Phipps Profile Picture
    MVP-Phipps 3,447 on at
    Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    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?

  • Verified answer
    Powertron Profile Picture
    Powertron on at
    Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    Powertron_0-1655113750062.png

    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.

     

  • MVP-Phipps Profile Picture
    MVP-Phipps 3,447 on at
    Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    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.

  • Powertron Profile Picture
    Powertron on at
    Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    Even when trying to patch it that way the column name is not recognized : 

     

    Powertron_0-1655113149814.png

     

  • MVP-Phipps Profile Picture
    MVP-Phipps 3,447 on at
    Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    You are patching a SharePoint Choice field?

    This does not require a LookUp, you can patch a choice column like this:
    Role: {Value: "Administrator"

  • MVP-Phipps Profile Picture
    MVP-Phipps 3,447 on at
    Re: New Sharepoint Column Not showing up in Patch Statement - But is showing in other areas

    You are patching a SharePoint Choice field?

    This does not require a LookUp, you can patch a choice column like this:
    Role: {Value: "Administrator"

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard