Respond to a PowerApp or Flow - Variable Sets to 'Table'

[CLISS]

Hi All

I have a Power Apps solution that uploads multiple documents to a SharePoint library and updates metadata using the Attachment control and Gallery with the Power Apps V2 trigger for parsing metadata fields:

1. 

The 'Upload Rates to SharePoint' button works nicely and the next feature I want is to add a 'success' notification for the user to confirm the files have uploaded.

I have built this into my Flow as per the screen shot below:

2. 

And I have built the variable into the Power Apps button as per below:

3. 

The problem I have is the variable I have created above gets stored in Power Apps as a 'Table' instead of text.

4. 

So when I add a 'IF' function to this button i.e.

If(

    varSuccess="Yes",

        Notify(

        "Your files have been successfully upload to the data source",

        NotificationType.Success,

        3000

    );

It can't compare the TEXT "Yes" to a Table variable.

Any ideas how I could code this better or a better way to validate the flows success/completion and notify the user?

Thanks

Craig  

[EddieE]

@CLISS 

Anything in PowerApps related to tables where there is only ever 1 record can be easily fixed by using the First() function, eg

First(varSuccess).success

I guessed the options available after the dot, just use intellisense to guide you. It could be 'result' or 'value' ... or something else.

[CLISS]

Hi Eddie

Good suggestion. I tried it for setting the variable but get the error 'received 3 arguments, expecting 2':

Set(varSuccess,
ForAll(galAttachments.AllItems As Document,
MultiUploadofFilesToSPLibrary.Run({
contentBytes: Document.Value,
name: Document.Name}
,Document.mSalesComment.Text
,Text(Document.mEffectiveFrom.SelectedDate,"[$-en-US]yyyy-mm-dd")
,Text(Document.mEffectiveTo.SelectedDate,"[$-en-US]yyyy-mm-dd")
)),First(varSuccess).success;

I then tried it for the 'IF' statement but still get the format/type error:

[EddieE · Accepted solution]

@CLISS 

You are still using a check on a Record against some Text - that's the error you are getting. Try this

If( First(varSuccess). <-- after adding the dot you should get some options to select from ie success / result / value / etc. Choose the one that is relevant to your data. You can then use your Text <--> Text comparison.

[CLISS]

Thank you, Eddie. That worked perfectly.