You’re offline. This is a read only version of the page.
Announcements
76
Hello everyone,
I have very crucial task, please anyone help me.
i have download excel report from canvas app on button click.
i write above code to download file,
in my gallery have some lookup record, but i am not able to fetch lookup record on flow.
in my flow target value, i am getting below record, but didnt received any lookup record.
Share
Report{
"Compose_Inputs":
"[{\"dt_application_request_number\":\"Request-00000234\"
,\"dt_application_request_status\":121920001,
\"dt_application_requestid\":\"xxxxxxx......\"
,\"dt_day\":1,
\"dt_description\":\"Test1\"
,\"dt_end_date\":\"2023-02-28T18:30:00.000Z\",
\"dt_start_date\":\"2023-02-28T18:30:00.000Z\"}
,{\"dt_application_request_number\":\"Request-00000235\"
,\"dt_application_request_status\":121920001,
\"dt_application_requestid\":\"xxxxx.........\"
,\"dt_day\":1,
\"dt_description\":\"Test2\"
,\"dt_end_date\":\"2023-03-01T18:30:00.000Z\"
,\"dt_start_date\":\"2023-03-01T18:30:00.000Z\"}
,{\"dt_application_request_number\":\"Request-00000236\"
,\"dt_application_request_status\":121920001
,\"dt_application_requestid\":\"xxxxxx........\"
,\"dt_day\":0.5,
\"dt_description\":\"test3\"
,\"dt_end_date\":\"2023-03-22T18:30:00.000Z\"
,\"dt_start_date\":\"2023-03-22T18:30:00.000Z\"}]"
}
1 and 2 number is my lookup record and i want to fetch this record in my flow.
Hello @DTtechies ,
You can use "AddColumns" to return a collection with new columns.
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-table-shaping
All responses (
Answers (
Set(...,
AddColumns(
gallery,
"newColumn1",
LookUp(...),
"newColumn2",
LookUp(...)
)
)
Hope this was helpful to you.
