What I suggested is maybe not what you had in mind.
I tried to generate an outcome as below using this formula:
source.formulamap(RunActions(AddRow(target,
target.Name,
RandomInteger(1,source.Count()).Filter(CurrentValue.Contains(target.Name).Not()
))))
It is variation on the previous one, but this time we only take values not yet part of the list we are creating by leaving out the ones we already have.
anyway, it does not work as expected, I get many blank rows like below:
pushing again the button adds new rows with the values not yet distributed. Filtering the table on IsNotBlank()
after a few hits results finally in a list you want. This is not how it should be. This might work for 6 rows, but not so well for 600 or 6000
Maybe @Ryan_Martens2 , @joost_mineur @Federico.Stefanato, @Paul_Danyliuk or somebody else knows what goes wrong in this approach that was inspired by the this post
In this approach you select manually the item of choice.
Looking forward to understand how to solve this puzzle.