Hi all,
I am developing a canvas app and the user of the app is geographically located in some other country.
In the app there are some code which will take a sum of a column and send that calculated value to power automate as a parameter to process further, the issue that i am facing is that when i click on the button all the equations are getting processed properly and then these values are getting passed properly but when the user tries the same thing nothing is being passed as value to flow and hence we are getting an empty report as output.
- We both are using same account and hence no issues of permissions/resource not being accessible.
- He is in a different region and hence the language,coding structure are a bit different and it seems auto converted and i am not sure if thats the issue.
- Any help in this case is much appreciated, if anyone else has faced same issue before.
- sample of the code :
Set(
servLiq,
Sum(
Filter(
'Products List',
Value(Created_x0020_Month) = Value(selectedMonthinNum) && Value(Created_x0020_Year) = Value(Value(ComboBox2_1.Selected.Value))
&& CC_x003a__x0020_Accommodation.Value = selectedHouse.Accommodation && categoryMaster = "abc"
),
Liquido
)
)

Report
All responses (
Answers (