Re: I could use some help writing an expression if anyone is willing to help it would greatly be appreciated
Hi @JohnH70 ,
We need to use the internal name of the column in the expression.
I noticed that your 'pallet #' column name contains special characters, which will cause the display name to be different from the internal name. We need to jump to the settings of the SharePoint list. View the internal name of 'pallet #'.
Here are the steps to view the 'pallet #'internal name:
My Flow:
I arrange the items in the list in descending order, and then take the top one item, which is the last item, so that I can get the last used 'pallet #', then create an integer variable and set the value of the integer variable to the last one 'pallet #' add 1.
ID desc
add(int(items('Apply_to_each')?['InternalName']),1)
The internal name of my 'pallet #' column is 'pallet_x0023_'.
Please check your own ‘pallet # column’ internal name, and then replace the column name with the internal name when referencing my expression.
Best Regards,
Sunshine Gu
