Share
ReportI am trying to add a form to my power app and getting confused how to set it up.
I have a few Sharepoint lists that relate to each other. I created a screen that lets the user filter to find programs. The filtering is done by a series of AddColumns, sorting, and using combo boxes/text fields/checkboxes to create the list. I then have an icon the user can use to go to the Detail screen, where I want to allow them to make edits.
My lists so far for hat I have done are Programs...more to be added once I get this part working.
Programs:
| ID | Title | Name | ServiceType (choice) | other fields... |
| 1 | Type 1 Program 1 | Program 1 | Type 1 | |
| 2 | Type 2 Program 1 | Program 1 | Type 2 | |
| 3 | Type 1 Program 2 | Program 2 | Type 1 |
The programs are unique by the service and program name.
A couple of things I want:
- when the user creates a program, they will choose a service using the title and type in the 'Name'...behind the scenes, I want the app to create the title by combining the service type title and the program's name.
- I want the system to verify that the combination of name/service doesn't exist and present appropriate messages when trying to save,
I created a new screen and am able to navigate to it from the selection listing, and I added a form for the details. After that I am getting confused...I watched a bunch of videos and what they did made sense, but I think my approach is not the same.
The form asks for a Data Source, which I pointed to my Programs list. I thought I would have to point to my previous gallery for the record I want to change in the Item function, but I get an error saying that it is an invalid formula that the source was expected to be the same as the DataSource, which due to the AddColumns, there are more fields and tables than in Programs. This causes nothing to show. How do I get around this?
My next question is how do I go about my other wants? I don't want them to enter the program title, but have that automatically created. by putting the service and name together - I feel I can make that card invisible, but am unsure how to fill it in. Is what I want to do possible?
The biggest issue right now is navigating to the form with the values from my gallery, because although the fields from my Programs list are in there, there are additional ones in there too, which is causing it to be incompatible.
I'm very new to this and it seems what I want doesn't quite fit into the videos I've watched, so I would appreciate any guidance.
All responses (
Answers (
358
