Compile Data in 1 Column & 1 Row

(0) Share

Report

Posted on by firda59

372

Hi,

I have this logic:

1. sharepoint 1

2. sharepoint 2

So i want to transfer data welder from sharepoint 1 to 2, but I want if:

kolom1 = 123

kolom2 = j.2

then, welder (in SP List 2) = choice 1, choice 2

I used this formula to grab the data, but the value not like I want.

Does anyone know what the formula should I use? Thankyou!

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @firda59 ,

Could you please tell me what welder (in SP List 2) 's datatype is ? Is it a single line of text column or a choice column? Does it allow multiple selelctions?

Best Regards,

Bof

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

type data is choice, and allow multiple selections.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @firda59 ,

I've made a test for your reference:

1\

item()['Value']

Result

Best Regards,

Bof

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

hi @v-bofeng-msft

I dont understand why it cant work in my power automate, since platfrom update, sometimes it error, and I dont know why

Do you know how to fix it?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @firda59 ,

Please switch to classic designer and try again.

Best Regards,

Bof

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

Sorry, I put the wrong SP list.
Now it successful, but, this is the result:

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @firda59 ,

Please turn off list1's welder column's allow multiple feature.

Best Regards,
Bof

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

hi @v-bofeng-msft

the column from the first try is off multiple

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft ,

Hi, thanks for your help, I just find out I wrong put output in welder 'Update Item'. Now, it can work well, thankyou!!!

Was this reply helpful? Yes No