Power Platform Community Forum Thread Details

Experts, I have a scenario where a Cloud Flow should be triggered automatically whenever a new Excel file is placed in the OneDrive folder. I have followed the guidelines provided, but I'm facing an issue starting from the second step.

Here are the steps I have taken so far:

Initialize the first variable with the name "Posttime" and the type "Array."
Initialize the second variable with the name "Tokenkey" and the type "String."
Declare a variable called "Tokens" to list the rows in a specific table.
Create an "Apply to each" loop to iterate through the values. Select the output from the previous steps and set the variable "Tokenkey" with the value "TokenValue."
Use the HTTP action with the method "POST" and the URL "https://ok/powerapps/confirmation." Set the authorization header to the "Tokenkey" value. In the body, include the following parameters: "maintenance_order," "operation," "technician," "start_date," "start_time," "finish_date," "finish_time," "free_text," and "code."
Set the second variable, "Posttime," with the value from the response.
Finally, use the response with JSON code.

Please review the steps and let me know if you spot any issues or if there are any suggestions for improvement.

Below is the flow screenshot.