Power Platform Community Forum Thread Details

I have a csv with about 6,000 records and 12 columns
I need the data from just two columns (phone1 and phone2)
I need to group the two columns into one and eliminate duplicates and blanks
I need to send the unified data in chunks of 50 to another system via HTTPS POST API

My flow below looks like it works but the format of the data ( items() )in the HTTPS body part is wrong.

It looks like:

{

"message": "test ",

"mobiles": [

"\"1111111111\"",

"\"2222222222\"",

"\"3333333333\"",

"\"4444444444\"",

"\"5555555555\""

"batchId": 0

}