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
Solved! Go to 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.
Hi @langers1
Where you getting the campaign item from? Could you post a screenshot of your full flow?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi 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.
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.