Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

App Formula / Automation Bug

Im just setting up a scheduled bot to write data into some columns on a sheet. Obviously when this runs all App formulas & Initial Value + Reset on Edit columns update. Its acting weird so I think it might be a bug…

I have a column with this as it’s formula

ANY(SELECT(CourseData[Code],[Name]=[_ThisRow].[QLLongText]))

It’s worked for months in the App without issue and stills works when [_ThisRow].[QLLongText] is changed. Yet when the scheduled Bot runs this is reset to a blank cell. I checked and double checked the data and there is no issue. I even went into that record in the App to edit it manually to so if it goes blank - it doesn’t

Changed it over to an Initial Value + Reset on Edit and it works fine. In that it now isn’t blanked when the scheduled Bot runs.

Hmmm, odd.

Is this a bug in the new Automation section?

0 2 252
2 REPLIES 2
Top Labels in this Space