Hello Power Users,
I am using HTTP trigger GET request with specific url, which help me to run a flow whenever there is an update or action performed in this specific url entity.
The problem is, I am getting all the data of this entity, I just want to get the values which are being updated or created due to which the flow is triggered.
Please look into this and help me if there is any way to get these specific change.
What do you get when you test the same GET request in a browser like FireFox?
And have you setup the authentication for the HTTP action with an application in Azure AD?
When I am hitting the url directly on browser I am also getting the same result as you are showing in your image. and for authentication, I already have setup it and using odata http calls in different flows.
But I think I didnt put my question clearly here, I want to get only one value due to which the flow is triggered. For example, When I am creating or updating position details the flow get triggered, here I want to get only this value which is being changed or updated not all the entity data.
For example, If I updated positionId "005258" in position details, Then in flow I should get only this position Id.
I think I have described it well now.
Hi @hunainsami1 ,
In order to select based on particular field add $filter = fieldname eq value in the url after select
eg. ?$select=PositionId&cross-company=true&$filter = positionid eq '0000003'
I know the odata filtering but I dont know the position id which is being updated or created. The flow triggered automatically whenever there is any change in position details, but I am getting all the data in this run, isnt there a way that I only get this specific row value which is changed.
Like @ManishJain I am also not really sure which trigger or connector you are referring to.
However, I do understand a bit better what you want.
If allowed, you could potentially setup/enable the Dataverse integration for one or more tables from Dynamics 365 Human Resources:
When that is enabled you could use the when a row is created, updated or deleted trigger action to get the specific record which has been created or updated.
For that specific record you can retrieve the value of a specific field via a dynamic value.
@ManishJain@ExpiscornovusI am using http trigger with get request, please see the screenshot attached below
@Expiscornovusyou get it right now I want to do the same but with HTTP not Dataverse. As we don't have integrated dataverse. We have integrated SQL and can not move to dataverse now we are already setup with SQL. There is update create trigger in SQL as well but it is not directly synced with D365 HR we have to sync with batch job each time so We can not use this trigger here.
Thanks for investing this much time on this. It would be really appreciated if someone can give me a way to achieve this.
@ManishJainThe SQL does not update directly when the change is made on Position Details. We need to execute the batch job to update the data in BYOD SQL. We can't execute batch job after every change. So we can't use sql update trigger in this case, we need to trigger the flow in real time whenever the change is made in position details
There is not D365 HR update trigger to invoke a flow.
When I am using http trigger, it invokes the flow but it does not give us the exact details rather it returns all the entity data. Is there anything in url we can add to get the parameters directly from http url.
Check out new user group experience and if you are a leader please create your group
May the fourth be with you, join us online!
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.