Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

powerfx Patch cant find column

(0) ShareShare
ReportReport
Posted on by 255

ChannelDevMike_0-1672684308828.pngChannelDevMike_1-1672684390594.png

Patch cant find my columns.. not a lookup or anything. Tried both a yes/no (preferred) and a whole number and I cant find either one. 
I am not using classic mode/ribbon workbench, so is it a glitch in the system?

ChannelDevMike_2-1672684533610.png

(all solutions have been republished) 

Categories:
  • ChannelDevMike Profile Picture
    255 on at
    Re: powerfx Patch cant find column

    Ah thanks, it confused me when it showed "canvas" in the title. Didn't know if it was trying to add a canvas component. Much appreciated!! 

  • Verified answer
    v-xiaochen-msft Profile Picture
    on at
    Re: powerfx Patch cant find column

    Hi @ChannelDevMike ,

     

    Please follow my first step and it will lead you to open the component library.

    vxiaochenmsft_0-1672796064315.png

    vxiaochenmsft_1-1672796105910.png

     

    Best Regards,

    Wearsky

  • ChannelDevMike Profile Picture
    255 on at
    Re: powerfx Patch cant find column

    This is not in canvas but model-driven app editor. So data button and options look like this:

    ChannelDevMike_0-1672759784727.png

     

  • ChannelDevMike Profile Picture
    255 on at
    Re: powerfx Patch cant find column

    Just tried, no luck here

  • ChannelDevMike Profile Picture
    255 on at
    Re: powerfx Patch cant find column

    I am updating existing but "LookupLogicalName" doesn't populate just like original problem

  • Ram Prakash Profile Picture
    5,166 Super User 2025 Season 1 on at
    Re: powerfx Patch cant find column

    Hi @ChannelDevMike 

     

    If you want to create a new Record the try the following

     

    Patch(Results,Defaults(Results),{ LookupLogicalName: LookUp(Requests, ‘Request Number’= “REQ-####”), hidden2:1})

     

    If you want to update existing record then try the following

     

    Patch(Results,{ LookupLogicalName: LookUp(Requests, ‘Request Number’= “REQ-####”), hidden2:1})

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: powerfx Patch cant find column

    Hello, @ChannelDevMike, Have you tried using the LookUp function instead? Just to debug this:

    Patch(Results, LookUp(Requests, ‘Request Number’= “REQ-####”), {hidden2=1})

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

  • v-xiaochen-msft Profile Picture
    on at
    Re: powerfx Patch cant find column

    Hi @ChannelDevMike ,

     

    Please try to follow the steps below.

    1\ Click the 'Open component library' button in the upper-right corner.

    2\ Remove the table and re-add it.

    vxiaochenmsft_0-1672712766110.png

    3\ Try to find the column in formula bar.

    vxiaochenmsft_1-1672712917577.png

     

    Best Regards,

    Wearsky

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics