How to pass dynamic value in Read Range of GoogleSheet Modern activity
Both sheet name and range should be dynamic
Hi @samkareti1260
You can declare two string variables and pass those variables there
Now have assign activity before this excel activity and assign the path and sheet name you want to work on
Before accessing file u can use file exist to confirm and than proceed with the steps
I tried as mentioned as above… but no use…
If possible can u share screen shot of the values being passed @samkareti1260
Hardcoded value which is working below…
‘Report’!A1
Note: syntax as it no double quotes…
Dynamic syntax:
“‘“+SheetName+”’!A1”
Tried multiple ways…
Appreciate your time
I think this should work Check in logs if u print this what is coming
Same as hardcoded value or not ……@samkareti1260
“‘“”+SheetName+”’!A1”
Otherwise u can try to manipulate this by replace function
Take one string assign “ ‘@sheetname’!A1”
Than string.replace(@sheetname, your variable name )
@samkareti1260 did u get a chance to try this
My bad somehow missed your response… it worked if you perform operations in a variable n pass that in range of the activity…
it’s bit strange same syntax not working in when directly used in range of the activity…
appreciate your time
1 Like
Thank u for the response 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.