Hi, Can we format the data which is displayed in gridTextColumn.

we can format data displayed in grid
Example:
data: apply( rule!getFormattedUserName,{index(local!dataSubset,"userName",{})})

Hi Deepan,
It is possible if the emailaddress belongs to an Appian user,
There is a custom plugin available for getting user object from email address.
By using the user() function we can get an user firstname from that user object.

Here is the link for that custom plugin.
forum.appian.com/.../summary

Thanks Vijay

radhaa, The result is returning null on the grid. The Rule input I used is

=concat(user(ri!user,"firstName"),user(ri!user,"lastName"))
ri!user is a type of text..

Thanks,
Deepan

deepanc, expression rule will work if you pass correct user name to that. if you would like to see the result of expression test it out side with test username.
As far as I know, null value is return in these two cases for your specifications
1. if you did null handling (if it is empty input then returning null value).
2. index(local!displaydatasubset.data,"emailaddress",{}) means there is no data , it will give empty arrray to that grid column.

Please check these two and also for debugging print local!datasubset data in any sail component like test,paragraph fields.

radhaa, Thanks for the checkpoints to be verified, I have checked with all the above scenarios, my user name is getting stored as email address and it has got the values in the record. Do you have any guess on null return.

Thanks,
Deepan

could you please attach the code

Attached is the values

sail code.docx

Embed below code in your section layout, column contents like attached code
a!textField(
label: "Print Grid data",
value: local!displaydatasubset.data
)
and check whether displaydatasubset contains data or not.

Sail Code

radhaa, Am getting list of grid values in array as output.