I have two Canvas app forms that are connected to each other with Power automate. one form let users submit and edit their requests, and the other form is used by management to view the information that users submitted and add additional items to it.
In my management form I have a choice column for Status => (New),(Reviewing),(Completed)
I would like to lock the forms edit icon from the user side when managment is reviewing the form meaning the (Status=Reviewing) in the management form.
Thank you very much in advance
Solved! Go to Solution.
@Mopower In the DisplayMode of the edit icon you'll have this formula (replace SPList2, ID & IDinTheForm with the actual names),
If(LookUp(SPList2, ID=IDinTheForm).Status="Reviewing", DisplayMode.Disabled, DisplayMode.Edit)
Put this formula in the DisplayMode of the Edit icon (replace StatusDropDown with the actual name),
If(StatusDropDown.Selected.Value="Reviewing", DisplayMode.Disabled, DisplayMode.Edit )
Hope this helps!
The problem is I have two different PowerApp apps forms. I am trying to use the choice field named 'status' from my Managements app, in my second applications (Users) editi icon. How do I pass my choice as variable so I can set the if condition.
is the data being held anywhere such as Sharepoint, CDS etc.? if so you could update the status with one then read the status column from your data source with the second app.
@Mopower Do you have 2 separate Apps or 2 Forms in 1 App. Could you please clarify?
Screen shots would be helpful.
I have two Different Apps that uses two different sharepoint list. I would like to use the choice field from my first app to set a condition.
@Mopower Could you share a bit more on why 2 list when Users and Management are looking at the same information. The more info you share the sooner we can find a solution!
The Management list has additional column items in it that the users list dont have. My users list hold just basic user information, and the management list imports those info from the users list and builds on it. It make sense to use one sp list but this is the requirement from client.
@Mopower In the DisplayMode of the edit icon you'll have this formula (replace SPList2, ID & IDinTheForm with the actual names),
If(LookUp(SPList2, ID=IDinTheForm).Status="Reviewing", DisplayMode.Disabled, DisplayMode.Edit)
currently its 1 form in 1 app
User | Count |
---|---|
248 | |
105 | |
82 | |
51 | |
43 |