87
Dear All,
I have an excel file with some numbers, i made Power Automate to pick up a random number from excel as the below screenshots but I face an issue with updating this excel beside the picked number with Done to not choose it again
random function : rand(0,int(length(body('Listrows')?['value'])))
Compose : body('Listrows')?['value']?[variables('Randomcell')]
any assist
Hi @MohamedMo ,
In the action 'Update a row', the Key Value item should be filled with the matching value in the column.
I did a test for you.
Random function : rand(0,int(length(body('Listrows')?['value'])))
Compose : body('Listrows')?['value']?[variables('Randomcell')]
outputs(‘Compose’)?[‘table’]
Best Regards,
Wearsky
Share
Report
All responses (
Answers (
