Hello Dear Professionals,
I have the following problem. There is a Sharepoint library with more than 12 lookup columns that I want to retrieve data from. The following issue is that I cannot request the data directly through PowerApps.
So I've built a flow that uses a view that contains less than 12 lookup columns. The flow manages to get a response from the Get Files Properties action.
My problem is that I somehow cannot retrieve the body in PowerApps.
I tried the following things:
1.Using Respond to PowerApp or Flow Action:
The problem is that I cannot return an array, only text, file, date ...
2. Using the response action:
When using the response action i use the payload of the get file properties to get the schema and then return the body of the action.
When i do this the flow succeeds and i dont get a problem in power apps but the collection where i store the response has only 1 row which i cant realy inspect and not display in my gallery.
When I try to put body/value as a payload I get the following issue in PowerApps.
I dont know if the schema that was generated might be wrong or if im missing a step in PowerApps.
I have also tried returning a string with joint values and then splitting them again in PowerApps, but this does not work either because the gallery expects other formats.

Report
All responses (
Answers (