I am developing a PowerApps on SharePoint Online, and the data source is a SharePoint List, named "Product".
And I have another SharePoint list named "Items" and also added it as data source for lookup purpose only.
And I have successfully do following, just added 2 combo box to filter the "Items":
1. Select Category & Region
2. Click "Find" (OnSelect: ClearCollect(Collection1, Filter('Items', Category in cboCat.SelectedItems && Region in cboRegion.SelectedItems))
3. Filter the data and showing in a DataTable(Items: Collection1)
For the next step, I would like to store the filtered items in point-3 into a "Mutliple lines of text" field, may be in json format(?), when user submit form.
Finally, when open the from, load the result for the "Mutliple lines of text" field.
Would it be possible, or any workaround?
Solved! Go to Solution.
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021