item()?[''] changing to manual trigger when saved

[langers1]

I seem to be having an issue with a flow I am building which updates a sharepoint list from an excel spreadsheet table, it all works fine and does what i want it to do until it comes to telling it what fields I want saving to the sharepoint table. I am using the item()?[''] expression to identify what item i want, however when i save it powerautomate is changing the expression to a manual trigger dynamic content.

Before save

After save

Any help you can give is greatly received.

Simon 

[abm]

Hi @langers1 

Where you getting the campaign item from? Could you post a screenshot of your full flow?

Thanks

[langers1]

Hi abm,

This is my full flow:

I am basically getting an excel spreadsheet, turning it into a table, and then turning that table into an Array called MyExcelKeys

I then have the below condition which checks it against an intersection to see if the excel key item exists or not and if it doesnt add it to the sharepoint table. 

I know the flow works as when i built it i managed to get it to run once but i only had a few columns populating, i then went and added more columns and now i just get every column turn into a trigger action when I save it. 

[langers1 · Accepted solution]

Hi abm,

After playing around with it today it appears to be a save issue, I switched on PowerAutomates experimental features which gives a different way of entering the expressions and it seems to all be working fine now.