How to get updated fields on a SharePoint list into a Flow?

[eze]

Scenario:

I have created a Flow connected to SharePoint List A.

I add a new field, Field Z, to SharePoint List A

Issue:

I can't figure out how to update my Flow so that I can see Field Z.

Is there an "update object" or "refresh" feature I am missing?

Currently the only way I have found is to delete the reference to the field and add it back. There MUST be a better way.

thanx!

eze

[v-xida-msft]

Hi @eze,

Do you want to reference Field Z dynamic content within an existing flow after adding the Field Z field to related SharePoint list?

I have made a test on my side, after you add a new field to a SharePoint list, when you edit the existing flow which is related to that SharePoint list, the new field (Field Z) dynamic content would be shown up within your flow automatically. So I think it is not necessary for you to update the flow for seeing the Field Z, the Field Z would be shown up automatically when you edit the flow.

If you want to update an existing flow within Microsoft Flow, I think the "Update Flow" action of Flow management connector could achieve your needs. More details about Flow management connector, please check the following article:

Flow management

Best regards,

Kris

[eze]

Yes. I would like to update an existing Flow. 

That is my core use case. During the development of a solution with Flow I often, very often, do not get all the fields right and/or the business changes their mind on a certain feature.

I often need to change data type, field display names, add a new field...etc. 

Is this Flow Management done in Flow? So a Flow to update Flows?

Thanks!

eze

[tninja]

try using get item/items (sharepoint connector), that will get you the refreshed (most recent) SP list content.

[eze]

the challenge is actually the list structure changes. 

the connector doesn't work if the list it is connected to changes, like adding or renaming a field.

it is like the object definition is locked in on the first connection to the list. 

[sharepointPepsi]

Another abandoned thread when the question gets too hard. Par for the course. 

[cbundy]

I had this same issue. A source field in the List had been renamed and the Flow no longer could pull detail for that field.

I resolved it by first exporting and then reimporting that flow. Luckily, this caused the initial trigger to reload the list values and now I'm able to read from the renamed field.

Hope that helps!

[eze]

i'll give it a try! thank you!

[Anonymous]

This is a really annoying problem! 

I tried the export/import route and that didn't work unfortuantely 

Deleting and re adding the connection didn't work either, are there certain types ( I am trying to sue a location ) that don't play nicely with the flow interface?

so for clarity: 

I add an colum to my sharepoint list via the web iterface

I go to my flow add a new "create item" from sharepoint 

and not all my fields are present.  So in this case I am trying to get property_address which is of location type.

the feidls avaliable in the flow interface

the sharepoint list fields I want to be able to access

any ideas would be apperciated!

[KaneMiller]

Hi Jennie, did you find an answer to this problem?

[Greg-JBGroup · Accepted solution]

Make sure in your SharePoint connection (When Item is created or modified in my case) you select the option "Limit columns by View" to show all columns or make sure your specified view includes all columns you need to reference in your Flow. I added a new column and just had to change this setting to see my new columns immediately.