Hello,
I am brand new to power apps, I am trying to create a power apps form that feeds into a sharepoint list to record data for some users.
It requires that the users select a few dropdowns (Being Select Vehicle,Week, and then Location).
After that I have put in some fields from the sharepoint list that sources the data such as Number of visitors, issues,Date, Additional comments.
I am trying to find the solution how to submit the data to a sharepoint list but specifically keep havng issues with the third dropdown (Location) which is a filter based on the previous dropdowns (Code is
Filter('Mobile Library Details', Mobile = 'Vehicle Dropdown'.Selected.Value, Week = 'Week Dropdown'.Selected.Value) ).
I currently was trying to store the submissions in the same sharepoint list as the source with a new collumn tagging 'Details' and 'User Entry' to differentiate entries from details. However, I am now thinking it might be better overall to set up another list for the results to be submitted too?
Anyway this might be terrible to see but this is what I tried onsubmit for the button. I've broken the formula and getting frustrated! Any help is much appreciated!!
SubmitForm(Form1);
Patch(
'Mobile 'Mobile Libraries Entry Form Details',
Defaults('Mobile Libraries Entry Form Details'),
{
Mobile: 'Vehicle Dropdown'.Selected.Value,
'Week': 'Week Dropdown'.Selected.Value,
'Stop name': 'Stopname Dropdown'.Selected.Value,
'Number of Visitors': 'Number of Visitors_DataCard1'.Text,
'Number of Issues': 'Number of Issues_DataCard1'.Text.
}
)
