Power Platform Community Forum Thread Details

Help with connector to order data

Hello, good afternoon. I would like to know if anyone knows or if there is any connection - action that can help me for this problem.
I have a custom connector that connects to the Facebook API.
This information I have to save it in order to send it by post method to a server.
The problem is that the data does not come in the same order. Sometimes they are first, sometimes at the end.

I create a row in excel with an ID to help me identify the new record with its corresponding data.

I have conditional if to ask if the key is last name or first name or phone number, etc.

so that it updates the columns in an excel file that correspond to these elements. This information is then read and sent to a server.

I have to iterate that temporary table in order to send the data properly.

If you could help me to correct how I could create a row with all this information sorted without making updates to an excel row each time it finds a field to send the information well.

Then, I have to clean it for the following executions so that it does not send duplicate data to the server.

Dear elaaadani,

I am not entirely sure that I get everything in your description, but it seems to me that you are struggling with the setup of the array you get as an output from the custom connector.

Rather than trying to work with this array, maybe it is a suggestion to take the array data and treat it first as text only. With a couple of Compose actions (split() mostly) you could probably change the setup of the array into something that does work for you. For example instead of a label 'name', have the label 'Brand' and then the value.

This text (if arranged properly) could then be loaded again as an array and work as per normal.

Just a suggestion, hope it can help you out.

Happy flowing,

Koen

Quick Links