setting value of a column in sharepoint list as value from look up column using PowerApps and flow

(0) Share

Report

Posted on by CarlHRVA

601

Hello,

I have a pretty cool app I've been developing to be used with a document library and part of what I would like to achieve is the ability to upload a file and metadata to a document library w/ PowerApps and Flow. I've been following along with this video https://www.youtube.com/watch?v=5XsWgVnR7SU and I've been able to successfully create a file(s) but I'm stuck at the part where I add the metadata.

The metadata in question:

Column Name	Data Type	Data Source
Process ID	Single line of text	Master Process List
Process	Look up	Look up to Process ID in Master Process List
Document Type	Choice	Document Library
Document Level	Choice	Document Library
SS Index	Number	Document Library
SysIndex	Single line of text	Document Library

In the PowerApp, I want to allow users to fill out a form and enter metadata for the 5 fields in red. I am not understanding how to pass the value from the Process look up column to my variable in flow so that I can use it to set the value of the Process field in my library.

My current formula on select of my button looks like this:

PowerAppsbutton.Run(
JSON(
colDocs,
JSONFormat.IncludeBinaryData
),
ProcessDrop.Selected.Title,
DocTypeDrop.Selected.Value,
DocLevelDrop.Selected.Value,
Value(SSIndexText.Text),
SysIndexText.Text
)

"Process" is the Title column in my library and will only accept an Integer variable. when using the "Update File Properties" action in flow
DocType and Doc Level are single-choice columns and use string variables in flow.
SSIndex is a number column in the library and uses an integer variable in flow.
SysIndex is a single line of text but will only accept an integer variable in the "Update File Properties" action.

The formula returns no errors until I run the app and select the button and then it tells me that my Process_Variable has an invalid value for parameter and the flow does not run at all. I am certain I need to use the ID from the look up but I don't know how to go about that. Thank you for any and all help! @wyotim

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @CarlHRVA ,

Could you please share a screenshot about your flow's configuration?

Could you please show more details about the formula you typed within the Items property of the ProcessDrop box in your Edit form?

I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the ProcessDrop box to following:

Choices('Your SP Library'.Process)

Then modify your 'FlowName'.Run(...) formula as below:

PowerAppsbutton.Run( JSON( colDocs, JSONFormat.IncludeBinaryData ), ProcessDrop.Selected.Id, // Modify formula here DocTypeDrop.Selected.Value, DocLevelDrop.Selected.Value, Value(SSIndexText.Text), SysIndexText.Text )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like (0)

Report
Copy link

Link copied!

@v-xida-msft Thanks for your reply. The formula I am using for the Process drop down is:

Sort('Master Process List'.'Process ID','Process ID')

The formula you suggested doesn't work for me. Since the column in the master list is a single line of text, am I not able to use the choices function?

Here is a screenshot of the flow:

Thank you!

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like (1)

Report
Copy link

Link copied!

This works! My concern was that using the column from the library would only give me the values present in the library rather than all of the values in the master list but this was incorrect and my flow ran successfully after making the changes. Thank you so much!

Was this reply helpful? Yes No