Need help: saving multiple numbers in one sharepoint list element

(0) Share

Report

Posted on by IamTrying

Hi guys,

I need help regarding the following task:

I want to save several ID´s that are stored in a sharepoint contact list to an entry in another sharepoint list (linked object) in such a way that I can display all IDs or contacts that are linked to this entry in a later LookUp function.

How can I do this . What kind of Sharepoint list element is best suited for this?

Greetings

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I think a simple text column will be sufficient for your requirement.
To do it:
On PowerApps
1. Create a collection of these ID's and Convert them to a concatenated single text.
Below code is an example of concatenate. It will make a Collection of IDs named ColID into a string. Then store that Value
Input:
ID
-----
1
2
3
Output:
1#2#3

Concat(ColID,ID & "#");

2. For further use, to make that ID collection again from SharePoint, use the Split function. Code below is given in the assumption that you will give the column name in SharePoint as ReferenceIDs

Split(ThisItem.ReferenceIDs,"#");

You can further maximize it by assigning it to a variable and use the variable to filter ID from another SP List.

//Assigning: Set(varIDList,Split(ThisItem.ReferenceIDs,"#")); //Filtering Filter('AnotherSPList',Not(ID in varIDList));
IamTrying 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi cha_cha,

thank you so much for you answer.
That looks great, Iam gonna try that asap.

Greetings
IamTrying 58 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi cha_cha,

I used the concat function to create a string in a label which works. The function for "Text" was
Concat(CollID;ID&"#")
But for whatever reason I cannot bring the Split function to life. I tried in another Label Element to Split and display the result. I used in that other label the following function
Split(Label.Text;"#")
But for any reason I get a error for that function. It says that a text value is expected and that the function does return a table value. But Label contains the concat string. What am I missing here?
Thanks in advance
René
IamTrying 58 on at

Like
a
(0)

Report
Copy link

Link copied!
I solved that Problem.
Now I do have another Problem. I managed to Filter the items of the contact list in a gallery with splitting the concat string and filtering the ID with the following code

Filter(contact;ID exactin Split(String;"#"))

Consequently I am able to display all contacts that are connected to a certain object that is containing all the IDs in its column.

Now I have to find a sollution to the following problem:
A third list (object_tasks) does also contain the multiple ID´s of contacts that are connected with that task. I am now trying to display all tasks that are linked to the contact in a gallery. The problem is, that I need to filter list entries that are strings like #ID##ID##ID##ID# or just ID. How do I Filter the list if I have a certain ID for the single contact?
Does anyone have an idea?

Greetings