Issue with Submit Button Not Updating Relate Column via Workflow on Edit Screen

May I kindly ask a question? When I click on a date tab in the calendar view, it redirects me to the Edit Screen, correct? I would like the Submit button to trigger a workflow that sets values in a Relate Column. However, it seems that the Submit button does not update the Relate Column as expected. I would like to understand why this is happening and how it can be resolved.

1 Like

You mean a relation column?
A relation column does not contain actual values that can be changed.
However, if it is a single relation, then you can use it to set values in the related row.

If you can add a few screenshots - of the columns, and the workflow, that would be useful.

2 Likes

āļŠāļāļĢāļĩāļ™āļŠāđ‡āļ­āļ• 2025-06-24 101421


Thank you for your response. Here are some example tables and the workflow.
May I ask a follow-up question? When you mentioned ‘single relation’, does that refer to the type of the column?

1 Like

Yes, see below:

Can you show me how your “Relate” column is configured please?

1 Like

Please see below

1 Like

As I understand it, the Submit button executes the data update action first, and then proceeds with the steps in the workflow, correct?
Because even if I set the button’s action to ‘None’, it still updates the data.
Is my understanding correct?

āļˆāļ­āļ‡āļ§āļąāļ™āļ—āļģāļˆāļīāļ•āļ­āļēāļŠāļē · Glide and 5 more pages - Atom - Microsoft_ Edge 2025-06-24 13-26-26

1 Like

Yes, that’s correct.
If you look in the workflow run log, you should be able to see more information about what is happening with the onSubmit action.

Your relation looks fine. Question: does the relation depend on data that is being updated with the edit form? If so, you may need a short wait condition at the start of your workflow.

1 Like

Actually, my situation is a bit different. I’ve built a volunteer sign-up system, where each department has its own schedule and calendar—let’s call this Table A.
There is also a combined calendar (Table B) that aggregates the dates from all departments into one unified calendar view.

To connect Table A with Table B, I used a Template Column based on the booking date and the volunteer’s name. The Edit Form I’m using is from Table A.

My goal is to update data in Table A and, at the same time, have the corresponding data in Table B updated as well.
To do this, I tried to make the Submit button trigger a workflow that updates the Relate Column in Table A, which is linked to Table B.

However, since the Submit button always updates Table A first, the Template Column changes right away—causing the relation to break or mismatch—before the workflow can act on Table B.
As a result, the workflow can’t update the related row in Table B because the relation no longer matches.

Do you have any suggestions on how to solve this problem?
Is there anything I should adjust in the structure or the workflow?
Any recommendations would be greatly appreciated.

1 Like