Unanswered

formula showing error for field that isn't in the formula

(0) Share

Report

Posted on by ahhollan

576

I have a patch formula and it is showing an error. The problem is that it is showing an error for a field that isn't in the formula. Has anyone seen this and if so, how did you resolve?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

kbilakanti 315 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Can you add a screenshot of the error if possible?
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

here is my formula:
Set(varRecord, Patch('Project Initiation',{ID:Value(Param("ItemID"))},{Title:DataCardValue14_1.Text, 'Submission Date':DataCardValue16_1.SelectedDate,'SBU/BU':Dropdown1.Selected.Result, 'Requesting Organization':DataCardValue34_1.Text,'Point of Contact':DataCardValue35_1.Selected,Notes:DataCardValue75_1.Text,'Generation?':Dropdown1_1.Selected.Value,Location:cbLocation_1.Selected.Value,Building:ComboBox10_1.Selected.Building, Direction:Dropdown6_1.Selected.Value,'Cubicle(s)/Office(s)':DataCardValue104_1.Text,'FM Space Mgmt Lead':DataCardValue23.Text,'KOC floors':Dropdown7.Selected.Value,Nuclear:ComboBox9_1.Selected.Value,Fossil:ComboBox6_1.Selected.Value,Gas:ComboBox7_1.Selected.Value,Hydro:ComboBox8_1.Selected.Value,Quadrant:Dropdown8.Selected.Value, City:DataCardValue23_1.Text, State:DataCardValue27_1.Text,Floor:DataCardValue88_1.Text,'Building Name':DataCardValue87_1.Text, 'Site Name':DataCardValue79_1.Selected, 'TPS Region':DataCardValue80_1.Text, 'TPS Sites':DataCardValue84_1.Text,'Project Scale':DataCardValue69_1.SelectedItems,'Customer need date':DatePicker1.SelectedDate,'Budget secured?':Dropdown4_1.Selected.Value, 'Available Funds':DataCardValue38_1.Text, 'POET (Project/Task/Alias)':DataCardValue40_1.Text,'Management Sponsor':DataCardValue44_1.Selected, 'Project Manager':DataCardValue46_1.Selected,'Customer Tech Lead':DataCardValue52_1.Selected, 'FM PM Region':DataCardValue42.Selected, 'FM Project Manager':DataCardValue27.Text,'COC Floors':Dropdown5_1.Selected.Value,'Generation Type':cbGenerationType_1.Selected.Value,'FM Arch & Eng Lead':DataCardValue39.Selected,'Arch & Eng Contractor1':DataCardValue37.Text,PCS:DataCardValue63.Selected,'Approval Notes':DataCardValue21.Text,'On Hold/Cancelled Notes':DataCardValue61.Text,'FM Review Notes':DataCardValue54.Text, Status:DataCardValue66.Selected})); If(!IsBlank(varRecord), Notify("Your request has been submitted! You may now close the window.", NotificationType.Success), Notify("Your request was not submitted", NotificationType.Error))

Here is the error:
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ahhollan ,
Firstly you have a column originally called MS Buildings in SharePoint and you have renamed it - find out which one that is and then we can have a look at the control value you are trying to write to it.
If you hover over the field name in SharePoint field definitions, you will seethe original file name at the end of the string of characters at the bottom of the screen.
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ahhollan ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.