Hey,
Am doing a relate() bulk in my apps thats take up to 2 to 4 minutes, its over 250 or more items, i would like to know if there a possibility to go through a flow with power automate, i found on but it ask for the ODATA ID URL, have no idea what that is.
Thanks
@LoopinG2023, Try to use the GUID function with your Lookups GUID(LookUp(dataSource,Condition,UniqeIdentifierColumnName))
It works without ForAll() for some raison, but do get a return data error that should be in JSON Object
Getting the some error and if i do Format it with Text() it say that it should be in JSON object.
The way you are passing it from powerapps is like you are passing a record, so you need to pass as a string something like below:
Lookup(xxxx).recordid
I get this error when using the flow rather before it starts
am doing i lookup to get the contact GUID.
The flow:
The code:
Lets say you want to relate a contact to an account, so you can get the contact using the Get Row By Id and using the ODATA Id from dynamic content as below:
Alternatively you can construct it as below:
https://org21ffb2a4.crm6.dynamics.com/api/data/v9.0/contacts(contactGUID)