Rearrage Positions in Another Table

[juanpa]

Hi all,

I have the following table:

Table A

I want to copy each row to another table using an action/actions/bot/other that rearranges the positions by assigning the last position (in this case 6 but could be fewer or more positions) to the user who has the first position in Table A (Peter) and the first position to the user who has the last position in Table A (Teresa).

Example:

Table A Table B

I hope someone can help

[Joseph_Seddik]

Easy, but please post screenshots of your actual table columns and key columns; the exact expression depends on this info. Thanks.

[juanpa]

Hi @Joseph_Seddik ,

Thanks for answering. Here are the tables:

Table A Table B

Please let me know if you need anything else.

[Joseph_Seddik]

Thank you!

1. Table B column “ID” should be a Ref column to Table A.

2. “Position” of Table B should be of type Number, having the following expression in its App Formula:

   COUNT(Table A[ID]) - [ID].[Position] + 1

3. In Table B, App Formula for:

   • “Name” is: [ID].[Name]
   • “Event ID” is: [ID].[Event ID]