Hello
I am hoping someone will have a solution for me.
I have tried several solutions and had no luck with any. Here is my issue.
I have a PowerApps Canvas app that I have put together. The app has just a few screens,
- Startup Screen - this lets the used decide which route the want to take. Options are New Item or Edit Item.
- New Item Screen - this screen has two forms on it and form two is only visible if certain criteia of form 1 oare met. If form 2 is not visible the submit button submitts only form 1 if form 2 is visible then the submit button submits 1st form 1, captures the item ID and then submits form two adding the form 1 item ID to the form and submites it to the sharePoint List. The sharepoint list for form 2 has a column called Form1ID where the form 1 ID is stored.
What I now need to do and am not succeeding relates to the edit screen.
I want to bring up on two different forms in the edit screen the data from both lists. to bring up the items I gave a gallery and when you click on an item it sets the variable value to the Form 1 item number. I then use that variable to display the data, In items property I have varRequestID . This brings up the form 1 Data without an issue.
But I can't seem to find a way of bringing up the corresponding form 2 data, using the Form1ID number.
Can anyone Help me?