cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SandroAlvares
Level: Powered On

how to make multi-variable value?

 

Hello,

 

I try more variable is not working

 

Screenshot 1

 

Later try add foreach

 

Screenshot 2

 

But its not work =/ ... look a result

 

 

problem lookup with key index, how to make key index?

 

Help-me... sry bad english!

 

Portuguese: https://pt.stackoverflow.com/questions/204236/como-fa%C3%A7o-criar-mais-declarar-o-valor-da-base

12 REPLIES 12
Leo09
Level 8

Re: how to make multi-variable value?

seems I have the same error. Have you tried with another flow with the action but without Apply to each?

SandroAlvares
Level: Powered On

Re: how to make multi-variable value?

@Leo09 just one foreach not work (apply each)

DionGoile
Level: Powered On

Re: how to make multi-variable value?

Hi there,

You can't have nested foreach loops. So you will need to think about how your data needs be before or after the loop.

If possible change your trigger to be singular (single object) and work through that way or parse the output using data operators parse JSON then run through a separate loop.

I hope this helps
SandroAlvares
Level: Powered On

Re: how to make multi-variable value?

@DionGoil Have you tried with Dynamics CRM + Oracle? if not know is not make response sorry. please before see tags

DionGoile
Level: Powered On

Re: how to make multi-variable value?

Sorry it is hard for me to tell exactly because I cant read the errors.

 

I haven't done this with Dynamics and Oracle, but I have done flows similar with CosmoDB and MSSQL and various CRM's

 

I don't have a setup I make a test flow to see with Dynamics and Oracle, however piecing together from the translation on stack overflow you may have an issue with creating records without a unqiue index ( I had this issue with CosmoDB) as it throws an error as the record already exists.

 

There is a function you can use to make a GUID in Data Operators - Compose "@guid()" - Needs double quotes

 

This will create a globally unique ID you can use to solve an issue with creating records non indexed tables where the data may be the same.

 

Capture4.PNG

 

 

 

 

SandroAlvares
Level: Powered On

Re: how to make multi-variable value?

Oh i see compose, my flow is portuguese not available option compose =( ... how to change a language?

 

One question ur flow is premium?

DionGoile
Level: Powered On

Re: how to make multi-variable value?

I think the language is tied to your Microsoft Account, you would need to change it there.

 

I am not using premium, I thought Data Operations were standard I could be wrong however. They are based on Azure logic apps workflow definitions https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

 

This is what I get when I search for Data  Operations. Compose is one of these.

 

Capture8.PNG

 

If it is not there hopefully one of the Microsoft team can answer how you would get this.

SandroAlvares
Level: Powered On

Re: how to make multi-variable value?

 

Nice, i found compose is translate wrong lol... fine

 

 

Result error:

{
  "status": 400,
  "message": "Invalid lookup_type value",
  "source": "127.0.0.1"
}

 

Lookup fail... its problem INDEX GUID =(

DionGoile
Level: Powered On

Re: how to make multi-variable value?

The index may need to be an integer, depending on your table row configuration for index.

 

Try "@guid(N)" which will generate a number only string

 

As per https://msdn.microsoft.com/library/97af8hh4%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396

 

Then convert the string to an integer using "@int()" example "@int(@guid(N))"

 

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Highlighted
SandroAlvares
Level: Powered On

Re: how to make multi-variable value?

Thanks a link is good tutorial

 

But generate oracle + dynamics crm to OData, its a problem and not know OData =( ... Try accountid is not work a different json

 

Try:

http://www.cleancss.com/json-editor/

 

Look a example:

 

DionGoile
Level: Powered On

Re: how to make multi-variable value?

Something I haven't done yet but have seen this issue come up a few times with flow is the use of Odata ID's through the Microsoft Graph and Oauth.

 

Here's some reading:

 

https://docs.microsoft.com/en-us/azure/active-directory/develop/active-directory-graph-api-quickstar...

https://docs.microsoft.com/en-us/azure/active-directory/develop/active-directory-v2-protocols-oauth-...

 

I will be looking at this my self in the coming week.

 

SandroAlvares
Level: Powered On

Re: how to make multi-variable value?

Interessant! But Azure is premium and not used premium =(

 

Im learning about OData Azure

 

Thank a lot! I'll come back later to find out and answer.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,904)