Answered

Flow_excel

(0) Share

Report

Posted on by Ivet__

Hello everyone,

I hope to get some advice from you.. I have 2 tables.. I take a value from the first one.. according to which I look for other values in the second one, in "apply to each3" I see its correct value that's I need, but "apply each".. automatically change to other one "apply to each" and didn't find anything.. its just fail.

All responses (4)

Answers (1)

Ivet__ 28 on at

Like (0)

Report

Re: Flow_excel

Hi @v-dezhili-msft ,

that works, Thank you!
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: Flow_excel

Hi @Ivet__ ,
Do you want to obtain the information in Table 2 when the value of the month column in Table 1 is equal to the value of the 2022 column in Table 2?

Best Regards
Dezhi
Ivet__ 28 on at

Like (0)

Report

Re: Flow_excel

Hi @v-dezhili-msft,

at the first thank you,
I give you example..
its about date.. but I try get arround it because of problem format date so.. first table I take number of month what I need to find in second table column in year 2022

before I had flow with "initialize variable" where I identify value that worked but my variable changing by time so I need add first table for that value
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: Flow_excel

Hi @Ivet__ ,
Do you want to use the value of the first table to get the other value of the second table?
Could you please provide an example?
I have a test that I hope will help you.
In my scenario, the Age field and the country field are in different tables, but they are associated through the Name field, and I send an email containing everyone's Age and country.

Best Regards,
Dezhi