Hi All:
I am trying to get the SQL data imported into the Sharepoint list. I ran into an issue where the expression is basically a boolean, not a string. So we changed some of the columns in SQL table from int to bit.
And I got this error when loading the SQL columns into the SP Create Item action...
"Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_item': The parameter with value '"@items('Apply_to_each')?['Focus_Area']"' in path 'item/Focus_Area0' with type/format 'Integer/int32' is not convertible to type/format 'Boolean'.'."
The columns in SP have the Yes/No column and I tried to use the custom value instead of the Yes/No selected, it errors out.
If I use the SP column that ends with '_1' that has the short text data type, it takes it in yet the outcome is True/False... BUT the expression would NOT work.
Outcome in SP list
The expression I tried using in the Approval action....Concat is a string yet IF is a boolean....??
concat(if(equals(outputs('FIrstEmailUpdate')?['body/LateEntry_1'],True),'Late Entry',''),
if(equals(outputs('FIrstEmailUpdate')?['body/DuplicateNoteType_1'],True),'Duplicate Note Type',''),
if(equals(outputs('FIrstEmailUpdate')?['body/HighMinutes_1'],True),'High Minutes',''),
if(equals(outputs('FIrstEmailUpdate')?['body/HighUnits_1'],True),'High Units',''),
if(equals(outputs('FIrstEmailUpdate')?['body/LongTimeNoUnits_1'],True),'Long Time, No Units',''),
if(equals(outputs('FIrstEmailUpdate')?['body/COVIDText_1'],True),'COVID Text',''),
if(equals(outputs('FIrstEmailUpdate')?['body/Short_Counseling_1'],True),'Short Counseling',''),
if(equals(outputs('FIrstEmailUpdate')?['body/ZeroUnits_1'],True),'Zero Units',''),
if(equals(outputs('FIrstEmailUpdate')?['body/NegativeMinutes_1'],True),'Negative Minutes',''))
Yet a value would not show up for the "Error Type" Approval form...
This is frustrating....Need ASSISTANCE!
