Hello!
I have a rather complex question, or it might be easy, but I have not found any solutions to this yet so I hope someone out there could help me. I am sure there are others out there with the same challenges.
Ok, so i have a canvas app where the users enter data. After entering data in several screens the end up at a QA stage. Which means that the users send this data as a PDF with a flow for a QA check. After this I have set up a screen where the users can view all cases they have added in the app. This is set up in order for them to go back or have the possibility to edit the case after the QA stage and send it for approval.
However there is one issue. Let me explain. I have set up a gallery where the users can select the cases and once selected they will see the data in a form. This way they can edit the data and send for approval. For data that is typical numbers, text boxes ect its fine ( from the main tabel) I have set up a form viewing data form the main table. However, I have several tabels connected to the main tabel as a lookup (microsoft entity) that are not working when I try to add new forms with this data.
Let me explain the set up: There is a main table with one lookup to for example "staff" table. The staff tabel is connected to microsoft entity. This is in order to select people in the organization. In the staff table there are collums such as " staff member 1", "staff member 2" and so on. In the first stages of the app the users can select several staff members connected to the case. This is possible through using clearcollect and patching ( making a collection of all the various staff members connected to the case)
HOWEVER, when the user is in the secound phase (after the QA) and viewing there case. I am not able to set up a form to view/ edit the selected staff members. I am connecting the form to the staff table. But "staff member 1" "staff member 2 " and so on are empty. I am able to select new staff members here for the form, but not view the previously selected staff members. I need the form to show me the selected members for the case. So the user have the choice to keep these, or if desirable change them before sending for approval.
How can i set up this so this is actually working?
I am sorry for the messy explanation here, but its not so easy to describe.
I am hoping there is someone out there who knows the solution of this. I will forever be grateful!
