Condition in if error?

@Nithinkrishna How to loop read all sheet in file input?

1 Like

Hey @fairymemay

Use Get Sheets activity & store the sheets collecton.

Then Iterate the collection using For-each

Hope this helps.

Thanks
#nK

@Nithinkrishna I edit your code for loop sheet as below.

Main.xaml (23.1 KB)

But now show error , I don’t know what wrong?

and I have question , If data 100K , it run slow or not.

1 Like

Kindly correct the Address2 spelling in the input sheet.

For the data count you mentioned, is it input sheet data or the other sheet…?

Hopefully that shouldn’t be an issue…

Thanks
#nK

1 Like

@Nithinkrishna Now , It can run.
But I think run slow , because use for each row (data have 100K ----> slow)

How to another way for map data fast?

1 Like

Hey @fairymemay

It’s possible through LINQ

Thanks
#nK

@Nithinkrishna Can​ u​ guide​ me​ for​ use​ Linq?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.