Announcements
Hi All,
I have an issue with PowerApps bulkupdating . I have drop down and two date pickers and text input , from where i can update the selected items from the gallery with the above controls .Evry thing works fine if we give all the controls values.But when we update the value in one control and leave remaing three conrtrols empty ,that empty values are updating in the gallery in place of previous value. Can some one help me on this.Thanks in advance.My backend is sqldb.
Hi, I am assuming you are patching existing records. Patch will overwrite whatever is on the field, so if you a have a record with a column A set to 123 and then do a Patch and that value is null, column A will be null.
Hi thanks for responding,
yes, what my requirement is ,if for suppose i changed the dropdown value alone that value should only be upddated. remaining values should remain unchanged. how to write a formula to get rid of blank values to be updated in gallery.
ok,
Try something like this:
YourColumn: If( !IsBlank(YourControl.Text), YourControl.Text)
Alredy tried with updateif(colgriddata, ThiseRecord in colselected &&!Isblank(drpdwn_status),{status:drpdwn_ststus.seelcted.result});
Updateif(colgriddata,thisrecord in colselected &&!isblank(datepicker1),{fromdate:Datepicer1.selecteddate}) similary fro the two .But it is taking only one conrols value
Maybe, I was not clear enough. Try something like:
Patch(
YourTable,
YourRecord,
{
}
)
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 432 Super User 2026 Season 2
Mohsin Ali 347
WarrenBelz 254 Most Valuable Professional
