Hello.
So I am going to explain this as best I can in the hopes that someone here will have a really efficient way to complete this request. Its only condition is we can't use powers app as this is not supported for our organisation
Current Flow
I have 2 lists Booking Data (List A) and Course Data (List B)
- When a new item is created in List A the flow "Gets Items" from List B filtered by the Course ID in List A.
- (List B has unique data and is sorted by Course ID)
- The next step is a condition where (using a conditional Y/N column in List B) the flow looks at if the spaces remaining is >1 in List B for the course.
And here in lies the predicament. The "spaces remaining" column in List B is a calculated column which takes the number the in Provisional Spaces Column (Whole Number) and Confirmed Spaces Column (Whole Number) away from its original number in the Spaces Remaining column.
What needs to happen is when a new item is created, it will add 1 to the provisional spaces. My initial thoughts was to use add( ) with dynamic content however I keep getting various errors no matter what I try:
"'The template language function 'add' expects its first parameter to be an integer, a float or a decimal number. The provided value is of type 'Null'."
&
"InvalidTemplate. Unable to process template language expressions in action 'Update_item_2' inputs at line '0' and column '0': 'The template language function 'add' expects its first parameter to be an integer, a float or a decimal number. The provided value is of type 'String'."
When I try to add a variable it doesn't let me pick the "Provisional Space" column from the Get Items - Course data. I am missing something really obvious I know it but cannot seem to work out what this is.
