The JSON function encodes in base64 the result of the Image control, so I needed to convert it back to binary. The file was in Sharepoint Online without it but corrupted and not useable.
]]>Hi Asmo57,
This is what the image control does for us so there is no need to do it in Automate!
I found my error: in the File Content field in Power Automate, we need to convert from base 64 to binary, so the expression should be:
base64ToBinary(triggerBody…)
Thank you Paul, very interesting.
Unfortunately I was not able to have a working version: the process runs fine but the document is corrupted in Sharepoint (tried with Excel and png files).
I debug the two variables extracted from the JSON and they seem ok.
Automate receives the same binary value in FileContent so I do not think the problem is in Automate.
I will try to serialize the files I used to compare the JSON content.
Excellent update suggestions. Thanks!
]]>Thank you for this tutorial. I have made some changes in your setup.
1. Placed (for all Screens, in my case, 3 screens)
ClearCollect(
colTheMenu,{
Item: “Screen 1”,
Screen: Screen1
},
{
Item: “Screen 2”,
Screen: Screen2
},
{
Item: “Screen 3”,
Screen: Screen3
}
)
into the App/OnStart
2. Component MenuComponent-GalleryMenu/Items: Filter(MenuComponent.Items,App.ActiveScreen Screen)
It filters out the current screen.
Hi Pei Pei,
Yes could add the logic to the bottom of the flow.
]]>Hi Rob, The ClientID is just a field I use to filter the data set by client. You can ignore that field for the purpose of this. I only used it to show a real world example copied from an actual app. The variable for this would be set in the app on start.
]]>Hi, thank you for the post. I am unable to get ths routine to work. I understand the logic of what is happening with the “paging” of new records into the collection, but I do not understand the statement “ClientID = varClientID” or how it plays here. What does ‘ClientID’ represent, and where is the variable ‘varClientID’ Set or created?
]]>Thank you for a much needed detailed explanation, much appreciate the effort
]]>