
Announcements
What I am trying to do is to add multiple items from a SharePoint list into a collection within the app using a single text input field.
Here is my scenario:
Users are using App A to input a request to have new items added to a system. That application writes to two separate lists. List A, where all the information about the request is going. And List B, where each individual item they are wanting to add to the system is going. Sometimes there is only a single item going to List B, sometimes there are multiple. List B has a column within it that references List A's ID. So there can be multiple List B records.
In App B (which I am currently buliding), they want to be able to look up List A's ID and filter the records from List B
using a Text Input field.
I'd like to take the results from List B's filter and place them into a local collection within App B. The real kicker is that I am already using a collection within the app to search for single items in a different data source. So I already have fields in the collection that i need to write to.
This is what I am currently doing to pull single records into my already established collection:
So now I am trying to take my List B items and add them to the same collection.
Hopefully that make sense.
Hi @NathanFra
I am going to skip the last sentence you are saying so as not to confuse. and I dont know what the flow is about at all so I am going to ignore that too.
You also do not mention whether or not these things are written to SharePOint at some point? Since there is no way for App B to "access" a list in memory of A. Ok.. there is one way but I aint showing that garbage lol.
So a User is in App B.
There is (for simple terms) an Input Box or a Dropdown or ComboBox where they can select or type an Id that belongs to List A.
If that is the case, I have to also assume that in List B, you have the Id from List A written for each Row associated to that Id.
ClearCollect(Filter(DataSourceBListData, ListAsId = TypedIN/selectedValue));
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey