I’m trying to use the read range activity to get a range from one excel sheet to then use the append range activity to add these details to another sheet.
The tricky bit is the row numbers must be stored in a variable. I’m currently trying to use the below as a range definition but it says I am missing an expression end. It appears to be taking issue with the colon.
“A” + TestRowIndex.toint32 : “D” + TestRowIndex.toint32
@JAGranby Use expression in this format “A” + TestRowIndex.ToString
“D” + TestRowIndex.ToString
Sorry, this has not resolved the issue. It is still saying “end of expression expected”
@JAGranby Can you attach screenshot or xaml file
“A” + TestRowIndex.ToString+":"+“D” + TestRowIndex.ToString
Perfect thank you! Kicking myself for not trying that before!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.