In my code, Ungroup keeps showing error that a column already exists (I know that it will error to avoid duplicate columns). But I didn't see that particular column in collection structure (under View>Collections). So I thought of dropping the column first just to check, but then DropCoulmns says it can't find that column!
Screen-shots below showing the two errors:
(The variable 'xc2' is just for testing.) I want to ungroup 'Choices' but it shows error saying one of the columns - 'ChoiceCond1' - in 'Choices' group already exists. I was sure it doesn't but to verify I added DropColumns to see if it really does. In second screen-shot, the DropColumns complains that the 'ChoiceCond1' doesn't exists.
I'm at loss here, what am I missing?
Any help would be appreciated.
What is the structure of your collection?
Collection has lots of columns, but out of those two are grouped - Choices and Answers. Partial structure below (unless you need to see a complete one):
Okay, but in your formula you are trying to ungroup by ChoiceCond1 - which is a column of a Choices table. That is not going to work.
What is it that you are trying to achieve? What is the structure of the data that you want from your Ungroup?
If you look closely it's 'Choices' column that I'm ungrouping. ('ChoiceCond1' is argument in the DropColumns).
I'm bringing data from SQL (has comma separated choices in columns), splitting those into nested table, user modifies the data thru the app, concatenating back, and sending to SQL.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!