Apologies if this has been answered, but I have searched thoroughly with no apparent success.
I have created a collection, 'Col_bubbledata', with a series of values which are needed as Y co-ordinates for positioning circles on a canvas. The values are entered into the column 'Y co-ordinate'.
Entering the following formula within the circle's 'Y' property (under the 'advanced' tab on the right hand side of the GUI) results in an 'Expected Number value' error:
Col_Bubbledata.'Y co-ordinate'
Reviewing the diagnostics tab, I am told "The rule produces table values which are incompatible".
I have tried using the value() and text(value()) functions to convert the table values to number values, with no success. What's the correct approach here? Is it even possible to do this?
(If it's relevant, I am using @davidni's scatterplot creation method, and this is a workaround to create a best fit line. I do of course appreciate that this is not an ideal situation, but I need to create the scatterplot within powerapps as my company has no powerBI (or any alternative method of) access for this application. I am extremely grateful to David for his contributions here, and for the guidance he has given me previously.)
