cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ryang
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
ryang
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

psycrkz1
Microsoft
Microsoft

Thanks for the solution 

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (29,259)