Unanswered

Patching multiple columns .

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello! 🤕

I am having a rather difficult time in patching my SharePoint.
I've managed to insert multiple columns in 1 gallery list with check box.
Using this Formula:

"""Filter(Split(Concat(Filter('Loto Isolation Form', 'Form Number ' =Dropdown2.SelectedText.Value),
If(!IsBlank('Item 1'), 'Item 1', Blank()) & "," &
If(!IsBlank('Item 2'), 'Item 2', Blank()) & "," &
If(!IsBlank('Item 3'), 'Item 3', Blank()) & "," &
If(!IsBlank('Item 4'), 'Item 4', Blank()) & "," &
If(!IsBlank('Item 5'), 'Item 5', Blank()) & "," &
If(!IsBlank('Item 6'), 'Item 6', Blank()) & "," &
If(!IsBlank('Item 7'), 'Item 7', Blank()) & "," &
If(!IsBlank('Item 8'), 'Item 8', Blank()) & "," &
If(!IsBlank('Item 9'), 'Item 9', Blank()) & ","),","),
!IsBlank(Result))"""

Now, the problem is, I don't know how to patch fields in multiple columns while using checkbox as a confirmation.

Item 1 Checkbox have to patch DeIsolation 1, Item 2 Checkbox have to patch DeIsolation2, and so on till Item 9.
Deisolation1 to 9 are different columns.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
One way to do it is to use multiple Patch functions, each within an If condition that checks the value of its corresponding checkbox.

Something like this:
If(!IsBlank(Checkbox1), Patch(...))

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you mean just patch the ticked items to specific columns?
I have test on my side, please try this:
Patch('SP list', Defaults('SP list'), If(Checkbox1.Value,{'DeIsolation 1':'Item 1'}),If(Checkbox2.Value,{'DeIsolation 2':'Item 2'}),If(Checkbox3.Value,{'DeIsolation 3':'Item 3'}), ... ,If(Checkbox9.Value,{'DeIsolation 9':'Item 9'}))
Sik

Was this reply helpful? Yes No