Answered

powerfx Patch cant find column

(0) Share

Report

Posted on by ChannelDevMike

255

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?

(all solutions have been republished)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

3\ Try to find the column in formula bar.

Best Regards,

Wearsky

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

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

Was this reply helpful? Yes No

Ram Prakash Duraisamy 5,785 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ChannelDevMike 255 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ChannelDevMike 255 on at

Like (0)

Report
Copy link

Link copied!

Just tried, no luck here

Was this reply helpful? Yes No
ChannelDevMike 255 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ChannelDevMike ,

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
ChannelDevMike 255 on at

Like (0)

Report
Copy link

Link copied!

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!!

Was this reply helpful? Yes No