I am using excel application scope and then a write range activity.
In my parent excel file I have a Data Validation created which should not allow any value to be entered which is less than 50000. However when I am using a write range activity that overrides it. Does any is aware of such incidents! I am expecting this to throw an business rule exception. But I do not see it happening!
@RAKESH_KUMAR_BEHERA Can you check manually by typing the Value greater than 50000, to Check if it is Accepting that?
2 Likes
Yes, I tried and it does not accept locally inside the excel file as I have set a data validation.