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)
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!!
Hi @ChannelDevMike ,
Please follow my first step and it will lead you to open the component library.
Best Regards,
Wearsky
This is not in canvas but model-driven app editor. So data button and options look like this:
Just tried, no luck here
I am updating existing but "LookupLogicalName" doesn't populate just like original problem
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
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
|
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
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1