Announcements
Hello,
how can I fix my datatable? I want the content of the second column in the same row as the the content of the first column.
Thank you for your answer!
Hi @Cedric0404,
Do you mean that you want to delete the blank row of your second column?
If so, please add a update button and set OnSelect as below:
UpdateIf(col3,true,{Answer:""});ForAll(Filter(col3,Answer<>"") As AP,UpdateIf(col3,ID=AP.ID-1,{Answer:AP.Answer}))
Thank you for your answer. But the part with ID doesn't work for me.
Show me how you configure this.
In my scenario, the answer column including answers just has 1 difference in id with the id from Question column, that's why I use ID=AP.ID-1
You need to assign a same id for each answer as each question owns.
so this is my data table. How do I even get the ID's of my columns. Sorry I'm new to Power Apps.
hi @Cedric0404,
I don't know either😂
What's your data source? SP list?
Could you please check the fields tab, find the ID field from the list.
so this would be my data source
It is better if you could tell me what exactly your data source is, Excel table? SP list? Dataverse table? SQL tale?
If there is no primary key, go creating it.
I think you could find that there are multi fields in the Add Fields tab, you should clikc the + icon and expand the field dropdown list and see if there is a primary key like ID there.
So my data source is a list, created in powerapp with "collect". There are no more fields.
Then you could directly refer to the ID....
Please check my solution one more time.
Not sure how you configure the ID expression, I make it in my scenario, so please post the error or the issue in your scenario.
So this is what it looks like. It says ID is not recognized at both "ID". And also "=" is incompatible for the comparison.
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.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
