You’re offline. This is a read only version of the page.
Announcements
Hi All,
I'm confused with why this doesn't work.
In my screenshot, RowToUse correctly evaluates to 0 in line 12. I can access ExcelData[0][1] and get the expected value in line 13. If I try to access ExcelData[RowToUse][1] in line 14, I get an error: Variable 'ExcelData' doesn't have a property '0'. I get the same error if I have a step to convert the RowToUse to a number (or number to text since I tried both).
Thanks for any help!
Is %DisputesFileMatchesForThisCSR% a variable generated by Find or replace in data table? If so, you must first convert the indexes to a number using Convert text to number. The Find or replace in data table returns indexes as strings.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
Share
Report
All responses (
Answers (
522
