Datatable

[Cedric0404]

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!

[v-qiaqi-msft]

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}))

[Cedric0404]

Thank you for your answer. But the part with ID doesn't work for me.

[v-qiaqi-msft]

Hi @Cedric0404,

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.

[Cedric0404]

so this is my data table. How do I even get the ID's of my columns. Sorry I'm new to Power Apps.

[v-qiaqi-msft]

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.

[Cedric0404]

so this would be my data source

[v-qiaqi-msft]

Hi @Cedric0404,

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.

[Cedric0404]

So my data source is a list, created in powerapp with "collect". There are no more fields.

[v-qiaqi-msft]

Hi @Cedric0404,

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.