
Is it possible to create a column (number) add +1 to the last entry from that same person after Compare person column and create by column in SharePoint online list .
Thanks peter.
Hi @ade1,
Yes, you could approach that following these steps:
1. Create trigger when an item is created;
2. Get items;
3. Add Filter array, filter out person column emails equals to trigger's;
4. Initialize a variable and store the last entity number value;
int(body('Filter_array')[1]['Number'])
5. Add 1 based on the number and store it in the variable:
add(variables('LastEntryNumberValue'),1)
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.