Share
Report
6Hi all,
I have a Microsoft form set up where people are entering a network request form. that form is automatically being dumped to a sharepoint excel file, and periodically that excel is being mailed out to people.
One thing that came up was when we need to do revisions. The team has been instructed to ensure the event name of the request is consistent if they are doing a revision, and including all of the old information as well as the new info that's revised.
In an effort to keep the exported document clean, I'm trying to set it up so when a new response is submitted, its adding the row to the table I created, I then have it set up to list rows in present table, and set up an apply to each with condition.
The issue i'm having is i'm trying to compare the event name on the form, and the booking name from the new response submitted, and I dont think its working.
The idea is IF the two names match, AND the ID on the form does not equal the submitted ID (dont delete itself!), then it will delete the row.
Sadly, nothing happens. I did try to use trim() on both of those, and that ended up being ALWAYS true for every row, and deleted my entire spreadsheet.
Any suggestions to this? If you need more information please let me know!
All responses (
Answers (
