cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cardinaluk
Helper I
Helper I

Reading comma delimited string from SharePoint column to collection not working with current function

Objective: Read a csv string from a SharePoint multiline column into a collection.

Problem: https://powerusers.microsoft.com/t5/Building-Power-Apps/Reading-Comma-Delimited-string-from-multilin...

Please read my last post in the above thread (link provided).

TL:DR: It is reading into the collection but not putting the data into both columns:

coll.PNG

The function used to collect from SP column:

ClearCollect(
    collResources,
    With({_sp: Filter(Split(LookUp(EngagementRequests, ID=Gallery1.Selected.ID, RatesCard), ","), !IsBlank(Result))},
        ForAll(Sequence(CountRows(_sp), 1, 2),
            { 
                
             //Rate: If(IsBlank(Value(Last(FirstN(_sp, Value + 1)).Result)), 0),
              Rate: First(Split(Result, ":").Result,
              Role: Last(FirstN(_sp, Value)).Result
             
            }
        )
    )
);
0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,782)