web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Parch Function not upd...
Power Apps
Answered

Parch Function not updating one specific columms and adding new row

(0) ShareShare
ReportReport
Posted on by 2

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

I have the same question (0)
  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    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)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 273

#3
Kalathiya Profile Picture

Kalathiya 232 Super User 2026 Season 1

Last 30 days Overall leaderboard