Solved: How to not add the same answer in two different co...

Fields · ‎07-04-2017

Hey guys,

This question is pretty straight forward!

I have two choice columns, with the same exact items:

User A

User B

User C

What i want is, when they first choose the first choice column, if they pick User A, User A will dissapear on the second choice column!

If they pick User B in the first columns, the User B will dissapear on the second column, and exact same with the User C!

This serve to stop them to give the exact same answer in two diferent columns!

Is there any ideia how to do this?

Meneghino · ‎07-05-2017

Ok, then it is even easier than I thought. I suggest that we do not use choice columns for the users but store the text instead. For the topic column I would store an integer (but more on the topic later)

Here is what I suggest:

1) Create a dummy app without worrying about the data source initially

2) Create the correct data source (i.e. one SP list with the correct structure), connect it and then add the patching function

For the first step you should do this:

Create a new blank app
In your app screen place vertically in order
1 dropdown called DropdownTopic
7 rating controls called Rating1 to Rating7
2 dropdowns called DropdownUser1 and DropdownUser2
3 textiputs called TextInput1 to TextInput3

For the Items property of DropDown topic use the following with your real topic names:

Table({Id: 1, Topic_name: "Topic A"}, {Id: 2, Topic_name: "Topic B"}, {Id: 3, Topic_name: "Topic C"})

For the OnStart property of the screen use this:

ClearCollect(MyUserChoices,
Table(
{Topic_Id: 1, Value: "User A"},
{Topic_Id: 1, Value: "User B"},
{Topic_Id: 1, Value: "User C"},
{Topic_Id: 2, Value: "User 1"},
{Topic_Id: 2, Value: "User 2"},
{Topic_Id: 2, Value: "User 3"},
{Topic_Id: 3, Value: "User !"},
{Topic_Id: 3, Value: "User X"},
{Topic_Id: 3, Value: "User #"}
)
)

For the DropdownUser1 Items property, use this:

Filter(MyUserChoices, Topic_Id = DropdownTopic.Selected.Id)

For the DropdownUser2 Items property use this:

Filter(MyUserChoices, Topic_Id = DropdownTopic.Selected.Id, Value <> DropdownUser1.Selected.Value)

Once you have all of this, the rest is even easier. Please let me know how you get on so far. The only difficulty may be if you see numbers instead of text choices in the dropdowns, but there is an easy fix, you just need to choose the correct column in the advanced properties of the dropdown.

View solution in original post

Meneghino · ‎07-05-2017

Once all the above works then for the second step you can create a new list in SharePoint called whatever you like but please avoid spaces and starting it with a number. Let's say you call it Responses.

Then create the following columns in the list:

One column called Topic of number type
Seven columns called Rating1 etc. of number type
Two columns of single line of text type called User1 and User2
Three columns of multiple lines of text type called Comment1 etc.

Next go back to the app and add the list as a data source (please see here for how to do this)

Then simply create a button at the bottom of the screen and set its OnSelect property to this:

Patch(Responses, Defaults(Responses),
{
Title: User().Email,
Topic: DropdownTopic.Selected.Id,
Rating1: Rating1.Value,
Rating2: Rating2.Value,
Rating3: Rating3.Value,
Rating4: Rating4.Value,
Rating5: Rating5.Value,
Rating6: Rating6.Value,
Rating7: Rating7.Value,
User1: DropdownUser1.Selected.Value,
User2: DropdownUser2.Selected.Value,
Comment1: TextInput1.Text,
Comment2: TextInput2.Text,
Comment3: TextInput3.Text
}
)

That is all you need to do.

Once this works then there are many ways you can enhance your app:

1) Improve speed of performance if this is an issue (i.e. time it takes to save)

2) Have a process whereby the user does not choose a topic but is guided through each topic in turn (this is not done via three screens but using a context variable)

3) Basically anything you like

PS This might be good reading for you: https://powerapps.microsoft.com/en-us/tutorials/working-with-data-sources/

View solution in original post

Meneghino · ‎07-06-2017

Hi @Fields

Here is how you do the split screens, for example:

1) For the submit button, add this after the Patch:

; UpdateContext({CurrentTopicMinusOne: CurrentTopicMinusOne+1})

2) Delete DropDownTopic

3) Whereever in the code you have DropDownTopic.Selected.Id replace with CurrentTopicMinusOne+1

4) Add a label on the screen with Text property:

"The current topic is "&
If(
CurrentTopicMinusOne+1=1, "Topic A",
CurrentTopicMinusOne+1=2, "Topic B",
CurrentTopicMinusOne+1=3, "Topic C",
"Error"
)

I am not sure I have understood your question in regards to name changes. Do you mean if you change the name of a column in a SharePoint list after it has been created?

I am not sure I have understood "Also, imagine, i put all the topics and the rating and etc..., how do i make it on the patch?"

In regards to the data sources, I still don't understand why you need three different SharePoint lists and not one. Having one list will make your life much easier.

View solution in original post

Meneghino · ‎07-06-2017

Hi @Fields

The latest code I provided with the context variable will give the impression of three screens, please try it.

For exporting to Excel, all you need to do is to filter your SharePoint views by topic.

Anyway, if you really still want to keep three different data sources, then all you need to do is to change the save button OnSelect to something like this:

If(
CurrentTopicMinusOne+1=1,
Patch(Responses_topic_A, Defaults(Responses_topic_A),
{
Title: User().Email,
Rating1: Rating1.Value,
Rating2: Rating2.Value,
Rating3: Rating3.Value,
Rating4: Rating4.Value,
Rating5: Rating5.Value,
Rating6: Rating6.Value,
Rating7: Rating7.Value,
User1: DropdownUser1.Selected.Value,
User2: DropdownUser2.Selected.Value,
Comment1: TextInput1.Text,
Comment2: TextInput2.Text,
Comment3: TextInput3.Text
}
),
CurrentTopicMinusOne+1=2,
Patch(Responses_topic_B, Defaults(Responses_topic_B),
{
Title: User().Email,
Rating1: Rating1.Value,
Rating2: Rating2.Value,
Rating3: Rating3.Value,
Rating4: Rating4.Value,
Rating5: Rating5.Value,
Rating6: Rating6.Value,
Rating7: Rating7.Value,
User1: DropdownUser1.Selected.Value,
User2: DropdownUser2.Selected.Value,
Comment1: TextInput1.Text,
Comment2: TextInput2.Text,
Comment3: TextInput3.Text
}
),
CurrentTopicMinusOne+1=3,
Patch(Responses_topic_C, Defaults(Responses_topic_C),
{
Title: User().Email,
Rating1: Rating1.Value,
Rating2: Rating2.Value,
Rating3: Rating3.Value,
Rating4: Rating4.Value,
Rating5: Rating5.Value,
Rating6: Rating6.Value,
Rating7: Rating7.Value,
User1: DropdownUser1.Selected.Value,
User2: DropdownUser2.Selected.Value,
Comment1: TextInput1.Text,
Comment2: TextInput2.Text,
Comment3: TextInput3.Text
}
)
);
UpdateContext({CurrentTopicMinusOne: CurrentTopicMinusOne+1})

Hope this helps.

View solution in original post

Meneghino · ‎07-06-2017

If I understood correctly, you do not need to patch the labels.

You can use an If statement to change the questions in the label when the topic changes.

View solution in original post

Meneghino · ‎07-06-2017

Hi @Fields

For the space, please notice that there should be a space between the word 'is' and "

As for the reset, then you need to add this at the end of the submit button OnSelect code:

; UpdateContext({ResetMyControls: true}); UpdateContext({ResetMyControls: false})

Then set the Reset property of all the controls that you want to reset simply to this:

ResetMyControls

View solution in original post

Meneghino · ‎07-06-2017

Hi @Fields

I think the issue is that after you submit topic 3 then the topic number becomes 4 so you should probably substitute CurrentTopicMinusOne+1=3 with CurrentTopicMinusOne+1>3 in your code.

But then it should have done the navigation after topic 2.

As I mentioned, I do not use edit forms as they have all sorts of limitations.

View solution in original post

Meneghino · ‎07-04-2017

Hi @Fields

Yes, here is how you do it. Assuming that your list of choices has a column called ID, but you can use any unique index column, then simply set the Items propery of the second drop down control to the following:

Filter(MyChoices, ID <> DropDown1.Selected.ID)

Please let me know how you get on.

If you have issues, please attach screenshot of the current Items property of the dropdowns.

Fields · ‎07-04-2017

Hey @Meneghino,

Thank you for the help!

Where do i put that code? On the "OnSelect"?

Meneghino · ‎07-04-2017

No problems.

You need to put it in the Items property of the second drop down control.

Fields · ‎07-04-2017

Sorry, but i can't find the item property, Maybe i am missunderstanding everything?

I am sorry for this question, i know the answer might be so obvious, but i just can't find it...

Meneghino · ‎07-04-2017

No problems. If you open up the data card you should find a drop down control in there...

Fields · ‎07-04-2017

I'm Sorry, but i have opened the datacard, and there is no ITEM in there... Only in EditForm1 (In general)...

I really don't wanna waste more of your time... But i just can't see to find it...

Meneghino · ‎07-04-2017

Absolutely no problem, you will learn from this.

If you press the down arrow to open up the data card contents, what do you see?

One of the items appearing should be a dropdown control, and you can select it. It will have the Items property that you need.

Please see screenshots below. In my example (DataCard1) the main control is a text input (DataCardValue1), so your will have a different icon, compatible with a dropdown.

If you are still stuck, please send a screenshot of what you see when you open up the DataCard7

Meneghino · ‎07-04-2017

PS You may have to press the padlock to unlock to change the properties before you can access them, but not necessarily.

Meneghino · ‎07-04-2017

PPS A dropdown should have an Items property (plural). If you are stuck at that stage, please send the a screenshot of the current setting of the Items property.

PPPS You will need to know the name of the dropdown control of your first datacard in order to use it for the second data card.