I built a canvas app that uses a dropdown field connected to a secondary lookup list. I can successfully select any of the values from the source list, however, after I submit the form it returns "50" for some reason. It's the weirdest thing. I have a flow that updates, however, it's not touching that field at all.
Not sure where to go from here.
Fixed it! Added another "Choice" column in list settings with all the choices and used the lookup function to the secondary data source to get the state I was looking for, then proceeded to remove the column causing the issue.
Used the below formula in the text field (default) for grabbing the corresponding column data I needed.
LookUp('Company Site Numbers', Title = DataCardValue1.Selected.Value).State
How do I map to the SharePoint list column that I need? I'm a little perplexed as I've never had this issue with other apps I've built in PA using the same setup (or so I thought?)
The funny thing is, I've matched this field up with the exact same setup I have in the edit PA form (which works)!
Hi @ShawnPelletier ,
I doubt if your field 'Company Sit Number' is mapped to the field of your datasource.
Please check the mapping once again of your existing text field.
Since if you change any control (for ex: text to dropdown) then you have to map the dropdown's value on text field so it will save the correct data.
Else it is just a independent dropdown value reading data but not putting on your form while you submit.
I just recreated another canvas form. This time it's not submitting the value I choose to the record (field value is blank). The field (Company Site Number) is a standard text field under list settings. In the form I changed it from text to "Allowed Values" which changed it to a dropdown.
Under properties [Items] for the text input I have "Company Site Numbers" which is the secondary data source. Under properties [Value] for the text input I have "Title" which is the correct column. When I preview or publish the form the correct value show up in the field and when I select a valid choice.
Now when I submit the form the column in the list view returns blank\empty. My submit formula is below.
OnSelect= submitForm(P2P)
OnSuccess = NewForm(P2P);Notify("P2P submitted successfully...",NotificationType.Success);Navigate(P2P,ScreenTransition.Fade)
Everything works correctly except the blank value for the company Site Number field.
@ShawnPelletier where is the value "50" coming from?
Hi @ShawnPelletier ,
I'm not sure what "50" is but if its count of records then check Row Limit in PowerApps settings as that's delegation limit.
Can you show any visuals indication to know what you are trying to achieve?
Also, how are you filtering the values of dropdown?
Also check which records is the flow updating and is necessary value passed to the flow.