I am trying to create a kind of registration tool with a Sharepoint list (next step could be to create an app), but I am struggling to get the value of a lookup column. I read a lot of forums and tried a few things but I must be doing something wrong and I can't figure out what it is...
I have a list called "Yoga Schedule", where the goal is to show the dates for the classes and how many slots are still available for registration.
Then I have a second list for registration, where the person will need to enter the date they want to register, which is a lookup column from the list "Yoga Schedule", and their name.
So to show the remaining slots for that date in list "Yoga Schedule", I created a column called "Registered", which is a lookup (Count Related) of the date in list "Yoga Registration"
My next step would be to calculate "Max Slots" minus "Registered", but I know lookup columns can't be used in calculated columns, so I tried to work it out with Microsoft flows by creating a mirror of my "Registered" column that can be used in a calculation for the "Remaining Slots". My flow seems to work but I don't get any value in column "Registered Mirror", it's all empty.
Am I doing something wrong?