cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ferrisma
Helper I
Helper I

Change a column status when another column is changed

Hi there,

 

I want to Column A (currently blank) to mirror the contents of Column B when it changes or is created? e.g column B would be the item ID and column A (Title is currently blank)

 

Please advise Thx

12 REPLIES 12
v-bofeng-msft
Community Support
Community Support

Hi @Ferrisma :

Could you tell me:

  • What is your data source? Is it a SharePoint list?
  • Do you want to update ColumnA with the value of ColumnB?
  • What are Column A and Column B ? Are they ‘Text’ columns?

I assume your data source is a SP list and Column A/B are single line of text columns.

The point is to use When an item is created or modified trigger .Ive made a test for your reference:

1\My data source

v-bofeng-msft_0-1607567940074.png

 

2\My flow

v-bofeng-msft_1-1607567940078.jpeg

 

Best Regards,

Bof

Ferrisma
Helper I
Helper I

I'll take look.

 

  • Yes SharePoint lists
  • Yes column A with whats in column B
  • Both Text columns
  •  
Ferrisma
Helper I
Helper I

Hiya so the issue is that Column A is in another SP list from Column B. So when I create/Edit an item in column B I want it to populate column A in the other SP list. Thx

 

Ferrisma
Helper I
Helper I

Ferrisma_1-1607955550071.png

So the title column from this list to populate the Title column in the list below.

Ferrisma_2-1607955609297.png

 

 

v-bofeng-msft
Community Support
Community Support

Hi @Ferrisma :

Could you tell me what is the relationship between the two lists?

In other words, after I update an item in listA, which item in listB should I update?

Best Regards,

Bof

Column A in the first list is an approval list that creates the Title PO(Purchase Order) Then when the PO is approved the Title column (List B, which is a submitted list) should be updated form list A.

 

So both Title columns should read PO#2681Tesco Hope that helps

v-bofeng-msft
Community Support
Community Support

Hi @Ferrisma :

I'm not sure if I understand what you mean correctly, if there is an error, please help me point it out:

When an item in ListA is updated, the value of ColumnB of the item with the same Title in ListB is updated to the value of ColumnA.

If so,please try this flow:

1\I assume Animal is ListA and MyTestList is ListB

2\My Flow

1.JPG

Best Regards,

Bof

 

Thx Ill take a look.

Hiya didnt work Im afraid Flow below 

Ferrisma_0-1608636622031.pngFerrisma_1-1608636656063.pngFerrisma_2-1608636692586.pngFerrisma_3-1608636725445.png

And this was my flow error 

Ferrisma_4-1608636777998.png

Please advise

What is this please? Title Req? Is that just text?

Ferrisma_0-1608646137005.png

 

v-bofeng-msft
Community Support
Community Support

Hi @Ferrisma :

  • "Title" is the name of the title column.
  • eq is a calculation operator, which means 'equal to'

Fiter Query is based on "‘ODATA Query’" which has a unique syntax.I think this link will help you a lot:
https://diyd365.com/2019/11/20/every-power-automate-ms-flow-filter-query-you-ever-wanted-to-know-as-... 

Best Regards,

Bof

Thx Ill take a look. Been off on Holiday first day back today!!

 

 

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (69,987)