How to remove the comma while updating the table in Received from column

(0) Share

Report

Posted on by Priyanka03

Hi All,

Thank you in advance for all.

I'm updating the row for particular column based on my outputs. Whenever we are updating the column it will update the current value on each and every iteration. I would like to update the previous value as well as the current item in my dataverse table so i used concat operation . I initialized the variable for current item is called Varresult and for previous value to be store in varapproverreceivedfrom variable. Its adding comma infront whenever updating the column

concat(variables('VarApproverReceivedFrom'),',',variables('VarResult')). Kindly help me how to remove this. If i used substring it will remove the last character for each and every iteration.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Priyanka03,

I guess you are using a string type of variable to store all those emails, correct? Have you tried using an array variable instead?

If you append all the e-mail values to that type of variable you can join them all together with a comma character. You can use an join data operation action or join function in an expression for this.

Was this reply helpful? Yes No
Priyanka03 2 on at

Like (0)

Report
Copy link

Link copied!

Yes, its string . I tried to using the join operation and i put like this in compose and now its adding the comma at the end. Please let me know what went wrong. Thank you so much for your help:)

join(CreateArray(variables('VarResult'),variables('VarApproverReceivedFrom')),',')

Was this reply helpful? Yes No
Priyanka03 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I append with array variable,
These previous value is not getting separated with comma i used join function it should be separated with comma right but its updating as it's.
join(createArray(variables('VarApproverReceivedFrom')),',')

Was this reply helpful? Yes No