I am getting Column Name is not Valid, As per my knownledge i have given correct,
@ramkrishna2k3 In the excel sheet for price column check is there any spaces.
NO, There is no Spaces
Its in Number Only.
i know your data is number, but change the column format to number format as well.
or already in number format?
Just Changed to Number format…but getting the same result.
this might be the solution, seems your filter data not found ‘Price’.
In your Read Range activity -> type “A1” in the range -> then uncheck the AddHeader in property.
or try attach your xaml (?)
BlankProcess_2.zip (151.8 KB)
done run it and see.
but i found something funny.
- your 1st filter table, you set the condition < 50000 but the result is all >50000
- your 2nd filter table, you set the condition < 50000 as well but the result is true <50000
the final result in excel is correct while the condition you set is odd
ok this is the perfected one (i’m perfecting the coloring, above50k filter condition, below50k filter condition).
please mark as solution if this is working (in mine it’s works),
now it depends on you to implement it on your real project.
BlankProcess.zip (21.2 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.