I am working on a Power Apps application where I need to handle data returned from an API dynamically. The API response contains nested JSON objects, arrays, and sometimes objects within arrays. The challenge is that the structure of the…
I'm trying to use Power Automate to obtain the employeeID field that is retrieved by Get user profile (V2) but not made available as a dynamic content. This method is outlined in the answer to this question. I've created a…
I am encountering an issue while working with Azure Active Directory authentication. Specifically, I am receiving the following error message: {"error":"invalid_request","error_description":"AADSTS900144: The request body must contain the following parameter: 'grant_type'.} Here is the context of my request: Endpoint: https://login.microsoftonline.com/{tenantId}/oauth2/v2.0/token Request…
I am currently trying to move data incrementally from SharePoint Online Folder to Azure BLOB storage. I have been able to set the configuration using Azure Logic App. There is an event-based trigger when a file is created in a…
I have created a Power Automate flow to capture changes on a SharePoint List: Here's the body response I get from the wiql query: To update the work item if exists, I need to work item ID. To get that…
I have a Power Automate flow that parses a JSON file and at some point I want to loop through a number of array elements that have a common structure like the sample below (NOTE: every parent element "Fo..." has…
I have a json which looks like: [ { "TimePeriod": "12/12/23 - 12/26/23", "ResourceName": "rob brien", "TimesheetStatus": "Submitted", "SubmittedBy": "rob brien", "LastModified": "12/12/23 7:12 AM", "InvestmentTasks": [ { "InvestmentID": "PRO13796", "Investment": "Credit Risk Regulatory ", "Description": "A3-Dev/Build", "Hours": { "12/12":…
I upload a JSON file from Power Apps to a SharePoint folder by running a Power Automate flow. At this point I am trying to get the saved JSON file's contents in order to Parse it. My Compose step returns…
I am using power automate to post a card to Microsoft Teams whenever a Microsoft Forms response is submitted. The Microsoft form includes a choice field ("Operating System") that has 3 options ("iOS", "Android", and "Both"). I am using Adaptive…
Hi i'm making an onboarding flow which in Power Automate cloud which will create a user, assign them to a department and add them to a distribution list accodrding to their department and generate aliases based on their email adress.…