cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Flow Invalid Argument Type (Text) Expecting Record Value

I have created a  Flow to Create a Pipeline Run in Azure Data Factory. It requires one parameter. If i do a test run and use the following as a parameter my flow runs successfully:   {"UseThisFile": "XLupload2020Jul171052245224.xlsx"}

ryang_0-1595084675265.png

When i try to trigger this from PowerApps i run in to issues.  If i use text value containing {"UseThisFile": "XLupload2020Jul171052245224.xlsx"} or XLupload2020Jul171052245224.xlsx i receive the error Invalid Argument Type (Text) Expecting Record Value.

Therefore i tried using the following:
Set(flowvar, Char(123) & Char(34) & "UseThisFile" & Char(34) & Char(58) & Char(34) & "XLupload2020Jul171052245224.xlsx" & Char(34) & Char(125));
ClearCollect(TableParameter,Table({UseThisFile:flowvar}));
xlFloww.Run(First(TableParameter));
or
Set(flowvar,"XLupload2020Jul171052245224.xlsx");

ClearCollect(TableParameter,Table({UseThisFile:flowvar}));
xlFloww.Run(First(TableParameter));

I would receive no error, however, when i check my flow run the parameter is blank

 
 
 


Essentially what I am trying to do is, upload a file to Azure Blob from PoweApps then trigger an Azure Data Factory Pipeline using the filename uploaded as a parameter. Getting the Flow to accept a parameter from PowerApps is the last part i need to figure out. Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions

Added a Compose Data Operation before my Create a Pipeline Run.

Then uses concat( '{"UseThisFile": "',outputs('Compose'), '"}')  as my Create a Pipeline Run parameter.

View solution in original post

3 REPLIES 3
Helper I
Helper I

error2.png

Forgot to attach second image

Added a Compose Data Operation before my Create a Pipeline Run.

Then uses concat( '{"UseThisFile": "',outputs('Compose'), '"}')  as my Create a Pipeline Run parameter.

View solution in original post

Microsoft
Microsoft

Thanks for the solution 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (11,932)