Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Base64 URL can not properly viewing within the collection

(0) ShareShare
ReportReport
Posted on by 66

Hello everyone,

 

I am getting a Base64 file URL from Dataverse table via Power Automate flow. 

 

power automate-base64 format-url.png

 

I'm trying to returned the value as json format to Power Apps.

 

 

Creating a collection to see the returned value from Power Apps:

 

ltfDre_1-1702499130123.png

 

(

* Alternatively, I have tried the PowerFX formula using directly Table() function, but does not worked as expected as well

 

 

 

 

 

ClearCollect(
 col_draft_files,
 Table(ParseJSON(FindUploadFileUrl.Run(temp_process_id).upload_file_path))
);

 

 

 

 

 

)

 

When I tried to check the value within the collection that I collect, showing a question mark instead of the expected base64 file URL.

ltfDre_2-1702499144141.png

 

When I tried to check it directly from Power Automate outputs. The result is correct, but the base64 string is too long. I'm just curious about that whether the problem reason depends on that?

 

ltfDre_3-1702499420045.png

 

How to handle this issue?

 

Thanks in advance

 

 

Categories:
  • ltfDre Profile Picture
    ltfDre 66 on at
    Re: Base64 URL can not properly viewing within the collection

    Hi @v-xiaochen-msft ,

     

    I realized my mistake regarding the response scheme. 

     

    Thanks for your support.

  • Re: Base64 URL can not properly viewing within the collection

    Hi @ltfDre ,

     

    I have no idea. Please share the flow screenshot.

     

    Best Regards,

    Wearsky

  • ltfDre Profile Picture
    ltfDre 66 on at
    Re: Base64 URL can not properly viewing within the collection

    Hi  @v-xiaochen-msft ,

     

    When I tried to add response action getting this error message:

     

    Flow save failed with code 'ActionSchemaInvalid' and message 'The schema definition for action with status code '200' is not valid.

     

    Actually, it should works because the provided scheme is correct. path_string is a array variable. ExpenseID and file just append to this variable.

     

    Any idea?

  • Verified answer
    Re: Base64 URL can not properly viewing within the collection

    Hi @ltfDre ,

     

    Please try response action.

    vxiaochenmsft_0-1702518140000.png

    vxiaochenmsft_1-1702518152592.png

    [{"expenseID":"a","file":"a"}]
     
    Best Regards,
    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard