20
Hi,
How can i enter the value field with Json from the Power Bi Fields. I need to choose two fields from the query, which ae Norms and Code. Can you please help me?
When i tried to choose from the dropdown menu it gives me another loop, so How can i do it?
Thank you
In order to generate two documents for the previous example, union gives me unique one raw, but i need few raws for one document, is there any suggestion?
Thankyou
So you want 1 separate file for the both the order codes, so like
1st file
All the three first items, which have ordercode same?
2nd file
All the next three items, with ordercode same?
Then you should try using the union function for this.
Giving you a link for it:
The first method (Variable) worked!
For example, for two order code, I have data like this. Apply to each function before the generate document function would work? How would the apply to each function go to the next order code after generating the document?
Thanks
| Order code | Model | Code | Rev | Desription | Directive | Norms |
| 158SW | BS LED | 1014567 | A | MW 4000K | 4 | CEI EN 605 |
| 158SW | BS LED | 1014567 | A | MW 4000K | 2 | CEI EN 605, 2009/125/C, CEI EN 605, CEI EN 605, CEI EN 605, 2009/125/C |
| 158SW | BS LED | 1014567 | A | MW 4000K | 36 | EN 62471, 874/2012/C, 2014/30/EU, 2014/35/EU, EN 62471, 874/2012/C, 2014/30/EU, 2014/35/EU |
| 40160DL | SanificaAria | 1014566 | A | U19C90 D3K UV | 2 | CEI EN 605, 2009/125/C, CEI EN 605, CEI EN 605, CEI EN 605, 2009/125/C |
| 40160DL | SanificaAria | 1014566 | A | U19C90 D3K UV | 36 | EN 62471, 874/2012/C, 2014/30/EU, 2014/35/EU, EN 62471, 874/2012/C, 2014/30/EU, 2014/35/EU |
| 40160DL | SanificaAria | 1014566 | A | U19C90 DLK UV | 54 | ISO 15714, EN 60335-2 |
Which method worked, variable or select one??
There are two loops in power automate.
Apply to each, which works like a for each loop.
And
Do Until
You can use apply to each for your case.
It works Finally! Thank you very much.
Is there any way we can make a loop in power automate. I have many order codes and i want to make a file for every order code. So i would have to assign a loop function to the order code before generating the documents. is it possible?
Thanks
Both Methods:
1) Variable one:
Initialize empty array variable like this:
And after this add apply to each and append to array action and make json data like below:
2) Select action:
Do, something like below. On the right side, add item()['FieldName'] or item().FieldName or item()?FieldName.
Whichever works for you.
If the above two methods dont work, I dont think I can help you any further.
What's the other method? Didn't get that either. May be i could try the other way or the way she did.
Thank you
Ok. Got it what she did in the video. Actually she might have directly copied the dynamic field values. But, I won't suggest the technique that she has used in the video.
Instead do this:
Initialize an empty array variable, don't add the Power BI Data dynamic field. Keep the value empty.
Then add an apply to each action, pass the Power BI Data dynamic field in that. Then use append to each variable. And pass each column in that while creating that JSON format.
There is one more technique, if this does not work, I will tell you that.
I wanted to take two fields from Power BI.
I followed the format you sent (
{
"Name": SelectDynamicFieldForName,
"Id": SelectDynamicFieldForID,
"Address": SelectDynamicFieldForAddress
}
But when i select the every option i click, it automatically add an other loop(apply to each).
I think there is some small error, which i don't get it.
Thank you.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
