Hello everyone,
I am currently following Shane Young's tutorial on uploading an excel to a Sharepoint list (PowerApps upload file to SharePoint document library - YouTube & Power Apps import Excel to SharePoint list or any data source with Power Automate - YouTube).
However, for my specific use-case I would like the flow to not only be able to register the values within the Excel table, but also retrieve some data from a different Sharepoint record. In order to do this I need to use a 'Get Item', but to use that effectively I need to also pass an ID to the flow, alongside the upload of the attachment.
Anyone that has a solution for passing this information into the flow as well?
The current code I am using to upload:
Set(varUpload, JSON(DataImage.Image, JSONFormat.IncludeBinaryData)); //Turn the file into binary data.
Set(varBase64Only, Mid(varUpload, Find(",", varUpload)+1, Len(varUpload) - Find(",", varUpload) - 1)); //Cut ends off binary data.
Upload_Flow.Run(Last(AttachmentControl.Attachments).Name, varBase64Only); //Upload to Sharepoint
Reset(AttachmentControl); //Reset uploader
But somehow I should also be able to get the functionality of the following in the same flow run:
Upload_Flow.Run(UploadForm.LastSubmit.ID);
Help would be much appreciated!
