Hello,
I'm getting loopy on this one. Usually a good time to reach out for help (or to just practice describing complexity in text 🙂 )
Scenario:
Problem:
If( Or( ThisItem.NestedTable1.Status <> If( little_toggle.Value = false,"N", // The Data Source toggle values come in as "N" or "Y". little_toggle.Value = true,"Y" ), IsBlank( Filter( First( colStatus.NestedTable ).NestedTable2, NestedObject.ID = ThisItem.NestedObject.ID ) ) ), Collect(colStatus, Table( { all: kinds, ofCrazy: Table( { things: ThisItem.what, things2: ThisItem.seriously, NestedTable2: { ID: ThisItem.NestedObject.ID, }, NestedTable1:{ Status: If( little_toggle.Value = false,"N", little_toggle.Value = true,"Y" ) } } ) } ) ), Remove( First(colStatus.NestedTable2 ).NestedTable2, LookUp( //Also tried Filter here, no go First(colStatus.NestedTable2 ).NestedTable2, NestedObject.ID= ThisItem.NestedObject.ID ) ) )
Looking for:
Thanks!
Solved! Go to Solution.
Hi @ericonline ,
Could you please share a bit more about your issue?
Do you mean that the Remove() formula part within the formula that you provided do not work?
Based on the formula that you provided, I think there is something wrong with it. I have made a test on my side, please consider take a try to modify your formula as below:
If( Or( ThisItem.NestedTable1.Status <> If( little_toggle.Value = false,"N", // The Data Source toggle values come in as "N" or "Y". little_toggle.Value = true,"Y" ), IsBlank( Filter( First( colStatus.NestedTable ).NestedTable2, NestedObject.ID = ThisItem.NestedObject.ID ) ) ), Collect(colStatus, Table( { all: kinds, ofCrazy: Table( { things: ThisItem.what, things2: ThisItem.seriously, NestedTable2: { ID: ThisItem.NestedObject.ID, }, NestedTable1:{ Status: If( little_toggle.Value = false,"N", little_toggle.Value = true,"Y" ) } } ) } ) ), Remove( /* <-- Modify your formula here */ colStatus, /* <-- Type your Collection data source here, rather than nested table */ LookUp(colStatus, First(ofCarry.NestedTable2).NestedTable2.ID = ThisItem.NestedObject.ID) ) )
Please take a try with above solution, then check if the issue is solved.
More details about the Remove function, please check the following article:
Best regards,
Hi @ericonline ,
Could you please share a bit more about your issue?
Do you mean that the Remove() formula part within the formula that you provided do not work?
Based on the formula that you provided, I think there is something wrong with it. I have made a test on my side, please consider take a try to modify your formula as below:
If( Or( ThisItem.NestedTable1.Status <> If( little_toggle.Value = false,"N", // The Data Source toggle values come in as "N" or "Y". little_toggle.Value = true,"Y" ), IsBlank( Filter( First( colStatus.NestedTable ).NestedTable2, NestedObject.ID = ThisItem.NestedObject.ID ) ) ), Collect(colStatus, Table( { all: kinds, ofCrazy: Table( { things: ThisItem.what, things2: ThisItem.seriously, NestedTable2: { ID: ThisItem.NestedObject.ID, }, NestedTable1:{ Status: If( little_toggle.Value = false,"N", little_toggle.Value = true,"Y" ) } } ) } ) ), Remove( /* <-- Modify your formula here */ colStatus, /* <-- Type your Collection data source here, rather than nested table */ LookUp(colStatus, First(ofCarry.NestedTable2).NestedTable2.ID = ThisItem.NestedObject.ID) ) )
Please take a try with above solution, then check if the issue is solved.
More details about the Remove function, please check the following article:
Best regards,
Wow Kris @v-xida-msft !
You are far and away one of the most diligent members of this community. Thank you for always digging into the code and posting thoughful solutions. You have helped me develop very complex applications and I'm very grateful.
#PowerHomies!!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
172 | |
63 | |
32 | |
31 |
User | Count |
---|---|
339 | |
270 | |
105 | |
71 | |
56 |