Announcements
I'm importing a table from various registers into a CSV using "Filter" function and passing them into a JSON with "ShowColumns" in this way: Set( varJSONProjects; JSON( ShowColumns( collectionCSVRenamed; "Project"; "Description"; "User"... ); JSONFormat.IncludeBinaryData);;function, but there are some columns that have various attributes, in this case, I have a column called User and it contains that info:{ "Id": 1, "Value": "John Doe" }But I just want to keep the attribute "Value" in my CSV file.
How can I do that?
User is an object with 2 attributes.
User.Value should return "John Doe"
I know, but I can't do something like:Set( varJSONProjects; JSON( ShowColumns( collectionCSVRenamed; "Project"; "Description"; "User.Value"... ); JSONFormat.IncludeBinaryData);;
To get that "ShowColumns" selects "Value" attribute from "User"
Why not do something like
Set(userValue,User.Value);
Set( varJSONProjects; JSON( ShowColumns( collectionCSVRenamed; "Project"; "Description"; userValue... ); JSONFormat.IncludeBinaryData);;
It doesn't work,Could you help this info?It's a Sharepoint list and it's a foreign key to another list that I can access in this wayFilter( Projects; FKUser.Value = "John Doe" );; // Here its a valid search attributeFilter( Projects; FKUser.Value = "John Doe" ).FKUser.Value // It is not a valid attribute
Filter( Project; FKUser.Value = "John Doe" ).Value // This is also not a valid attribute
Are you able to investigate the output of
Filter( Projects; FKUser.Value = "John Doe" )
in the designer window like this?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 477
WarrenBelz 341 Most Valuable Professional
11manish 317
