Parch Function not updating one specific columms and adding new row

(0) Share

Report

Posted on by Megaplay

Patch(
colGridData,
ThisItem,
{

Comp: complete.Selected,
Blacktop: Blacktop.Selected,
AIM: AIM.Selected,
Excavation: Excavation.Selected,
Fitting: Fitting.Selected,
Commercial_or_Residential: Commer.Selected,
Number_of_Meters: NumberofMeters.Selected,
Inspected: Inspected.Selected,

}
)

// All collums work fine and update sharepoint list except the Inspected collumm which is a normal dropdown yes or no just like others. not why it's adding new row in the data set.

Please Help, Thank you

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Parch Function not updating one specific columms and adding new row

HI @Megaplay,

What the column type of the Inspected in your list, Yes/No or Choice?

How you set the Inspected dropdown items property?

Generally, if Inspected is a Choice column, your formula will do, if it is Yes/No column, well, you need to adjust it to:

If(Inspected.Selected.Value="Yes",true,false)