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]