Single column values stored in Multiple rows in SharePoint list instead of single row

(0) Share

Report

Posted on by Dhinesh28R

599

Hi,

In my app am storing multiple values in multiple rows but its stored in one row.

I need to store in multiple rows.

Am using following formula to store a details in List,

Patch(
List,
Defaults(List),
{

Name:Concat(cname.DisplayName,ThisRecord.DisplayName,";"),

Mail:Concat(cname.UserPrincipalName,ThisRecord.UserPrincipalName,";"),

Department:Concat(Dpt.Value,ThisRecord.Value,";"),

Message: Message.Text,

}
)

My Splist,

Name	Mail	Department	Message
Suresh;Dani;Rajan	Suresh@test.com;Dani@test.com;Rajan@test.com	Java;. net; Accounts	Good work

But i need to store a details in Splist Like this following,

Name	Mail	Department	Message
Suresh;	Suresh@test.com;	Java	Good work
Dani;	Dani@test.com;	. net	Good work
Rajan	Rajan@test.com	Accounts	Good work

How to do a loop in my formula?

I need to store a details in separate row in a List.

Thanks,

Dhinesh

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dhinesh28R ,

I am, not sure on your data source in relation to the ThisRecord reference, but this is the syntax you need

ForAll( cname As aName Patch( List, Defaults(List), { Name:aName.DisplayName & ";" & ThisRecord.DisplayName, Mail:aName.UserPrincipalName & ";" & ThisRecord.UserPrincipalName, Department:aName.Dpt.Value & ;" & ThisRecord.Value, Message: Message.Text } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Dhinesh28R 599 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Its working fine man, But one issue is there.
Because in my formula cname and dpt are different collection.

But you're using a
"Department:aName.Dpt.Value & ;" & ThisRecord.Value" It's getting error.

Because of both are different collection.

Now i don't store a department value in separate row. this is only one issue.

Others are working fine man.

Thanks,
Dhinesh
WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Dhinesh28R ,

Not sure what else I can suggest - I cannot see your data, but you generally loop through one data source (collection) at a time. Maybe you need to rethink your data structure.
Dhinesh28R 599 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Okay man, All are working good man.

Thanks,
Dhinesh