Hello everyone,
i need your help on this one,
why does this ExcelRecords(0).Handler works in cloud studio
but does not work when i do it in app studio.
i want to assign the Processes.CaseLog_Transactions_process_QueryEntityData.out_ExcelRecords(0).Handler to a text box string type.
Hi @JomarieBancolo
This happens because App Studio is strict (typed) and Cloud Studio is flexible. In App Studio, Handler is not recognized as a direct field of that entity, so it throws an error.
Try accessing it like:
Processes…out_ExcelRecords(0)(“Handler”).ToString
Or check the exact field name in Data Service (it may be different).
yeah already did that and unfortunately it doesn’t work.
thanks for your input.
Hi @JomarieBancolo
Since out_ExcelRecords(0)("Handler") is also failing, it likely means the field is not exposed as a direct property in the entity type returned to App Studio.
A few things to verify:
- Check the exact schema/field name in Data Service or the process output.
- Confirm
out_ExcelRecords is really a DataTable/List and not a custom entity object.
- Try inspecting the object using a temporary label or log to see available fields.
- If this comes from an entity relationship/reference field, you may need to access a nested property instead of
"Handler" directly.
Example:
Processes.out_ExcelRecords(0).Handler.DisplayName
or
Processes.out_ExcelRecords(0).Properties("Handler")
depending on the object type.
App Studio enforces strong typing, so the syntax depends on the exact structure of the returned entity.
App Studio is strict (typed), so you can’t use (“Handler”)
use below :
out_ExcelRecords(0).Handler
If this still fails, it means Handler is not in the output schema (even if visible in UI).
Check with IntelliSense (Ctrl+Space) if not there, you need to add/map it in Data Service output
awesome, i saw the data mapping and it was empty ,i reloaded it and everything works now, thanks!
If this solution helped you, please mark it as the solution so it can help others as well.