Forum Discussion
Breaking links to a query as it updates
Do I understand correctly manager adds additional data to the same rows which Form generated? If so you may simply add few other columns to the table which Form uses, assuming Form works with Excel file located on Sharepoint. Form and manager could work simultaneously with the same table, that's kind of co-authoring. Form always adds new row to the bottom of the table ignoring manually added columns, no managers's info will be affected.
If Form works not with Sharepont file when flow. Same story, you may add additional columns which Flow ignores adding next rows. The only flow is less reliable.
ChrisMendoza Cool, thanks. I will check that out.
I've got the forms and flow part working pretty well, but I've never tried merging tables. I'll give it a try!
Do I understand correctly manager adds additional data to the same rows which Form generated? If so you may simply add few other columns to the table which Form uses, assuming Form works with Excel file located on Sharepoint. Form and manager could work simultaneously with the same table, that's kind of co-authoring. Form always adds new row to the bottom of the table ignoring manually added columns, no managers's info will be affected.
If Form works not with Sharepont file when flow. Same story, you may add additional columns which Flow ignores adding next rows. The only flow is less reliable.
Wow, that is so much easier than I thought!
It seems to be working but now I have another question-Can I make a column in my table that will continue to populate with a formula as additional rows are added?
Thanks!
- Nevermind, got it 🙂