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?
User | Count |
---|---|
34 | |
8 | |
2 | |
2 | |
2 |