Compare person column and create by column in SharePoint online list

(0) Share

Report

Posted on by ade1

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.

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (1)

Report
Re: Compare person column and create by column in SharePoint online list

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.