
Announcements
Hi,
I am getting the error above, I think it is because the filed I am passing is not what SharePoint column is expecting.
In a text column, I want to substitute 'First Last' name with 'First.Last@emailaddress.com'; I built a small flow to compose a variable with the fields I want however, when I pass it onto the appropriate SharePoint column, I get the error above, both formatting the column as string of text or person or group type.
How do I format the output of the variable action so that can input into the SharePoint column?
Although probably redundant, I initialized the variable as 'string' and set the output of the compose action into this string which then feeds into the 'update item' action.
Any help appreciated.
Hi @Anonymous,
Could you share the details of your Flow configuration?
I want to know what the data type of the column you want to change.
I did a test on my side, if the data type of the updated column is single line of text, maybe you could refer to this method.
SharePoint list: The column types are all single line of text.
Flow:
Without using variables, use Compose to complete string concatenation directly in Apply_to_each, and then configure it in Update item.
Expression:
concat(replace(items('Apply_to_each')['UserName'],' ','.'),'@emailaddress.com')
Please take a try and let me know if issue still exists.
Best Regards,
Barry