Forum Discussion
Jonas_Daragas
Feb 03, 2023Copper Contributor
Generate autotext + number in column in SP list
Hi everyone, I've been looking everywhere for a solution to my problem. I've made a list that has all sorts of machines. Our intern ID is specified by a set of letters like: BTARM(+number of...
Jonas_Daragas
Feb 07, 2023Copper Contributor
Hey RobElliott
Thanks already for getting me started. I keep getting an error with the action Get Items (see screenshot). It shows that the expression 'InternID ne' is not valid. Any toughts on this?
Also it is unclear to me will this generate the letters BTARM in this Power Automate? Like BTARM1, BTARM2, BTARM3 etc.
Thank you
RobElliott
Feb 07, 2023Silver Contributor
Check the filter query has a single both before and after the null expression, from your screenshot there on'y appears to be 1 single quote.
I'd forgotten you wanted the letters as well,. This flow doesn't do that, it just increments the maximum value. I'll re-read your post and give you a solution as soon as possible.
I'd forgotten you wanted the letters as well,. This flow doesn't do that, it just increments the maximum value. I'll re-read your post and give you a solution as soon as possible.
- Jonas_DaragasFeb 07, 2023Copper Contributor
Thanks alot RobElliott for taking the time to help me out.
You were indeed right about the ' missing. However another error just surfaced. Don't know if it has something to do with the column already having some rows numbered as BTARM1, BTARM2, etc.