Creating a Flow with Microsoft Lists to Excel

(0) Share

Report

Posted on by crAK

Hi,

I need to create a flow that every time a line created in my Microsoft List Flow must do:

Look at the columns A B C D E F G H J K L M N O P Q (which are selection columns and their values are A1 A2 ...) and look for which item selected eg. If A1 is selected It must write an X in the box near the A1 if A2 is selected it must write an X near the A2.

Columns and excel list is like that.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

To confirm, you have a list and in the list when you select any item, from column A , look for the same value in excel if found, type X in checkbox near to it.

Hope i am right

Was this reply helpful? Yes No
crAK 9 on at

Like (0)

Report

Yes you are right.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @crAK

Do you have any simmilar sample excel file above to give a try on ?

Was this reply helpful? Yes No
crAK 9 on at

Like (0)

Report

Here is the excel file

Risk Analizi Doku...

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @crAK

Well, i found one limitation, excel action in power automate cloud requires table inside the excel which this excel sheet doesn't have

Was this reply helpful? Yes No
crAK 9 on at

Like (0)

Report

It is an hackathon project so I don't have access to documentation who made this or how it is made.

Was this reply helpful? Yes No
Venoo 71 on at

Like (1)

Report

This is quite challenging. There is no way to populate a certain value to a targeted cells using power automate.
For the first part - Since the results seems to be a single selection you can create an additional calculated column for every possible answer. If(right(left(response value, 2),1) = 1, 'x', '') for A1 to be marked X, and A2, and A3 to be blank.

This will give you a ready to use dataset to populate cells.
But populating cells can be possible only using VBA script I am afraid.

Was this reply helpful? Yes No
crAK 9 on at

Like (0)

Report

Since I am new to this program can you give certain example if possible please

Was this reply helpful? Yes No