Unanswered

"When an item is created" is missing columns?

(0) Share

Report

Posted on by f2

105

I've created a flow that grabs data from a Sharepoint List, I then added a few new columns to the list, created a variable and noticed the variable wasnt populating the data from the new column but if I changed it to one of the original columns it did get the value.

I then checked the run history, clicked on "When an item is created" and when looking at the outputs none of the new columns I create seem to be picked up.

I cant seem to find anything on google and was wondering am I missing something so obvious that nobody else has this problem lol

Edit: I've made sure the columns arent hidden and tried changing the ordering (incase there was a limit on the number you can have...I have 25 currently).

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

nitishsh91 200 on at

Like (0)

Report
Hi @f2

I faced a similar issue sometime back and here is what I did:
Refresh the SharePoint connector in your flow. Go to the flow and click on the "SharePoint" connector. On the top right of the screen, click on the three dots and select "Refresh connector."
Re-create the flow. Delete the old flow and create a new one using the "When an item is created" trigger. This will ensure that the new columns are included in the flow's schema.
Clear the cache of your browser. Sometimes, after adding new columns to a SharePoint list, it may take a while for the changes to appear in Power Automate. Clearing your browser's cache and trying to create a new flow again can help in this case.

Was this reply helpful? Yes No
f2 105 on at

Like (1)

Report

I was actually re-creating the flow in LogicApps from PA and couldn't see a way to refresh the connector in LA so I asked a colleague to try add/change the connector hoping it would consider that a refresh...but unfortunately it was still the same.

I then tried cloning the logicapp, replaced the connector...still the same. Finally, I re-created the Sharepoint List, selected the new list in "When Item is Created" and yup...all the new columns appeared. Hopefully I haven't forgotten any other columns lol

Really appreciate the help, at least you confirmed I wasn't doing something wrong and I now know to look out for it next time.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (1)

Report

Did you check to see if the first trigger had the selection "Limit Columns by View" filled in by a view option? Maybe it has an older view selected and this might cut off some of the additional data?

Was this reply helpful? Yes No
f2 105 on at

Like (0)

Report

I've never noticed that option before, I still have the original flow/list as I copied it to test the changes suggested by @nitishsh91 so I tried both "All Items" and "Use all columns, Do not limit" but neither seem to work... columns are still missing. Its so weird, maybe a LogicApp thing?

Thanks for the suggestion @wskinnermctc...it could be something I've messed up but I cant think what I've done.

Was this reply helpful? Yes No