how to make multi-variable value?

(0) Share

Report

Posted on by SandroAlvares

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

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Leo09 212 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SandroAlvares 18 on at

Like
a
(0)

Report
Copy link

Link copied!

@Leo09 just one foreach not work (apply each)

Was this reply helpful? Yes No
DionGoile 110 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SandroAlvares 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DionGoile 110 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
SandroAlvares 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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

One question ur flow is premium?

Was this reply helpful? Yes No
DionGoile 110 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No
SandroAlvares 18 on at

Like
a
(0)

Report
Copy link

Link copied!
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 =(

Was this reply helpful? Yes No
DionGoile 110 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SandroAlvares 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No