Im working on a project where we have to automate a marketing campaign, so far, i was able to build a report in power BI use filters in order to reach the target market customers that i want, (i have their phone numbers in the dataset), my goal is to press the power automate button in power BI and be able to export these phone numbers into an excel file, and in the same workflow, connect to an already existing post API that sends SMS messages to these phone numbers. the API only accepts excel files in the body, ive tried to add an http action in the workflow, but all i get is error after error, eventhough the api is working perfectly (tested in postman).
I will attach some screen shots about the workflow and i hope someone might have a good solution.