I'm seeing there is/was a bug preventing patching a null value. It appears this is still the case?
I'm trying to null out one column on the onchange of another column. I've tried using UpdateIf and Patch unsuccessfully. I just want it so that if something is entered into a row on column B, I need it to automatically empty out column A in the same row - either through the onchange of the cell in the gallery, or via the submit button after editing the cell. Possible?
Solved! Go to Solution.
They're both values. Basically I have a column with estimated expenses and another with actual expenses. If someone finally spends the money, they will update the actual expense text input in the gallery and I want the estimated value to change to 0 or null so it doesnt mess my calculations up (i'm combining estimated and actual together for the "remaining budget" value and don't want a single line item to count against them for the sum of both estimated and actual.
You’ll have to use a variable and use it as the value() in the text of estimated control. Then onselect of the actual use a set(). However it probably would just be easier to throw an If(!isEmpty(actual.text),value(estimate.text),value(actual.text)) in your patch for that column you are updating.
Of if it’s two separate database columns then use that same command but put 0 in place of the value(actual.text) spot.
Thanks that's helpful. This is what I ended up with in my Patch statement.
I only want it to empty out the "Estimated" value in the modified line item when that line item's "actual" amount is updated. So I used IsBlank vs IsEmpty. I tried just using Value("") instead of Value("0") but Value("") doesn't modify the currently set Estimated value at all. It'd be cool if I find a way to null the value out so it doesn't show a 0 but it should suffice for my needs.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications